Excel Question
 

MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel

[Closed] Excel Question

3 Posts
3 Users
0 Reactions
47 Views
 iolo
Posts: 194
Free Member
Topic starter
 

I'm a bit stupid with excel 2007.
How do I lock a column or row so that it stays on the screen whilst scrolling the spreadsheet?
I hope that makes sense.
Thanks in advance
iolo


 
Posted : 01/05/2012 6:05 pm
Posts: 268
Free Member
 

View - freeze pane


 
Posted : 01/05/2012 6:06 pm
 iolo
Posts: 194
Free Member
Topic starter
 

thanks


 
Posted : 01/05/2012 7:16 pm
Posts: 0
Free Member
 

Just make sure you've got all of the rows above and columns to the left visible when you do it. Otherwise you can end up scrolling off of the edge of what you can see - quite irritating if you are a recipient of the file! 🙄


 
Posted : 01/05/2012 7:21 pm