Excel

Latest Posts | New Discussions | Hot Threads | Forum Topics
Help | Settings | Followed Threads
reply
6 messages
Tazzie
22/07/2002 at 15:41
How do I get some collumns to stay still whilst I scroll across the rest of the page?

Dur!

www.feistyracing.co.uk
Born to be wild, hemmed in by the system...
Proud recipient of (VDCR 27.5) TiT #52AA IANAN #80085 Hon. Mem. Ard n Fast #21 VDA #80085 SSC2 #80085 LMJ Biatch #2 SNSG #80085 FNEN #80085 SSAD #80085

Latest addition VDDC#2FM Bloooooop blooop bloooooop
Owned and controlled by Jif... it's all his fault... stroppy fek
SKID Mark
22/07/2002 at 15:55
Get to the cell you want to start.

Click on 'Window' then click on 'Freeze Panes'

To undo it repeat the task and 'Freeze Panes' has changed to 'Unfreeze'

Sorted



HTH

IANAN #6 / PIC OAP #1664 / VDA #54 / FRM #4 / TIT #140A
Roadcraft, Nottingham
Granby Motors, Beeston, Nottingham
HenPecked
22/07/2002 at 15:56
Click on Window followed by Split. Move the "Bars" to where u want em then Then Select "Window " followed by Freeze Panes

Think thats what uu wanted.

But Skids way is quicker - U live & learn
This PC cRashes more than me.. :-(

TIT196B
ABF
22/07/2002 at 15:59
Tazzie, you have to select the cells and then FREEZE them ... I think it's either view, freeze or tools, freeze or something like that. Check in Excel Help ... I can't quite remember.


ABF
Tazzie
22/07/2002 at 15:59
That's the one - thank you very much chaps

www.feistyracing.co.uk
Born to be wild, hemmed in by the system...
Proud recipient of (VDCR 27.5) TiT #52AA IANAN #80085 Hon. Mem. Ard n Fast #21 VDA #80085 SSC2 #80085 LMJ Biatch #2 SNSG #80085 FNEN #80085 SSAD #80085

Latest addition VDDC#2FM Bloooooop blooop bloooooop
Owned and controlled by Jif... it's all his fault... stroppy fek
ChopstickJim
22/07/2002 at 17:34
erm

freeze pane

fuck , beaten to it

well I tried, I had to mess about opening the damn program, then its automatic for me (if you know what I mean)
Your say
Terms and Conditions | Code of Conduct
email image
6 messages
Forum Jump