View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Insert Multiple Page Breaks

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!

heater wrote:

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.


--

Dave Peterson