dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
269

haroldo
join:2004-01-16
USA

haroldo

Member

[Excel] Freeze top row and first column

If 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

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.

haroldo
join:2004-01-16
USA

haroldo

Member

You, sir or madam, are a genius...you should work for NASA
LLigetfa
join:2006-05-15
Fort Frances, ON

LLigetfa to Msradell

Member

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

bills to haroldo

Premium Member

to haroldo
Click cell B2, drag to A1 (highlight 4 cells) and the click freeze panes