MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - Freeze Panes + More

September 05, 2017 - by Bill Jelen

Excel Shortcut - Freeze Panes + More

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

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 2146 how to figure out
  • shortcut-keys alright so for these last
  • about 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 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 some right
  • there it tells us that the shortcut key
  • is alt equals all right so that's going
  • to be the fastest way to run that
  • command but let's say that you have to
  • do our view freeze panes freeze panes
  • right see I hover hover hover hover
  • hover there's nothing there it'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 whoo 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 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 to 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 gonna be alt W F and then the top
  • one is freeze panes so alt wff and if
  • you find that you're constantly using
  • freeze panes over and over and over
  • again figure out what that string is all
  • right and just do one week just why
  • don't we try and get one new one a week
  • and so alt wff right there 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 then move your hand back to the
  • mouse so all W FF and this podcast isn't
  • about that one keyboard shortcut is
  • 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
  • thanks for stopping by we'll see you
  • next time for another net cast from mr.
  • Excel

Title Photo: Survivor / Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.