Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
table size, too many columns
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
table size, too many columns
Hi
Select column 15Control+Shift+right arrow to select out to the end of the sheetright clickDelete. 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 rowControl+Shift+Down arrowRight clickDeleteSave -- Regards Roger Govier "KRK" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
table size, too many columns
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
table size, too many columns - Thanks
Roger, this worked nicely, thanks
K "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Select column 15Control+Shift+right arrow to select out to the end of the sheetright clickDelete. 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 rowControl+Shift+Down arrowRight clickDeleteSave -- Regards Roger Govier "KRK" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Size | Charts and Charting in Excel | |||
Auto size a pivot table to a page size | Excel Worksheet Functions | |||
can you have different size columns vertically on one worksheet | Excel Discussion (Misc queries) | |||
What is the limit size for columns in Excel??? | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |