Insert Multiple Page Breaks

H

heater

I have a spreadsheet that I want to insert a page break after each row. Is
there a way to do this faster than just highlighting each row and going to
Insert - Page Break? I need to do this for about 100 rows.
 
D

Dave Peterson

Insert the pagebreak once, select a new cell and hit F4 (repeat last action)???

If you get both hands moving, you'll be able to hit the downarrow, F4,
downarrow, F4, ...

Probably lots quicker than any macro solution, too!
 
Top