How do I make JUST the header row always visible in Excel? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              t.261 10/30/2006 10:03 AM PST   Question   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?     Was this post helpful to you?         Reply |   Top           PCLIVE 10/30/2006 10:13 AM PST   Answer   Click on cell B2. Then Freeze Panes. Regards, Paul "t.261" <t.261@discussions.microsoft.com> wrote in message news:DE2F51CD-BFA4-409C-8970-6C31EE60A548@microsoft.com... > 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?     Was this post helpful to you?         Reply |   Top           Gord Dibben 10/30/2006 11:03 AM PST   The rule for freezing rows and columns is........... Rows and columns above and left of the selected cell will be frozen. Select B2 then Window>Freeze 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 <t.261@discussions.microsoft.com> 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?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies