From Leo's mailbag:
> From: A Computer User
> Sent: October 30, 2006
> To: Ask Leo!
> Subject: "Static" line as first row of an excel worksheet
>
> Leo,
> When working in Excel XP, I page down and lose the column
> headings. When I enter data, I'm not sure if I put it in the
> correct column. My IT son mentioned that I can use a "Static"
> line as the 1st row in my workbook. All the other rows would
> supposedly “fold up” under this line and I would
> be able to see column headings as I page down. Those with
> kids will understand me saying that he has not made telling
> me “how” to do this a priority. Can you help me instead?
The feature you're looking for is called "freeze panes". My
friend Allen Wyatt's Excel Tips website has this on that:
http://exceltips.vitalnews.com/Pages/T0608_Displaying_Row_and_Column_Labels.html
Thanks for asking,
Leo
Article 10864
| Category:
Microsoft Office
