Lock Row as Header

W

Wayne

-----Original Message-----
How do I lock a row or column so that it is always at the
head of the wksht?

Thanks,
Matthew
.
Hello Matthew
You want to Freeze Panes.
I will expain how to freeze rows(at top) and columns(at
left). Why would you want to do this? You may have
headings that you wish to see even if all the other
information is not displayed on one monitor screen.
Select horizontal bar immediately above up arrow on right
scrollbar. Move down to select number of rows. Select
vertical bar immediately right of right arrow on bottom
scrollbar. Move left to select number of columns. Select
Window on Menu Bar. Select Freeze Panes. To remove
Freeze. Select Window on Menu Bar. Select Unfreeze Panes.
Have a good day.
 

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

Top