DVD inventory with Excel question

[nathanaa]

I use Excel for my DVD inventory, and I hope someone can provide some guidance on how to perform this neat function I saw.

I don't know what the function is called, but I saw at an office an Excel worksheet that had at the top of the cell window several cells that were kind of "locked" at the top, and had the column titles in them. Then, you could scroll down through all the hundreds of cells below, and the "locked" cells didn't move, so you could always see what each column heading was.

Does anyone know how to activate this function, or set it up? I've been playing with my Excel for a couple hours and can't figure it out. Someone else I talked to said they had seen that too, didn't know what it was called, but thought that when the worksheet was printed, the column headings/locked cells automatically printed at the top of each page. THAT would be fantastic, if true.

I would appreciate any help with this, thanks!

[Bodyslide]

http://www.ozgrid.com/Excel/freeze-panes.htm

Enjoy

[SingSing]

Select the second row, then select windows, then freeze pane.

[nathanaa]

Aha, perfect, thanks for the help. Now I just hope it will print that way too! <Anyone know how to set that up if it doesn't do it with Freeze Panes?>

[grannyGeek]

It won't print that way by just using the Freeze Panes button.

but, you can select the entire data area EXCEPT the top "frozen" rows, and set that as the Print Area.

Then go to File> Page Setup > and on the "Sheet" tab, go to the "Rows to Repeat At Top" box. Type in 1:3, or however many rows you want to show at the top of each printed page. Don't forget the colon!

hope this helps

granny

EDIT Added PS
Easiest way to select the data area -
First do File Save to lock in the "used area".
Click and drag across the top row of data (not your header rows) to select.
Press F8 key to lock the selection
Press CTRL End and the selection will expand to cover all the used rows.

Now you can go to File > Print Area > Set Print Area.

hope this is useful