Make one row a constant display?
MRW, select A2, then window, freeze panes
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"MRW" wrote in message
oups.com...
Hi all,
I've been searching Google, but I haven't found anything, yet. I wanted
to make a row in my list constant, so I can correlate the data with its
type easily. The data type is specified in the first row of the list.
I thought Pivot Tables would do the job, but I guess it's the wrong
function. Any tips how I can do this?
My list looks like:
Name | Grade | Level
------------------------------
Joe1,A,12
Jim2,B,13
.......
I want it so that when I scroll down the list Name, Grade, and Level
stay put.
Thanks for the tip!
|