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

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

Gord Dibben

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

Freeze pane 3
How do I freeze a row in Excel 2003 ? 1
How do I freeze a row other than the top one? 1
How do I stop Excel from automatically resizing my row height? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Is there a way to freeze the Header Row while in report View inAccess 2007? 1
How do I pick row 3 to be the header row in Excel 1
How do I freeze a row and column 2

Top