santalite.blogg.se - Freeze panes excel

#FREEZE PANES EXCEL HOW TO#
#FREEZE PANES EXCEL FOR MAC#

If you wish to freeze multiple columns and/or rows, you can do it as long as the top row and column of your document is included.įor example, selecting the C7 cell will freeze the rows and columns highlighted with blue.Īll you have to do is select the column to the right of the last column you want frozen, select the row below the last row you want frozen, and click Freeze Panes.

The freeze is indicated by the bottom-line of the row and the right-side line of the column becoming darker than other lines, showing that they’re currently frozen.įreeze as many rows or columns as you want.

This will automatically freeze and lock the very first row and column in your document.

Open the document you want to work on in Excel, then select the B2 cell.

The freeze is indicated by the right-side line of the column becoming darker than other lines, showing that the column is currently frozen.

This will automatically freeze and lock the very first column in your document.

Click on the Freeze First Column icon.

The freeze is indicated by the bottom line of the row becoming darker than other lines, showing that the row is currently frozen.

This will automatically freeze and lock the very first row in your document.

Switch to the View tab in your Ribbon interface, located on top of the Excel window.

Open the document you want to work on in Excel.

After opening Excel and the document you’re working on, switch to the View tab in your Ribbon interface, and make sure that the Normal view is selected.Īfter completing this, you can proceed with the appropriate steps described below. Freeze rows and columns in Excel for Macīefore you can start freezing and locking, you need to ensure that you’re in the right view mode.

#FREEZE PANES EXCEL FOR MAC#

This article goes in- depth about all aspects of freezing a row, column, or cell to make your life easier when working with the leading spreadsheet application for Mac systems. Make finding important data or comparisons easier by taking advantage of this feature on Excel for Mac. Frozen (also referred to as locked) rows, columns, or individual cells stay on your screen even while you’re scrolling, allowing you to create headers and key data entries. In the following image, the top row is frozen, so the labels are visible even after scrolling down in the worksheet.Freezing a row or column in Excel is a great way to not only improve the design of your spreadsheet but its functionality as well. In the following example, notice that the top row includes labels for each column.Īfter scrolling down in the worksheet, however, the top row is not visible.

Select Freeze First Column to freeze the first column only.Select Freeze Top Row to freeze the top row only.Select Freeze Panes to freeze the rows above and the columns to the left of the selected cell.On the View tab, in the Window group, click the Freeze Panes command.This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016. To freeze panes in an Excel worksheet, follow these four steps. A common use of freezing panes is to keep a header row in view as you scroll through a large worksheet.

#FREEZE PANES EXCEL HOW TO#

How to Freeze Panes in Microsoft Excel See Microsoft Excel: Tips and Tricks for similar articles.įreezing panes is a way of making one or more rows or columns stay at the top or left of your worksheet as you scroll through the worksheet.