Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
As I move down my spread sheet how can I get the header titles to follow me
down as I make my entries? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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" wrote in message ... As I move down my spread sheet how can I get the header titles to follow me down as I make my entries? |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... As I move down my spread sheet how can I get the header titles to follow me down as I make my entries? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Master spread sheet to manage then show info on seperate tabs | Excel Worksheet Functions | |||
I'm creating a simple spread sheet | Excel Discussion (Misc queries) | |||
Can I add more columns to a spread sheet or is limit 256 columns | Excel Discussion (Misc queries) | |||
Excel Slow to open Spread Sheet from Explorer | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |