I'm trying to freeze panes verically and horizantly, can any one help with this?
Q Quiana Dec 22, 2004 #1 I'm trying to freeze panes verically and horizantly, can any one help with this?
F Frank Kabel Dec 22, 2004 #2 Hi for example move your cursor to cell C4 and goto 'Windows - Freeze panes'. This freezes rows 1-3 and column A:B. You can only freeze the top and left though
Hi for example move your cursor to cell C4 and goto 'Windows - Freeze panes'. This freezes rows 1-3 and column A:B. You can only freeze the top and left though
Q Quiana Dec 22, 2004 #3 Hi, Ok i was able to freeze column A & B. Is it possible to freeze the top as well, row 1-4? Thanks!
F Frank Kabel Dec 22, 2004 #4 Hi as said: Move the cursor to C5. This feature freezes all rows to the top and all columns to the left of the active cell
Hi as said: Move the cursor to C5. This feature freezes all rows to the top and all columns to the left of the active cell
Q Quiana Dec 22, 2004 #5 That worked, thanks so much for your help! Frank Kabel said: Hi as said: Move the cursor to C5. This feature freezes all rows to the top and all columns to the left of the active cell Click to expand...
That worked, thanks so much for your help! Frank Kabel said: Hi as said: Move the cursor to C5. This feature freezes all rows to the top and all columns to the left of the active cell Click to expand...