If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Get column headings to float when scrolling down?
How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below? |
#2
|
|||
|
|||
Get column headings to float when scrolling down?
Put your cursor just below the lines you want to float and then 'freeze
panes' (I'm not sure which version of excel you are working with.) "Wendy" wrote: How do I get the first three or four lines where I have typed in my column headings to "float" down as I'm entering information in the lines below? |
#3
|
|||
|
|||
Get column headings to float when scrolling down?
Let's assume you have column headers in A1, A2 and A3.
Select cell A4 Goto the menu WindowFreeze Panes -- Biff Microsoft Excel MVP "Wendy" wrote in message ... How do I get the first three or four lines where I have typed in my column headings to "float" down as I'm entering information in the lines below? |
#4
|
|||
|
|||
Get column headings to float when scrolling down?
Select A4 and WindowFreeze Panes.
Rows 1 to 3 will remain in view as you scroll down the sheet. Gord Dibben MS Excel MVP On Fri, 28 May 2010 07:13:01 -0700, Wendy wrote: How do I get the first three or four lines where I have typed in my column headings to "float" down as I'm entering information in the lines below? |
Thread Tools | |
Display Modes | |
|
|