• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Recently Used Functions in Excel

August 12, 2021 by Andrew Childress
How to use recent functions in Excel

Excel has thousands of formulas and functions that you can use to work with your data. Let’s learn how to use Recently Used Functions in Excel.

Excel has thousands of formulas and functions that you can use to work with your data. But chances are, you’ll find yourself using only a few of these over and over. Instead of typing in or searching for functions, Excel stores your most recently used functions in one, easy-to-access menu. This saves you precious time. Let’s learn how to use Recently Used Functions in Microsoft Excel.

How to Use Recently Used Functions in Excel

Let’s face it: many of us use the same functions again and again. Common functions include SUM, AVERAGE, COUNT, and more. But no matter what functions you use, Excel logs those that you’ve used most recently. It doesn’t make a difference if they’re common or extremely specific, esoteric functions. This Excel feature works for you.

For example, imagine that you use Excel’s COUNT function on a daily basis. You have a row of numbers and want to quickly count them. Instead of typing in the COUNT function, or finding it on the menu, you can simply insert it using Excel’s Recently Used feature.

To get started, click into the cell where you want to place your function. In this example, that’s cell E3. Then, go to the Formulas tab. You’ll find this on Excel’s ribbon. Go ahead and click to open it up.

Recently used functions in Excel

You’ll see a plethora of options on the Formulas tab. The one you’re looking for is the Recently Used dropdown, found on the left side of the Formulas tab. Click on its dropdown arrow to see a list of frequently and recently used Excel functions.

Recently used in Excel

Excel shows the top-10 most recently used functions. Again, these are customized to you. You’re looking for the COUNT function, so go ahead and click on it.

How to use recent functions in Excel

Excel will insert the function formula into your selected cell. When you’re finished, hit Enter on your keyboard. Excel returns your count: 4.

As you can see, the Recently Used Functions feature in Excel is a quick and easy way to build formulas quickly, based on your favorite functions.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Error checking in ExcelError Checking in Excel
Next Post:Edit Links in ExcelEdit Links menu in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top