How To Freeze A Row In Excel 2011 Mac

Excel is the virtually powerful tool for analyzing large sets of information. However, to keep your headers on screen, y'all need to acquire how to freeze a row in Excel on Mac. That fashion, you won't lose sight of valuable data on your superlative row or column when scrolling your spreadsheet.

Bold you have numerous rows of data in Excel. When scrolling down, the headers disappear. Thus, information technology is difficult to ascertain the values contained in your columns. The solution is to freeze rows and ensure that headers stay in view as you scroll the spreadsheet.

This guide teaches you lot the simple steps of how to freeze a row in Excel for Mac.

Freezing the First Row in Excel 2011 for Mac

Method 1: Freeze Panes

More columns and rows interpret to a complex problem of losing sight of data. In such a scenario, yous must understand how to freeze a row in Excel 2011 for macOS. Use these like shooting fish in a barrel steps to brand sure your rows stay in identify regardless of where you scroll. However, take note that these steps also apply when freezing columns every bit well.

• Beginning, open your spreadsheet in Excel.

Tip: Ensure that your spreadsheet is in Normal View. Click on View. Then select Normal to get a normal View.

• Adjacent, select the Layout Bill of fare located on the toolbar.

• Now, click on the Freeze Panes button.

Excel gives you four options to choose from. Still, in Mac, the Freeze Panes options are not explained, different in Windows. Here are your options:

• Freeze Panes: Use this option to lock your selected rows or columns other than the top row and left cavalcade.
• Freeze Superlative Row:  With this selection, yous can only see the top row every bit you scroll the rest of the spreadsheet.
• Freeze First Column:  Clicking this option makes the commencement column visible equally yous scroll the remaining spreadsheet.
• Unfreeze:  This option unlocks all the columns and rows. Notwithstanding, unfreeze is discrete from other options in Mac.
• Click Freeze Top row from the popular-up Window to lock your row.

Tip: This choice is located in the correct-hand corner of your spreadsheet.

In one case yous choose this activity, the top row stays in place as you gyre down the rest of the spreadsheet. And when y'all scroll back up, the pinnacle row is nevertheless intact. Impressive, right?

Freezing the Rows of your Choice

Do yous want to freeze as many rows as possible? It's possible. However, you must first with the superlative row when freezing. If y'all're going to freeze rows of your choice, follow these unproblematic steps:

• Get-go, click the prison cell below the row that you lot want to lock.
• For instance, if you desire to lock the first three rows, then click cell A4. Now select Layout and choose the Window grouping.
• Click on the Freeze Panes push and select Freeze Panes from the driblet-downwardly menu.

Everything above Cell A4 or any other active prison cell is frozen. A grey line is displayed along the jail cell gridlines when you lot use the Freeze option. After that, the rows of your choice remain on screen as you scroll the residual of your spreadsheet. Take notation that these steps are similar when yous want to learn how to freeze a row in Excel for Mac 2019 .

How to Freeze Columns in Excel for Mac

But what if you want to freeze columns instead? If you desire to see specific columns of your spreadsheets all the fourth dimension, it'due south straightforward.

• Offset, open your Excel spreadsheet.
• Select the columns you want to freeze.
• Now, click the Layout tab on the toolbar.
• Navigate to the Window group and click the Freeze Panes push button.
• From the drop-down carte du jour, select Freeze Panes.

The selected column will be locked or frozen equally portrayed by the grey lines. That fashion, you can see your column as you lot scroll across the spreadsheet.

How to Freeze the First Cavalcade and the Meridian Row

Probably y'all want to lock the first column and the top row of your spreadsheet simultaneously. Make sure that you select the cell below the meridian row and to the right of the first column.

• Showtime, select Cell B2.
• Adjacent, click the Layout tab and navigate to the Window group.
• Click Freeze Panes ribbon.
• Now, from the drop-downward menu select Freeze Panes.

Applying this activity freezes the top row of your spreadsheet and the first column regardless of where yous whorl.

Method 2: Split Panes

Alternatively, you lot can employ the Separate option to freeze and split your rows into different worksheets. By freezing Panes, you lot can keep particular rows or columns visible every bit you curl your spreadsheet. However, just as the name suggests, splitting panes divides your worksheet area into ii or four scrollable regions. What'south more, scrolling 1 section keeps the cells in place or locks them.

Instead of wasting time scrolling the spreadsheet back and along, merely split up the spreadsheet into 2 scrollable panes. Splitting rows makes it possible to view the meridian and lower panes as you ringlet your worksheet. Hither's how

• Showtime, open your desired spreadsheet.
• Next, select the row beneath and to the right of where you want to split. Select row 11 cell A11 to split row ten .
• Next, click the Layout tab of the ribbon.
• Select the Window group and choose the Split up push.

Excel gives you two areas that are scrollable and which contain the whole worksheet. That style, you tin work with extensive information that does not announced on the screen at the aforementioned time.

To unlock or unfreeze your row, click the split push button again.

How to Unfreeze a Row in Excel

Having learned how to freeze a row in Excel for Mac , it's as well possible to unfreeze a row.

Here's how:

• Click the Layout Carte du jour.
• Next, select the Unfreeze Panes.

Once you click on the Unfreeze Panes, then all the rows will be unlocked. Yet, one time you choose the Unfreeze Panes choice, it's only then that information technology becomes visible on your spreadsheet.

If working with broad data is frustrating, why don't you choose to freeze or separate your rows? Knowing how to freeze a row in Excel for Mac or carve up rows makes your headers visible on your screen all the fourth dimension. What'southward more than, it saves you hours of work as you scroll down the residuum of the spreadsheet as yous compare data.

If you're looking for a software company you can trust for its integrity and honest business practices, look no further than SoftwareKeep. Nosotros are a Microsoft Certified Partner and a BBB Accredited Business organisation that cares about bringing our customers a reliable, satisfying experience on the software products they need.   We will be with you before, during, and later all the sales.

Source: https://softwarekeep.com/help-center/how-to-freeze-a-row-in-excel-mac

Posted by: thomasprel1989.blogspot.com

Share this post