#1
|
||||
|
||||
Freeze top row and column in the same sheet.
Hello all,
I am a spreadsheet nad I would like to block the top row and column in the same time. Is it possible? I have tried bu it seems that if I 2lock" one , the other "unlocks". Thank you. |
#2
|
|||
|
|||
A quick google reveals VBA maybe the only way to achieve this...
https://www.extendoffice.com/documen...le-sheets.html |
#3
|
||||
|
||||
I solved in a different way .
Shift+1 and A and then freeze . thank you for the prompt reply |
#4
|
|||
|
|||
Sure, glad you have what you need.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export Data on new Sheet with same Id of that column | randhawa_125 | Excel | 4 | 02-23-2015 10:29 AM |
Sorting a long column and printing it on 1 sheet | skbutler | Excel | 2 | 01-13-2015 05:06 PM |
Freeze more than just the top row, or first column | Gary Drumm | Excel | 4 | 07-23-2013 11:34 AM |
Possible to freeze both a column and a row? | bryanarn | Excel | 2 | 03-11-2012 09:54 AM |
Make row in one sheet equal column of another | hypertyper | Excel | 6 | 01-31-2012 03:48 PM |