|
|
#1
11-26-2016, 08:11 AM
|
||||
|
||||
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
11-26-2016, 08:19 AM
|
|||
|
|||
|
A quick google reveals VBA maybe the only way to achieve this...
https://www.extendoffice.com/documen...le-sheets.html
|
|
#4
11-26-2016, 08:40 AM
|
|||
|
|||
|
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 |
Windows 7 64bit 
Office 2010 64bit
.
Linear Mode
