As I move down my spread sheet how can I get the header titles to follow me
down as I make my entries?
As I move down my spread sheet how can I get the header titles to follow me
down as I make my entries?
Hi Kawasaki
if you select row 2 and then go to the windows menu at the top of the
screen
and select freeze panes, that shoud do it
one way
select the first cell under your headings and use the menu "Windows" and
select Freeze panes.
the other way,
With a normal window without froozen panes, move the mouse pointer to the
top right corner just above the up arrow. The pointer will change to an up
and down arrow.
Left click and drag down to create enough room for your heading.
You now have two seperate windows of your sheet.
--
Greetings from New Zealand
Bill K
"Kawasaki" <[email protected]> wrote in message
news:[email protected]...
> As I move down my spread sheet how can I get the header titles to follow
> me
> down as I make my entries?
Hi Kawasaki,
You will also want to keep the column titles at the top of each sheet
when you print. File, Page Setup, Sheet, rows to repeat at top: $A:$A
More information both Freeze and Rows to Repeat and similar things in
http://www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Bill Kuunders" <[email protected]> wrote in message news:[email protected]...
> one way
> select the first cell under your headings and use the menu "Windows" and
> select Freeze panes.
>
> the other way,
> With a normal window without froozen panes, move the mouse pointer to the
> top right corner just above the up arrow. The pointer will change to an up
> and down arrow.
> Left click and drag down to create enough room for your heading.
> You now have two seperate windows of your sheet.
> --
> Greetings from New Zealand
> Bill K
>
>
>
> "Kawasaki" <[email protected]> wrote in message
> news:[email protected]...
> > As I move down my spread sheet how can I get the header titles to follow
> > me
> > down as I make my entries?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks