Get column headings to float when scrolling down?

  • Thread starter Thread starter Wendy
  • Start date Start date
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?
 
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.)
 
Let's assume you have column headers in A1, A2 and A3.

Select cell A4
Goto the menu Window>Freeze Panes
 
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

Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Need field at top to float down as I scroll down? 3
How do I keep the headings visible while scrolling down in Excell 2
Floating Cells 8
How can I make a column "float" as I scroll horizontally? 4
how do you have the headings scroll down the page as you move dow 1
How do I create a floating column? 2
Make the heading follow when scrolling? 1

Back
Top