Leaving top cells static while scrolling

  • Thread starter Thread starter clambers
  • Start date Start date
C

clambers

Hello,

Is there any way to leave the top part of the excel document visiba
while the rest of the data scrolls up and down.

I want to be able to view the titles above my data even when I scrol
down to the bottom of the sheet.

Any help is appreciated. Thank you
 
Click the row BELOW the cells you want to keep in view, then use
Window/Freeze Panes
 
Freeze pains. Select cell below the titles. If titles are in A1, B2 etc.
Click A2 and then click the window menu and freeze pains.

RAC
 
Click on the row below the data you wish to remain
visible, then select the "Window" menu and select "Freeze
Panes" ..... this should do it !!!!
 

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


Back
Top