|
haroldo
Member
2015-Jan-30 10:19 am
[Excel] Freeze top row and first columnIf I recall correctly, in Excel 2003 (?) you could drag a handle down from the top of the side slider bar to freeze the top row(s)...and do the same at the left of the bottom slider bar to freeze the first column(s). At work, I use a heavily crippled generic shell version of Excel (I think it's 2010?)...it has the Ribbon Bar. In any event, under View/Freeze Panes I can either freeze the top row or the first column...but not both. In addition, the option only covers the first of each (not a range). Is there any way to freeze both at the same time...or freeze multiple rows or columns? Thanks! |
|
Msradell Premium Member join:2008-12-25 Louisville, KY |
Msradell
Premium Member
2015-Jan-30 11:20 am
I believe you can do what you want to do using the Split command which is found in the view ribbon. It divides the screen into 4 quadrants and you can move the center point wherever you want it. |
|
|
You, sir or madam, are a genius...you should work for NASA |
|
|
to Msradell
I thought the split command gives you four panes that can each be scrolled independently? I don't have Excel at home as I use linux, but my recollection of Excel at work is that by selecting the cell you want to not be frozen, that you can freeze everything above and to the left of it. |
|
bills Premium Member join:2000-08-19 China |
to haroldo
Click cell B2, drag to A1 (highlight 4 cells) and the click freeze panes |
|