G
Guest
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.
example I will not use column P -ZZ or row 55-1,000.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
Select the rows. Format>Rows>Hide.
Same for columns
Same for columns
G
gls858
Highlite the columns right click select hide. Rows work the same way.Wooster said: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.
gls858
D
David McRitchie
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.
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.
--
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.
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.
--