Delete all nonused rows and colums "Part2"

  • Thread starter Thread starter Marcus Pedersén
  • Start date Start date
M

Marcus Pedersén

Hello!
Please help me with a problem in Excel 98 that I havn´t been able to figure
out.
When Im finished with my workbook and want it to look neat I want do delete
(or hide) all colums and rows that Im not using on the worksheet so only the
"used" part of the sheet is displayed. How do I do that?

Please help me!

Many thanks in advance!

Marcus
Click to expand...

Thanks for the help with select, hide and delete but if I want to hide the
rest of the rows on the worksheet there is thousens of rows to hide and
there must be a better way then to select all these rows. I have tried and
Excel tells me that it can not show all rows.
Please help again!!

Many thanks in advance!!

Marcus
 
one way:

Assume your last used row is row 50.

In the Name box on the left side of the Formula Bar, type

51:65535

and hit Return. This selects all the unused rows. You can then choose
Format/Row/Hide

Similarly with Columns, e.g., if the last used column is column Z, then
enter AA:IV in the Name Box.
 
Hi Marcus

select the first cell in the first unused row and press Crtl, Shift and Down
Arrow then Format, Row, Hide.
similarly, for colums get the first unused column, press Ctrl, Shift and
Right Arrow the Format, Column, Hide.

To get the rows and columns back again, click the square at the intersection
of the row and column headings and unhide either columns or rows
 
Back
Top