A drop-down list is one of the most useful function in Excel. You can learn how to create drop-down lists here. We are also introducing the ways using data validation and refering to data in other worksheets.
We summarized useful shortcut keys in a list by purpose. Shortcut keys improve your work efficiency and most of them are easy to remember. Let's try it out!