Get column headings to float when scrolling down?

W

Wendy

How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below?
 
T

tim m

Put your cursor just below the lines you want to float and then 'freeze
panes' (I'm not sure which version of excel you are working with.)
 
T

T. Valko

Let's assume you have column headers in A1, A2 and A3.

Select cell A4
Goto the menu Window>Freeze Panes
 
G

Gord Dibben

Select A4 and Window>Freeze Panes.

Rows 1 to 3 will remain in view as you scroll down the sheet.


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

I don't want row 1 as the column headings 1
How do I keep the headings visible while scrolling down in Excell 2
Excel headings 2
Column Headings 3
Need field at top to float down as I scroll down? 3
how do you have the headings scroll down the page as you move dow 1
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS 7
Freezing column headings 2

Top