Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Excess
how to remove excess columns and rows?
other than Hide it or colour it? any others way to remove, so that others cant see? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Excess
All worksheets have a fixed number of rows and columns (65536/256 in
version previous to XL07, more in XL07). If you delete one, one will be added at the end. What are you trying to do that hiding doesn't work? In article , kyoshirou wrote: how to remove excess columns and rows? other than Hide it or colour it? any others way to remove, so that others cant see? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Excess
Excel will print up to the last used cell, which can
be found with Ctrl+End and is at the intersection of the last used row and the last used column. If the last cell is not where you think it should be you may have to fix it, as Excel does not normally fix it when it removes rows or columns but remembers where it had gotten up to. Some information at http://www.mvps.org/dmcritchie/excel/lastcell.htm but if you want to fix the entire workbook, suggest using the macro and don't even try to do this manually, see Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish. Warning: merged cells problems -- a merged cell has content only in the upper left cell of a merged cell group so you don't want you last cell to hit within a merged cell. http://www.contextures.com/xlfaqApp.html#Unused -- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "kyoshirou" wrote in message ... how to remove excess columns and rows? other than Hide it or colour it? any others way to remove, so that others cant see? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excess text reverts to ######## , any way around this? | Excel Discussion (Misc queries) | |||
would like help in Excess | Excel Worksheet Functions | |||
I have forgotten my password and have no excess | Excel Worksheet Functions | |||
How do you remove excess spaces from an Excel field? | Excel Discussion (Misc queries) | |||
Excess columns | New Users to Excel |