| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the headings visible while scrolling down in Excell | Excel Worksheet Functions | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| How to keep colunm headings when scrolling down in excel | Excel Discussion (Misc queries) | |||
| Possible to make first column float? | Excel Discussion (Misc queries) | |||
| how to make column titles float with the scroll bar | Excel Discussion (Misc queries) | |||
Linear Mode
