Wot He said
| x404.co.uk http://www.x404.co.uk/forum/ |
|
| Excel Query http://www.x404.co.uk/forum/viewtopic.php?f=4&t=4151 |
Page 1 of 1 |
| Author: | PaulKey [ Thu Nov 12, 2009 8:19 pm ] |
| Post subject: | Excel Query |
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 !!!! |
|
| Author: | JohnSheridan [ Thu Nov 12, 2009 10:32 pm ] |
| Post subject: | Re: Excel Query |
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> |
|
| Author: | AlunD [ Fri Nov 13, 2009 8:27 am ] |
| Post subject: | Re: Excel Query |
Wot He said
|
|
| Author: | PaulKey [ Fri Nov 13, 2009 10:43 am ] |
| Post subject: | Re: Excel Query |
Many thanks John Sheridan. It's 2003 and your solution worked a treat. |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|