View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
marina marina is offline
external usenet poster
 
Posts: 12
Default How do I insert multiple page breaks simultaneously in Excel?

I have a spreadsheet with multiple entries that have to be printed on
separate pages. I thought I could select the rows by clicking on the row and
Ctrl and then click on Insert Page Break - and boom, it will insert all 150
page breaks. Or do I really have to spend a whole hour doing this mindless
task manually? Please help.