extra rows and columns

How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.

Select the rows. FormatRowsHide.
Same for columns

--
Kind regards,

Niek Otten

"Wooster" wrote in message
...
How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.

Wooster wrote:
How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.
Highlite the columns right click select hide. Rows work the same way.

gls858

Hi Wooster,
Hiding columns and rows is fine if you have data in there that you do not want to
show. But if the purpose is to hide or not print because the last cell indication
is wrong (ctrl+end), then you should fix your spreadsheets and the empty
rows and columns are using up space in the workbook.

The use of the PrintArea or hiding cells is frequently used to mask other
problems. If you delete rows or columns Excel remembers that you used up to
certain rows and columns, and will not reset that indication when you delete
rows or columns. So Excel still thinks your are using rows and columns that
you are not.

The easiest to use and fix the entire workbook at once was the macro in the
following article: Did you stop reading before you got to the DeleteUnused macro.
"Why do my scrollbars go to row 500 -- my data ends in cell E50?"
http://www.contextures.com/xlfaqApp.html#Unused

There is no save in the DeleteUnused macro, you will have to save the file when the
macro finishes, or before you exit Excel.. You want to use the macro. You will simply not be able to do
it manually with consistency.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wooster" wrote in message ...
How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.