How do I make JUST the header row always visible in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I freeze a row other than the top one? 1
Freeze pane 3
Trouble Freezing Panes in Excel 2003 2
How do I stop Excel from automatically resizing my row height? 0
locking multiple rows in excel 03 2
Excel 2007 - freeze multiple panes? 2
How do I freeze a row in Excel 2003 ? 1
always visable header row 3

Back
Top