table size, too many columns

K

KRK

Hello,

I have a worksheet (excel 2007) which has 14 columns. For reasons I do not
understand there seem to be several hundred extra empty columns to the right
of my data. Whenever I try to print, the program wants to print far too many
pages. What have I done ?

Thanks

KK
 
R

Roger Govier

Hi

Select column 15>Control+Shift+right arrow to select out to the end of the
sheet>right click>Delete.
Save the file
Press Control+End and see where that takes you.

If it is taking you way beyond your last row, then repeat procedure above,
by selecting the row after your last used row>Control+Shift+Down arrow>Right
click>Delete>Save
 
D

Dave

Hi KK,
You could just set the print area to contain only your data. (Select
your data range, File menu, Print Area, Set Print Area)
One possible reason for your problem is that there is a rogue entry in
a cell which is a long way away from your data. If the columns to the
right of your data are supposed to be blank, select hundreds of them,
then right click, Delete. This will get rid of unwanted data.
Dave.
 
K

KRK

Roger, this worked nicely, thanks

K


Roger Govier said:
Hi

Select column 15>Control+Shift+right arrow to select out to the end of the
sheet>right click>Delete.
Save the file
Press Control+End and see where that takes you.

If it is taking you way beyond your last row, then repeat procedure above,
by selecting the row after your last used row>Control+Shift+Down
arrow>Right click>Delete>Save
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top