How do I fix (prevent scrolling) of part of an Excel worksheet?

K

katherin

How do I fix the first few rows of a .xls file so that they remain visible
when I scroll the worksheet down?
 
P

Pete_UK

Suppose you want the top 4 rows to remain on screen as you scroll
down. Position the cursor in cell A5 then click on Window | Freeze
Panes.

If you also want the first column to be visible if you scroll to the
side, put your cursor in B5 and then Window | Freeze Panes.

Hope this helps.

Pete
 
E

Eduardo

Hi,
Use Freeze Pannels, Position yourself one row down the data you want to be
visible and then go to the menu, Window, Freeze pannels
 

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

How to make scroll bar permanently visible, Word 365 0
Dealing with the error: unable to filter on excel hc home school 0
Read Only now different 1
Document Merge Formatting Issue 0
How do I freeze the swimlane headers? 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Embed the same Excel multiple times 0
Scroll does not show preview 0

Top