Static left hand side column and static header row.. how?
Im trying to design a custom organiser in excel and one thing is bugging me. What I want is a column down the left and a row across the top that never move.
When I use freeze panes I cant get it exactly as I want it. Its pretty much like a website with frames.. with the left hand column and the header staying static.
Can anyone put me out of my misery???
If row 1 is you your static row and column A is your static column, place your cursor cell B2 and choose Freeze Panes. This will give you the desired result.
Originally Posted by no dice
Row 1 will only stay static if the data is moved up and down..
I need row 1 to stay static if the sheet is being moved up and down OR left or right.. as in truly static no matter what way I move the sheet.
Sorry for the confusion
Ah... gotcha. Sorry, we've just passed my level.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1