Creating a Frame in Excel 2003

N

nicfd

Hi. Just wondering if anybody could help me with this.

I am inputting data on a particular spreadsheet regularly. Is there any way
I can create a sort of frame for the page so that when I scroll down, the
headings are always above the line in which I'm trying to type? Any help
would be appreciated as there are a lot of headings and it's annoying having
to scroll to the top of the page just to find out what the next few headings
are. Also, if you can do this, will it affect a print out?

Thanks in advance,

nicfd
 
J

Joel

Select the cell below the header in column A. Then go to Window - Freeze
Pane. this will not effect Printing. There is a serperate ption for
Printing header at the top of each Page


File - Page Setup - Sheet - rows to repeat at top of each page
 

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

how do I sort data excluidng headings? 2
Printing a blank spreadsheet 4
column headings 2
Creating a form with different size lines 3
Excel - not everything is printing out? 1
In XCEL? How do I set the heading-cells to appear on every page? 1
frame style effect required 5
Nested grouping of hierarchical headings during/after import 1

Top