How do I freeze 2 panes in excel. It will let me freeze a horzantal section and it will let me freeze a vertical section but I can't figure out how to do both.
2006-06-08 07:50:25 · 5 answers · asked by nickb1302 3 in Computers & Internet ➔ Software
Select the cell that would be the corner where the panes come together. For example, if you wanted to freeze column A and row 1, select cell B2. Then go to Window: Freeze Panes. That should work. Good Luck!
2006-06-08 07:56:19 · answer #1 · answered by aldera22 3 · 16⤊ 1⤋
To freeze a pane, do one of the following:
The top horizontal pane Select the row below where you want the split to appear.
The left vertical pane Select the column to the right of where you want the split to appear.
Both the upper and left panes Click the cell below and to the right of where you want the split to appear.
On the Window menu, click Freeze Panes.
2006-06-08 14:56:49 · answer #2 · answered by WindowLicker 6 · 0⤊ 0⤋
Put the cursor on the upper left corner of the part you don't want frozen. When you freeze, it will freeze the rows above the cursor, and it will freeze the columns to the left of the cursor.
2006-06-08 14:54:31 · answer #3 · answered by kimmyisahotbabe 5 · 0⤊ 0⤋
Click on the cell where you want the split to occur. On the top of your screen, choose Window, split screen. The sheet will now have 2 separate sections, starting to the top left of the cell you selected. To remove the split screen when you're done, go to Windown, choose remove split screen.
Hope this helps.
2006-06-08 14:58:42 · answer #4 · answered by Mary K 4 · 0⤊ 0⤋
click on B2 and freeze panes. It should work.
2006-06-08 14:55:19 · answer #5 · answered by hardcoco 6 · 0⤊ 0⤋