EXCEL Worksheet

[Guest]

Can anyone tell me how to eliminate the extra cells that display on an EXCEL
Worksheet? I got one back that now displays 66000 rows. This makes it hard
to navigate.

 

[Peo Sjoblom]

Hide the ones you don't need


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Rick Rothstein \(MVP - VB\)]

Can anyone tell me how to eliminate the extra cells that display on

an EXCEL Worksheet? I got one back that now displays 66000
rows. This makes it hard to navigate.

As Peo suggested, hide the ones you don't want. On the assumption you don't
know how to do this...

Click on the number in the header of the first row you want to hide. Next,
depress and hold down the Control and Shift keys... while they are down,
press the End key followed by the Right Arrow key. This will select all of
the rows from the first row you clicked on up to the last row on the grid.
Next, click Format/Row/Hide from the Excel menu. You can repeat this
procedure to hide columns as well (just choose Format/Column/Hide from the
menu (notice it is Column this time, not Row) when you get to that stage in
the procedure.

Rick