How To Freeze Cells In Excel 2010
Microsoft Excel has three options to help you freeze the rows and columns via the Freeze Panes menu. How to freeze the top row in Excel? To freeze the top row of a spreadsheet, select Freeze Top Row from the menu. This will lock the top row and it will be visible no matter how far down the sheet you scroll.
This is the easiest way to freeze the top row. The rule for FreezePanes is it will freeze the upper left corner from the cell you selected. For example, if you highlight C10, it will freeze between columns B and C, rows 9 and 10. So when you highlight Row 2, it actually freeze between Rows 1 and 2 which is the top row. Since the first option is Unfreeze Panes, you must already have applied Freeze Panes, Freeze Top Row or Freeze First Column. So select Unfreeze Panes. Select the row below the last row that you want to freeze. The first option in the dropdown should now read Freeze Panes.
In order to freeze a row in Excel Mac, we have to select a row and then click Layout tab Freeze Panes button Freeze Panes Figure 29. Freeze a row in Excel Mac How to freeze cells in Excel Mac. Hp laserjet 3030 scanner setup. When you freeze only the first row or column, it doesn't matter which cell is selected when the freeze is applied. Click the View tab. Ciick the Freeze Panes button. Select Freeze Top Row or Freeze First Column.
People Also Ask
How To Freeze Cells In Excel 2010
Microsoft Excel has three options to help you freeze the rows and columns via the Freeze Panes menu. How to freeze the top row in Excel? To freeze the top row of a spreadsheet, select Freeze Top Row from the menu. This will lock the top row and it will be visible no matter how far down the sheet you scroll.
This is the easiest way to freeze the top row. The rule for FreezePanes is it will freeze the upper left corner from the cell you selected. For example, if you highlight C10, it will freeze between columns B and C, rows 9 and 10. So when you highlight Row 2, it actually freeze between Rows 1 and 2 which is the top row. Since the first option is Unfreeze Panes, you must already have applied Freeze Panes, Freeze Top Row or Freeze First Column. So select Unfreeze Panes. Select the row below the last row that you want to freeze. The first option in the dropdown should now read Freeze Panes.
In order to freeze a row in Excel Mac, we have to select a row and then click Layout tab Freeze Panes button Freeze Panes Figure 29. Freeze a row in Excel Mac How to freeze cells in Excel Mac. Hp laserjet 3030 scanner setup. When you freeze only the first row or column, it doesn't matter which cell is selected when the freeze is applied. Click the View tab. Ciick the Freeze Panes button. Select Freeze Top Row or Freeze First Column.