| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make JUST the header row always visible in Excel?
I'm trying to manipulate data in a very large spreadsheet and need to keep
just the header row visible at all times while scrolling. The freeze option freezes too many rows at one time. Can I adjust that somehow to freeze one row and one column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make JUST the header row always visible in Excel?
Click on cell B2. Then Freeze Panes.
Regards, Paul "t.261" wrote in message ... I'm trying to manipulate data in a very large spreadsheet and need to keep just the header row visible at all times while scrolling. The freeze option freezes too many rows at one time. Can I adjust that somehow to freeze one row and one column? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make JUST the header row always visible in Excel?
The rule for freezing rows and columns is...........
Rows and columns above and left of the selected cell will be frozen. Select B2 then WindowFreeze Panes. Row 1 and Column A will be frozen. If you select A1 then the freeze line will be at mid-window. Gord Dibben MS Excel MVP On Mon, 30 Oct 2006 09:04:01 -0800, t.261 wrote: I'm trying to manipulate data in a very large spreadsheet and need to keep just the header row visible at all times while scrolling. The freeze option freezes too many rows at one time. Can I adjust that somehow to freeze one row and one column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Sort does not recognize the header row | New Users to Excel | |||
| Can I use a header or footer more than 255 characters in Excel? | Excel Discussion (Misc queries) | |||
| Can I use a header or footer more than 255 characters in Excel? | Excel Worksheet Functions | |||
| Default header in Excel under page set-up | Excel Discussion (Misc queries) | |||
Linear Mode
