View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Print row and headings/labels on every page in Excel?

You insert page breaks by moving to the row where the break is to occur and
clicking INSERT in the menu and selecting PAGE BREAK. You can also change
the view by clicking VIEW in the menu and selecting PAGE BREAK PREVIEW. You
can then use the mouse to move the page breaks up or down.

As for heading rows click on FILE in the menu, select PAGE SETUP and click
the SHEET tab. In the print titles panel enter the row/columns you want
repeated, or click the button at the end of the text box to select the
row/columns from the spreadsheet with your mouse.
--
Kevin Backmann


"Marygrace~" wrote:

I pulled up the help screen and can see that there is a way to get the titles
to show on each page, but can't get it to open.

Also, want to make a new page, making my own page break like in Word - with
Control Enter. Not sure how to do this.

How do you get the help to access the help too.