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:
Sample Sales Spreadsheet
- 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.
If you’d like to learn more about Excel or the other Microsoft Office programs, I teach remotely all over the world. For more information please click here.
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
