Hide rows in excel

O

Optiglaze

Hi,

If I need to hide a large bunch of rows, ie 25 through 65535 is there
somewhere I can specify this rather than spending minutes scrolling?

Thanks,

Rick
 
R

Roger Govier

Hi

In the Name box (left of column A) type in 25:65536 and press Enter
Right click>Hide

Regards

Roger Govier
 
M

Mladen_Dj

To skip scrolling, select row25, press <ctrl>+<shift>+<down arrow>, and rows
25-65536 will be selected. Hide rows.
 
Top