Heading Problem
Hi Friends I am New Here I Need A Solution On Headings In Excel 2007.
I am a Admin Assistant and my boss needs a excel sheet which contains heading and need to view those headings while dragging the sheet and also needed to view while printing. Is there any solution for this. Kindly Help Me To Get Out Of This Issues.
Sorry For My Poor Language If You People Find Difficult In Reading The Above Query.........
hi,
Welcome to the Forum
For moving within the sheet:
In Excel 2007, select the cell in the row below the Headers that you want to remain visible, click on View & then choose one of the options from the Freeze Panes dropdown on the ribbon.
When printing:
In Excel 2007, click on Page Layout, click on Print Titles, choose the Sheet tab on the popup dialog box, click on the red arrow at the right of "Rows to repeat at top", then use your mouse to select the header rows that you want printed on every sheet and press [Ok].
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks