Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lock Rows
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 |
#2
|
|||
|
|||
Go into A6 and then go to window/freeze panes
"Anthony" wrote: 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 |
#3
|
|||
|
|||
Matthew,
yep - just found out how to do it by looking at old postings. But thanks for posting ur help regds Anthony "matthew" wrote: Go into A6 and then go to window/freeze panes "Anthony" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |