Got an idea how to freeze/split panes under a row in the middle of a
spreadsheet:
group rows above the header row (the one you want always to be seen)
close this group
split or freeze panes below the header row.
splitting will allow you to return easily to the rows above the header row,
simply by opening the group and may be adjusting the splitting line.
--
Costia


"Dave Peterson" wrote:

Select a cell in row 2.

john wrote:

When I do this in Cell A1 it freezes rows 1 through 16. I only want to freeze
row 1. Please advise. Thanks

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath & to
the right of what you want to stay "frozen" and then use the window / freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.




--

Dave Peterson