Floating headed cell

I am setting up a spread sheet which has long columns, but when I am
entering the figures well down the spread sheet I keep forgetting what
column is what, can I have the header row float down the spread sheet with
me all the time.

Dave

Dave

Select A2 and Window>Freeze Panes.

The rule for frozen panes is........

everything above and left of the selected cell will be frozen.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 20:00:29 GMT, "Dave Elenor" <[email protected]>
wrote:

>I am setting up a spread sheet which has long columns, but when I am
>entering the figures well down the spread sheet I keep forgetting what
>column is what, can I have the header row float down the spread sheet with
>me all the time.
>
>Dave
>

Select cell A2. Choose Window/Freeze Panes.


In article <[email protected]>,
"Dave Elenor" <[email protected]> wrote:

> I am setting up a spread sheet which has long columns, but when I am
> entering the figures well down the spread sheet I keep forgetting what
> column is what, can I have the header row float down the spread sheet with
> me all the time.
>
> Dave

Thanks, it works great


"Dave Elenor" <[email protected]> wrote in message
news:[email protected]...
>I am setting up a spread sheet which has long columns, but when I am
>entering the figures well down the spread sheet I keep forgetting what
>column is what, can I have the header row float down the spread sheet with
>me all the time.
>
> Dave
>

You can either click in the row below your column headings and click on
Window->Freeze Panes (see http://www.allaboutoffice.co.uk/exfreeze.htm ) or
you can use Excel's split bars to split the window see
http://www.allaboutoffice.co.uk/exsplit.htm

Andrea Jones

"Dave Elenor" wrote:

> I am setting up a spread sheet which has long columns, but when I am
> entering the figures well down the spread sheet I keep forgetting what
> column is what, can I have the header row float down the spread sheet with
> me all the time.
>
> Dave
>
>
>