- Excel keyboard shortcuts drop down lists how to#
- Excel keyboard shortcuts drop down lists pdf#
- Excel keyboard shortcuts drop down lists software#
- Excel keyboard shortcuts drop down lists windows#
Here’s the quickest way to name the list of items:Īfter you’ve named the source list, you can add the drop down lists, by following these instructions: When creating drop down lists, you can use a list of items from a different worksheet, as long as you give a name to that list of items first. The new video includes a couple of shortcuts that will make it even easier to create those drop down lists. I’ve just finished a new version, for Excel 2007 and Excel 2010, and you can see it at the end of this blog post.
Excel keyboard shortcuts drop down lists how to#
These lists will also help prevent invalid entries in your worksheets.Ī couple of years ago, one of the first videos that I uploaded to YouTube showed how to create data validation drop down lists in Excel 2003. I recommend using keyboard shortcuts to avoid using the mouse, but if you don't have good typing posture, using the keyboard more won't help.To make it easier to people to enter data in your Excel workbook, you can create drop down lists in the cells, by using Excel data validation. There are many factors that contribute to RSI, and many things that you can do to recover and prevent it. For me, that means less arm and wrist pain. But, the more I use the common and comfortable shortcuts, the less I use the mouse. Some keyboard shortcuts cause you to contort your fingers in unnatural ways, causing even more pain. Besides giving my right arm a break, one thing I learned in the process was to use keyboard shortcuts. In grad school, my right arm and wrist got so bad I had to start using a left-handed mouse. Using Keyboard Shortcuts May Help Reduce RSI Painĭoes using your mouse hurt your wrist, forearm, or shoulder? Is so, you may have developed repetitive strain injury or RSI. (Then type the first few letters of the font)Ĭhoose a font size.
In a formula, display the Insert Function dialog box (for help on syntax)Ĭhoose a font name. Use Alt+F9 to recalculate the entire workbook.Īpply the General format to the selected cells Toggle between Relative, Absolute, and Mixed references while editing a formula. Ctrl+r does the same thing, but to the right. If a range is selected, copies the uppermost cell into the lower cells.
Excel keyboard shortcuts drop down lists windows#
Select to beginning of line of text (or cell A1)įind - (Hint: Use for searching web pages such as this one)Įdit active cell, (In Windows Explorer, rename selected file)Įnter current date (Ctrl+Shift+: enter the current time)Īlso, move to next and previous tabs (such as in multi-tab dialog boxes)įill (Copy) Down - If a single cell is selected, copies the cell immediately above it. Move to beginning of line of text (or last nonblank row/column) Select to end of line of text (or data region) Move to end of line of text (or data region) Įxtend selection by one word, to next change in empty vs.
Excel keyboard shortcuts drop down lists software#
= Shortcuts commonly used in other software for the same purpose.Ĭancel - Used in many situations where you'd expect "cancel" to be appropriate, including closing menus, dialog boxes, and message windows.Īccept/Done/Submit - Can usually be used in place of clicking on "Accept", "OK", "Search", "Submit", etc.Įxtend selection by one character, cell, row, column. Everyone's work is different, but if you do a lot of text editing, using the keyboard to navigate and select text can save a lot of time.
#1 Recommendation: Learn to use the combination of Ctrl, Alt, and Shift along with the Arrow Keys to navigate and select text. These are some of the most-used shortcuts, so they are the ones to start with first.ĭownload the Excel Keyboard Shortcut 1-Pager (.pdf)
Excel keyboard shortcuts drop down lists pdf#
The PDF doesn't include all possible shortcuts, but that's the point. Print a page of shortcuts to keep next to your computer. View Larger Image Excel Keyboard Shorcuts