If you want the first column on your worksheet frozen, click on the View tab and then click Freeze Panes.
Afterward, you should go to the View tab, where you’ll click Freeze Panes.Īs a result, you will be able to scroll through your worksheet content while still being able to view the frozen cells.Select the row that is right below the final row that you want to freeze.Suppose you want to freeze several rows (beginning with row 1), you need to follow these steps: You can determine that the top row has been frozen by the grey line that will appear below it. Doing this will freeze the very first row on your Excel worksheet so that it remains visible whenever you scroll through the rest of your worksheet. To freeze the top row in Excel, go to the View tab and then click Freeze Panes. Suppose you want to freeze both columns and rows you need to freeze them simultaneously. For instance, if you freeze column A and then decide to freeze row 1, column A will no longer be frozen. You can choose to freeze only the top row of your worksheet, only the left column of your worksheet, or multiple columns and rows simultaneously. You can cancel the editing mode by pressing Enter or Esc. The Freeze Panes command isn’t available when you are in a cell editing mode (that is, when you’re entering data or a formula in a cell) or when a worksheet is protected.You can’t freeze columns and rows in the middle of the worksheet.
Freeze in excel how to#
How to Freeze Columns and Rowsīefore you decide to freeze columns and rows on a worksheet, it is important that you consider the following factors: The Freeze Panes feature is an excellent way of keeping the data you need readily available rather than wasting time scrolling through columns and rows of data. Fortunately, the Excel Freeze Panes feature can help. One of the challenges of working with large worksheets is that as you start moving around the worksheets, you’ll lose track of the column heading and row labels.
0 kommentar(er)
