Insert Multiple Page Breaks

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

Guest

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.
 
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!
 

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

Inserting page breaks 3
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Vertical page breaks - one per column 1
Hiding rows and printing 1
how to make a preforated page-break insert 2
How can I insert data into my spreadsheet without the page breaks. 1
Page break when data changes.... 7
Page break dosen't break 4

Back
Top