How do I freeze columns in Excel for Mac 2011?

How do I freeze columns in Excel for Mac 2011?

To freeze the first column, open your Excel spreadsheet. Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze First Column option in the popup menu. Now when you scroll, you should still continue to see column A.

How do I freeze columns in Excel 2010?

To freeze columns:

1. Select the column to the right of the columns you want frozen.
2. Click the View tab.
3. Click the Freeze Panes command.
4. Select Freeze Panes.
5. A black line appears to the right of the frozen area.

How do I lock a column in Excel?

To lock one row only, choose the View tab, and then click Freeze Top Row. To lock one column only, choose the View tab, and then click Freeze First Column. To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.

How do you lock a column in Excel on a Mac?

Freeze panes to lock the first row or column in Excel for Mac

1. Freeze the top row. On the View tab, click Freeze Top Row.
2. Freeze the first column. If you’d rather freeze the leftmost column instead, on the View tab, click Freeze First Column.
3. Freeze as many rows or columns as you want.

Where is freeze pane in Excel Mac?

How to Freeze Columns in excel for Mac

1. First, open your excel spreadsheet.
2. Select the columns you want to freeze.
3. Now, click the Layout tab on the toolbar.
4. Navigate to the Window group and click Freeze Panes ribbon.
5. From the drop-down menu, select Freeze panes.

Where is freeze panes in Excel 2010?

How to Freeze Panes in an Excel 2010 Worksheet

• Position the cell cursor based on what you want to freeze:
• In the Window group of the View tab, choose Freeze Panes→Freeze Panes.
• In the Window group of the View tab, choose Freeze Panes→Unfreeze Panes to unlock the fixed rows and columns.

How do you freeze a column in Excel on a Mac?

How do you lock cells in Excel for Mac?

Lock cells to protect them in Excel for Mac

1. Select the cells that you want to lock.
2. On the Format menu, click Cells, or press.
3. Click the Protection tab, and then make sure that the Locked check box is selected.
4. If any cells should be unlocked, select them.
5. On the Review tab, click Protect Sheet or Protect Workbook.

How do I freeze panes in Excel for Mac?