Did you know you can find the formula you’re looking for by typing only a few characters? I’ll use the spreadsheet below as an example that might help you follow along. Let’s find out which employee at a car dealership sold the most BMWs each month and the number they sold. Here’s a sample spreadsheet we can work with:
- You’d click in cell E4 and type an “=”.
- Then you’d type the letter “m”. A box would pop up listing all the formulas starting with that letter.
- You’d double-click on the word “MAX.”
- Next you’d select cells B4 through D4. You’d see a dotted line around them.
- Last, you’d hit the Enter key. The number 7 would appear.
I hope you were able to follow that! Maybe you’ll now be able to apply it with other formulas in your own spreadsheets.
I love little donations if this post helped you. They help me keep writing these tips! Also, if you’d like to learn more about using your computer, I tutor remotely all over the world and answer email questions for a small fee. Click here for more information and to see what I teach.
Used with permission from Microsoft.
Filed under: Blogroll, Computers, Excel, Microsoft Office, Software, Uncategorized Tagged: | autocomplete, Excel autocomplete, finding formulas in Excel, how to find formulas in Excel, how to locate formulas in Excel, how to use formulas in Excel, list of formulas, list of formulas in Excel, using autocomplete in Excel