-
Microsoft Excel Office 365
Learn How to Display Auto Complete List With Shortcut in Microsoft Excel
In this article, you will learn how to Display Auto Complete List with a shortcut in Microsoft Excel. You will also get to know the shortcut to Display Auto Complete List on Mac. The easy key combinations will make you operate Microsoft Excel smoothly.
Display Auto-Complete List With Shortcut in Microsoft Excel
Here we will show you how to display an auto-complete list in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts.
You can use the key combinations given below to display an auto-complete list using the shortcut. When you use this shortcut, it will help you to display various lists within Excel without using a mouse. Using Alt + down arrow, you can able to access lists in three different contexts, as given below:
Access auto-complete items when doing repetitive data entry in a column, previously entered values in cells above will be displayed when auto-complete is enabled.
Access filter drop-down menus when working in a filtered list or table, unique values that appear in a list or column will be displayed with a checkbox to allow filtering.
Access data validation lists when input is restricted by data validation, when a list is used for data validation, the items in that list are displayed. So, here we go:
How to Display Auto-Complete List With Shortcut in Microsoft Excel?
It is used to display an auto-complete list in Microsoft Excel. When you use this shortcut, it will help you to display various lists within Excel without using a mouse. Using Alt + down arrow, you can able to access lists in three different contexts, as we have discussed above. This way you can easily display an auto-complete list using this shortcut.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel
Comments