Hide Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a quick way to hide every other row starting at row 12? I.E. hide
rows 12, 14, 16, 18 and so on.

Thanks,
Steve
 
Hold down the control key>select by row number>hide
or write a macro to hide (use MOD)
 
Steve said:
Is there a quick way to hide every other row starting at row 12? I.E. hide
rows 12, 14, 16, 18 and so on.

Thanks,
Steve
Click to expand...

Be VERY wary hiding rows, they can play havoc when copying formulae and
other operations.
 
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

Transpose, but how? 0
Help with last 7 days running total 11
Using AutoFilter from VBA 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Filter/Hide 4
Hide rows in table based on 1 empty cel of the same row. 1
After Macro runs, no cell activated - what am I missing? 2
Excel EXCEL - using a date dependant formula to hide rows 3

Back
Top