28th November 2019

dummies
11

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.

Also, 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 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.

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.
Write Your Answer

Rate

86% people found this answer useful, click to cast your vote.

4.3 / 5 based on 3 votes.

Bookmark

Press Ctrl + D to add this site to your favorites!

Share