|
View unanswered posts | View active topics
It is currently Sun May 11, 2025 7:48 pm
|
Page 1 of 1
|
[ 4 posts ] |
|
| Author |
Message |
|
PaulKey
Occasionally has a life
Joined: Sun Apr 26, 2009 8:18 am
Posts: 385
|
Hi guys...
It's years since I used Excel and I have forgotten just about everything.
What I'm wanting to do is "fix" the title row so that is doesn't scroll up when the data rows do. I'm buggered if I can find out how it's done.
Help !!!!
|
| Thu Nov 12, 2009 8:19 pm |
|
|
|
JohnSheridan
Doesn't have much of a life
Joined: Mon Apr 27, 2009 9:10 pm
Posts: 1057
|
Well in Excel 2007 you highlight the line you want to freeze (click on its number) then go <View> <Freeze Pane>
If its Excel 2003 then again you highlight the line to freeze and then go <Window> <Freeze Panes>
_________________
|
| Thu Nov 12, 2009 10:32 pm |
|
|
|
AlunD
Site Admin
Joined: Fri Apr 24, 2009 6:12 am
Posts: 7011
Location: Wiltshire
|
Wot He said 
_________________
<input type="pickmeup" name="coffee" value="espresso" />
|
| Fri Nov 13, 2009 8:27 am |
|
|
|
PaulKey
Occasionally has a life
Joined: Sun Apr 26, 2009 8:18 am
Posts: 385
|
Many thanks John Sheridan. It's 2003 and your solution worked a treat.
|
| Fri Nov 13, 2009 10:43 am |
|
|
|
|
Page 1 of 1
|
[ 4 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 3 guests |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
|
|
