ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide Rows (https://www.excelbanter.com/excel-discussion-misc-queries/12344-hide-rows.html)

Steve

Hide Rows
 
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

Don Guillett

Hold down the control keyselect by row numberhide
or write a macro to hide (use MOD)

--
Don Guillett
SalesAid Software

"Steve" wrote in message
...
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




Gordon

Steve wrote:
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


Be VERY wary hiding rows, they can play havoc when copying formulae and
other operations.

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com