I have recently been asked to make a heading in excel to stay at the top on the page even when you are scrolling down the document. Does any know how to do this? I have not used MS excel since school and am finding it difficult.
its not that different its jst that you think it because the things are in the wrong place than usual lol :-) if you are taking it to work or any where else that does not have 2007 then remember to save it as a compatable 2003 file
In Excel if you look just above the scroll arrow on the right hand side you will see a small grey button.
Hold you mouse over it and it will change to an up and down arrow.
Hold the left button down and drag it to the line below what you need to keep on screen when scrolling.
If and when you no longer need it just double click and it will revert back.
You can also keep a left hand column on screen when scrolling right. This time the grey button you are looking for is at the bottom right of the left and right scroll bar. Just drag it left to where you want it. Again, just double click to clear it.