How do you freeze rows in Excel 2010 starter?

Follow these steps to freeze panes in a worksheet:
  1. Position the cell cursor based on what you want to freeze:
  2. In the Window group of the View tab, choose Freeze Panes→Freeze Panes.
  3. In the Window group of the View tab, choose Freeze Panes→Unfreeze Panes to unlock the fixed rows and columns.

How do I freeze multiple columns and rows in Excel?

To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.
  • How do I freeze both a column and a row in Excel?

    To unfreeze the first column, choose Unfreeze Panes from the menu. You can also freeze both columns and rows at the same time. To freeze both rows and columns, select the upper left cell in the data you don't want to freeze. Then choose Freeze Panes from the menu.
  • How do you freeze panes in Excel 2016?

    To create and freeze these panes, follow these steps:
    1. Position the cell cursor in cell B3.
    2. Click View →Freeze Panes on the Ribbon and then click Freeze Panes on the drop-down menu or press Alt+WFF.
    3. In this example, Excel freezes the top and left pane above row 3 and left of column B.
  • How do you convert data to a table in Excel?

    Creating a Table within Excel
    1. Open the Excel spreadsheet.
    2. Use your mouse to select the cells that contain the information for the table.
    3. Click the “Insert” tab > Locate the “Tables” group.
    4. Click "Table."
    5. If you have column headings, check the box "My table has headers."
    6. Verify that the range is correct > Click [OK].

How do you freeze a row in Excel 2010?

To freeze rows:
  1. Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3.
  2. Click the View tab.
  3. Click the Freeze Panes command.
  4. Select Freeze Panes.
  5. A black line appears below the rows that are frozen in place.
  • How do you freeze a row in Excel 2013?

    To freeze rows:
    1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3.
    2. Click the View tab on the Ribbon.
    3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
    4. The rows will be frozen in place, as indicated by the gray line.
  • How do you protect cells in Excel 2010?

    How to Lock All the Cells in a Worksheet
    1. Navigate to the Review tab.
    2. Click Protect Sheet.
    3. Click OK to protect the sheet.
    4. Select all the cells you don't want to be locked.
    5. Right-click on your selection, select Format Cells, and click on the Protection tab.
    6. Uncheck "Locked" (which is checked by default) and click OK.
  • How do you freeze columns and rows in Excel 2010 at the same time?

    Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu. Now when you scroll, you should still continue to see row 1 and column A.

What do you do when Excel is not responding?

One of the ways to fix the 'Excel is not responding' error is to repair Microsoft Office. For doing this, go to the Control panel, and choose Programs and Features. Click on Microsoft Office in the list, and then on Change button at the top. You will get the option to automatically 'Repair' Office.
  • How do I fix my Excel?

    Do a repair of Excel:
    1. Open Excel.
    2. Select Help, Detect and Repair.
    3. A dialog will appear with an option to restore your shortcuts. Make certain it is checked.
    4. Click the start button on this dialog. Even though repair may report that no problems were found, it will find and fix some problems (we've seen it happen).
  • How do you repair office?

    Repair/Re-install Outlook 2003, 2007, 2010, 2013, 2016
    1. Open up the Control Panel on your PC (and show All Control Panel items, if necessary) and click on Programs, then Programs and Features.
    2. Find Microsoft Office 2016 in the list and highlight it.(Selection also say Microsoft Office 365)
    3. Click Change.
    4. Select Quick Repair and Repair then follow the prompts.
  • How do I repair Microsoft Office?

    Windows 7:
    1. Click Start, and then click Control Panel.
    2. Double-click Programs and Features.
    3. Click MicrosoftOffice 365, and then click Change.
    4. Select Quick Repair, and then click Repair. You may have to restart your computer after the repair process is complete.

Updated: 28th November 2019

Rate This Answer

4.3 / 5 based on 3 votes.