There's no such thing as a stupid question, but they're the easiest to answer.


Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Freezing a single 'title' row in Excel


theMusicMan's Avatar
theMusicMan theMusicMan is offline
Member with 747 posts.
Join Date: Oct 2001
Location: Wales, UK
15-Jul-2008, 05:58 AM #1
Freezing a single 'title' row in Excel
Hey All

Would you believe it, I simply cannot remember how to freeze a single row at the top of a sheet. I use this as a title row for the column names, and want this to remain on the screen when I scroll down the page. When I select 'Freeze Panes' I can't figure out how to select just the single row!

Any help appreciated... thanks all.
OBP's Avatar
OBP OBP is online now OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,827 posts.
Join Date: Mar 2005
Location: UK
15-Jul-2008, 06:15 AM #2
Excel 2000-2002 you highlight the row(s) and at the top of the RightHand Scroll Bar is a small block click on that to "split the Screen and then "Freeze Panes"
See the Help for "Freeze Rows"
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
15-Jul-2008, 08:56 AM #3
Happy Birthday Musicman!

You will want to select the row underneath the one that you want to freeze and select "Windows">>"Freeze Panes" from the menu bar.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑