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? |
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? |
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? |
All times are GMT +1. The time now is 04:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com