How do you freeze rows in Excel 2010 starter?
Follow these steps to freeze panes in a 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.
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.
- 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.
- To create and freeze these panes, follow these steps:
- Position the cell cursor in cell B3.
- Click View →Freeze Panes on the Ribbon and then click Freeze Panes on the drop-down menu or press Alt+WFF.
- In this example, Excel freezes the top and left pane above row 3 and left of column B.
- Creating a Table within Excel
- Open the Excel spreadsheet.
- Use your mouse to select the cells that contain the information for the table.
- Click the “Insert” tab > Locate the “Tables” group.
- Click "Table."
- If you have column headings, check the box "My table has headers."
- Verify that the range is correct > Click [OK].
To freeze rows:
- 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.
- Click the View tab.
- Click the Freeze Panes command.
- Select Freeze Panes.
- A black line appears below the rows that are frozen in place.
- To freeze rows:
- 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.
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
- The rows will be frozen in place, as indicated by the gray line.
- How to Lock All the Cells in a Worksheet
- Navigate to the Review tab.
- Click Protect Sheet.
- Click OK to protect the sheet.
- Select all the cells you don't want to be locked.
- Right-click on your selection, select Format Cells, and click on the Protection tab.
- Uncheck "Locked" (which is checked by default) and click OK.
- 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.
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.
- Do a repair of Excel:
- Open Excel.
- Select Help, Detect and Repair.
- A dialog will appear with an option to restore your shortcuts. Make certain it is checked.
- 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).
- Repair/Re-install Outlook 2003, 2007, 2010, 2013, 2016
- Open up the Control Panel on your PC (and show All Control Panel items, if necessary) and click on Programs, then Programs and Features.
- Find Microsoft Office 2016 in the list and highlight it.(Selection also say Microsoft Office 365)
- Click Change.
- Select Quick Repair and Repair then follow the prompts.
- Windows 7:
- Click Start, and then click Control Panel.
- Double-click Programs and Features.
- Click MicrosoftOffice 365, and then click Change.
- Select Quick Repair, and then click Repair. You may have to restart your computer after the repair process is complete.
Updated: 28th November 2019