Shifting Cells

[Frank Kabel]

Hi
not quite sure I understood you. But if you want to see always the
first row of your sheet try the following
- move the cursor in cell A2
- Goto 'Window - Freeze Panes'

--
Regards
Frank Kabel
Frankfurt, Germany

Steve Loerop wrote:
> I want to have my column headers follow down as I progress downward
> on my spreadsheet. How would I set this up?

[Ken Wright]

Click on cell A2 and hit Window / Freeze Panes

If you want to freeze the left column as well, start on cell B2 and do it

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Steve Loerop" <slo...@drummondindustries.com> wrote in message
news:DEAD2677-B7DC-48C0...@microsoft.com...

> I want to have my column headers follow down as I progress downward on my
spreadsheet. How would I set this up?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004

[David McRitchie]

and if you are thinking in terms of also having them repeated
when you print that is done in file, page setup, sheets, ...
rows to repeat at top: $1:$1
columns to repeat at left: $A:$A
you do not need to start at the top like when you freez
rows, you can start later and the they will not be in effect
until your printing gets that far (logically). More informatiom in
http://www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Frank Kabel" <frank...@freenet.de> wrote ///

> not quite sure I understood you. But if you want to see always the
> first row of your sheet try the following
> - move the cursor in cell A2
> - Goto 'Window - Freeze Panes'
>