How do I keep the top row of a spread sheet visable?

G

Guest

How do I keep the top row of a spread sheet visable while scrolling down the
screen?
 
N

Niek Otten

Select A2
Window>Freeze Panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I keep the top row of a spread sheet visable while scrolling down the
| screen?
 

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

always visable header row 3
Excel Monthly Spread sheet. 12
freeze column and row on same spread sheet 2
how do I achieve my xl spread sheet in Alphabetical order 1
Inserting rows in a protected sheet - Office 2003 2
How can I make the autosum refer to visable rows / filter? 6
delete a spread sheet 4
sum of visable cells in filtered range 7

Top