Lock Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a worksheet where the first 5 rows (A1:A5) hold a number of headings
which I want to be locked. ie when the user fills the current screen with
data and wishes to scroll down using the vertical scroll bar, the actual
headings don't dissapear from the screen.

Easy enough, but can't figure out how.
Thanks
Anthony
 
Matthew,
yep - just found out how to do it by looking at old postings.
But thanks for posting ur help
regds
Anthony
 
You must log in or register to reply here.

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

Lock column/row in place 1
How do I lock a screen to prevent scrolling? 5
Row numbers are blue 1
Deleting rows to resize workspace 1
Vertical scroll bar length 1
Restore bottom scroll bar (Excel 2007) 4
Lock Row as Header 0
Excel Cannot delete empty cells/rows 4

Back
Top