Freeze Panes In Excel For Mac

When you're working in large spreadsheets, it can be hard to know what you're looking at once you scroll away from the header rows and columns. To fix this problem, you can freeze part of the worksheet so that even when you scroll, the headings are displayed.

  1. How To Freeze Panes In Excel For Mac 2011
  2. How To Freeze Panes In Excel For Mac

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. When you freeze panes, the rows above and columns to the left of the active cell are immobilized. In order to change the freeze point, you must unfreeze and freeze the cells again. Select a cell next to the row and/or column you want to freeze. If you select a cell in the first column, only the rows above it will freeze (no columns).

Freeze Rows

When you freeze panes, the rows above and columns to the left of the active cell are immobilized. In order to change the freeze point, you must unfreeze and freeze the cells again.

  1. Select a cell next to the row and/or column you want to freeze.

    If you select a cell in the first column, only the rows above it will freeze (no columns). If you select a cell in the first row, only the columns to the left will freeze (no rows).

  2. Click the View tab.
  3. Click the Freeze Panes button.
  4. Select Freeze Panes.
  5. Scroll to verify the cells are frozen.

The frozen cells are visible no matter how far you scroll.

Freeze the First Row or Column

When you freeze only the first row or column, it doesn’t matter which cell is selected when the freeze is applied.

  1. Click the View tab.
  2. Ciick the Freeze Panes button.
  3. Select Freeze Top Row or Freeze First Column.
    • Freeze Top Row Keeps the top row visible while scrolling through the worksheet.
    • Freeze First Column Keeps the first column visible while scrolling through the worksheet.
  4. Scroll in the worksheet to verify the freeze is applied.

Unfreeze Panes

If you no longer need the cells in a spreadsheet to be frozen, you can unfreeze them at any time.

  1. Click the View tab.
  2. Click the Freeze Panes button.
  3. Select Unfreeze Panes.

September 05, 2017 - by Bill Jelen

Excel has a lot of keyboard shortcuts. This article will show you how to find the shortcut for any command that your frequently use. Also - a look at Freeze Panes in Excel.

There are hundreds more shortcuts like this which you can easily learn. Press and release Alt in Excel to see key tips for each tab in the Ribbon (plus numbered key tips for the Quick Access Toolbar. Press the letter corresponding to a Ribbon tab to see the key tips for all of the commands on that tab.

In this particular case, clicking Alt + W + F reveals a third level of key tips, so Alt + W,F, F completes the command.

Thanks to Bradford Myers for sending in this idea.

Watch Video

Freeze Panes In Excel For Mac

Video Transcript

Learn Excel From MrExcel, Podcast Episode 2146: How To Figure Out Shortcut Keys.

Freeze top and left panes in excel

Alright, so, for these last, what, 20-some episodes, I've been talking about my favorite shortcut keys but these may not be your favorite shortcut keys. So, what's important to you is, what are the things you're doing over and over and over, right, and what's the keyboard shortcut for that, right?

So, the first thing you should do is look in the command and see if the tool tip tells you what the keyboard shortcut is. Like, for example, AUTOSUM. If we come up here to AUTOSUM and hover over SUM, right there, it tells us that the shortcut key is ALT+=, alright?

So that's going to be the fastest way to run that command, but let's say that you had to do VIEW, FREEZE PANES, FREEZE PANES right? See, I hover, hover, hover, hover, hover. There's nothing there that's going to offer freeze panes. Now, if you prefer to use the mouse, by all means, right click, ADD GALLERY TO QUICK ACCESS TOOLBAR. I don't like that at all. I would really want to have just FREEZE PANES on the QUICK ACCESS TOOLBAR.

Maybe we customize, but the keyboard shortcut for this, for anything that you want to learn how to do, just press and release ALT, and then you see that there's little key tips on, well, first off, all the quick access toolbar items. Those are awesome. The first 9 are easy to do, you know, so you should have your best ones there, but then I know that I want to go to the VIEW tab.

So, the key tip is W, so, I press W to get to the VIEW tab, and then they add more key tips. So, to open the FREEZE PANES, it's going to be F. So, it's going to be ALT+W, F, and then the top one is FREEZE PANES, so ALT+W, F, F, and if you find that you're constantly using FREEZE PANES over and over and over again, figure out what that string is, alright, and just do 1 a week, just 1 a week. Try and get 1 new one a week, and so ALT+W, F, F, right there, and I was able to freeze panes. Already, that's so much faster than going to click on VIEW, OPEN FREEZE PANES, choose FREEZE PANES, you know, and then move your hand back to the mouse.

So, ALT+W, F, F, and this podcast isn't about that one keyboard shortcut. It’s about how to figure out the keyboard shortcut for anything you find yourself doing frequently. If you ever want to become incredibly fast at Excel, using keyboard shortcuts is the fast, fast...using keyboard shortcuts is the best way to make you really, really fast at Excel.

Excel mac lock first row

How To Freeze Panes In Excel For Mac 2011

Thanks for stopping by. We'll see you next time for another netcast from MrExcel.

How To Freeze Panes In Excel For Mac

Title Photo: Survivor / Pixabay