I found out how to get the column headings to print on each page, but what about when viewing/entering data on the spread sheet. If there are a large number of columns on the spread sheet when the headings scroll off it makes it hard to know what columns contain what data. Is there any way to keep the headings displayed on the screen? Hope this question makes sense.

Fay

I really don't understand... screen shots would help me

Sam,

I haven't figured out the upload here yet. I'll try another explanation if that doesn't explain it, I'll try to figure out the upload.

Say I have a spread sheet containing columns of amounts for different things. I set up the cells in row 1 - to contain a description of the amounts. the rest of the rows contains the amounts. I can set up the spread sheet so that the descriptions in row 1 print on each page. But when I am viewing and entering data into the spread sheet, row 1 scrolls off the screen as I enter lines more lines into the spread sheet. Is there anyway of keeping row 1 displayed on the screen so that I can see what goes it which column?

Fay

Yes, on the menu bar, select Window > Split. This will split the document into 2 windows. You can hover your cursor over the horizontal bar that "splits" the document until it changes into 2 horizontal parallel bars with upper and lower vertical arrows to adjust the split window appearance you want, i.e., have the column descriptions only in the upper window, and the rest of the document in the lower window.

To remove the split window, select Window > Remove Split.

To upload images, go to Samantha's tutorial here:

http://geeksgeeksmoregeeks.forumotion.net/board-functions-f12/adding-images-using-the-image-host-on-this-board-t464.htm#686

Repa,

I have office 2007 and it took me a couple to find the split, but then I was able to get it to work. Now, I'll have to see if I can figure out how to show/explain to a friend of mine. I may be helping her set up a spread sheet (she has not decided for sure yet). She doesn't know anything about EXCEL and is nervous about trying new things on the computer. Not sure If I'll be able to get her doing this, but it will help be out on some of my spread sheets. I have been having to scroll back up to check which columns are which. This will help me out a lot.

Thanks soooooo much.
Fay

I was playing around with this and happened to discover that in addition to the split , there is a freeze panes that can accomplish the task. It is located on the same menu as the split. you can freeze both column and row headers. Wow - so much to learn.

Fay

Yep, that's in Excel 2000 as well.