dslreports logo
Search similar:


uniqs
11486

aurgathor
join:2002-12-01
Lynnwood, WA

aurgathor

Member

[Excel] Making top row always visible regardless of scrolling

I have an Excel spreadsheet where the top row (row 1, to be exact) contains all the labels for the columns. (which I think is very common)

How do I make that always visible as the 1st, or as the top entry, regardless of the current position (could be way scrolled down) in the spread sheet?

TIA

redxii
Mod
join:2001-02-26
Michigan

redxii

Mod

Re: [Excel] Making top row always visible regardless of scrollin

Freeze Panes - Freeze Top Row (Under View in Office 2007).

Oregonian
Premium Member
join:2000-12-21
West Linn, OR

Oregonian

Premium Member

And you need to position the cursor (active cell) at the row below where you want it to split before you make the selection. In your case, that would be anywhere in Row 2.

CylonRed
MVM
join:2000-07-06
Bloom County

CylonRed

MVM

Not when using Freeze Top Row - it already knows which one you want to freeze using that option.

With Word 2010 - View (on the ribbon) --> Freeze Panes --> Freeze Top Row.

Oregonian
Premium Member
join:2000-12-21
West Linn, OR

Oregonian

Premium Member

Yes, you are correct. I was thinking of using "Split." Thanks for the correction.