Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heading on each page
How do I set up that the heading of the colums prints off on each page. I'm
using v.2007. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heading on each page
Open the Page Layout tab
Look for the Page Setup group (second from left) Click Print Titles (last item in group) Fill in the Rows to Repeat ... on the dialog box (eg $1:$2 to repeat the first two rows on each page) For more search Help with: <Row to Repeat as your search term best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "slavenp" wrote in message ... How do I set up that the heading of the colums prints off on each page. I'm using v.2007. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show heading on page 1 only in Excel. | Excel Discussion (Misc queries) | |||
Page Heading | Excel Discussion (Misc queries) | |||
Heading at the top of page... | Excel Worksheet Functions | |||
print heading row on every page | Excel Discussion (Misc queries) | |||
how do i get heading in first page appear automatically in all | New Users to Excel |