Advertisement

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

Advertisement

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
Senior Member with 746 posts.
THREAD STARTER
 
Join Date: Oct 2001
Location: Wales, UK
15-Jul-2008, 06: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 offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,540 posts.
 
Join Date: Mar 2005
Location: UK
15-Jul-2008, 07: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, 09: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
WELCOME TO TECH SUPPORT GUY!

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.


(clock)
THIS THREAD HAS EXPIRED.
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


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