How to Lock an Entire Worksheet (Except Specific Cells).How to Lock All the Cells in a Worksheet in Excel.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. 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. 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. = 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) 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

Excel keyboard shortcut to edit cell