Hide rows in excel

  • Thread starter Thread starter Optiglaze
  • Start date Start date
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
 
Hi

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

Regards

Roger Govier
 
To skip scrolling, select row25, press <ctrl>+<shift>+<down arrow>, and rows
25-65536 will be selected. Hide rows.
 
Mladen_Dj said:
To skip scrolling, select row25, press <ctrl>+<shift>+<down arrow>, and rows
25-65536 will be selected. Hide rows.
Click to expand...


Thanks guys.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide rows in table based on 1 empty cel of the same row. 1
Hide Row Numbers/Column Letter in VBA 1
Excel EXCEL - using a date dependant formula to hide rows 3
Hiding Rows with False 3
Hiding a button when hiding rows 5
Hide Rows per criteria 7
Code to hide rows if cell in another WS is ="No" 11
hiding blank rows 3

Back
Top