Let’s kick start our Awesome August 2016 with a simple but very useful set of shortcuts. 5 shortcuts, one for each weekday.
- Monday ALT + M N: Opens name manager. Very handy, if you have quite a few range names and want to edit / manage them. Remember, this is a sequence shortcut, that means, you press ALT M, let go of both keys and then press N.
- Tuesday CTRL + T: Create a new table from data in current region. For more on tables, check out our Introduction to Excel Tables page.
- Wednesday CTRL + W: Close the current workbook, while keeping Excel open.
- Thursday ALT + T O: Opens Excel options. Very easy to remember too.
- Friday CTRL F: Fridays can be hard to concentrate. Use CTRL+F to find what you want in the current workbook. Use CTRL+H if you wish to do a find replace.
Bonus for weekends – CTRL+S: Save you work before you vanish for the weekend using the CTRL+S shortcut.
That is all for now. If you are looking for more shortcuts, check out our comprehensive Excel keyboard shortcut list.
What are your favorite Excel shortcuts?
Tell me and rest of our readers what are your most favorite and useful Excel shortcuts. Post them in the comments section.
This post is part of our Awesome August Excel Festival.
20 Responses to “5 Shortcuts for you, one for every weekday [Awesome August]”
Some shortcuts are so automatic that I barely realize what my fingers are doing!
F9 audit part of a long formula. Combine with Ctrl Z (or Esc) to change value back to formula.
F2 edit mode for formulas (also formulas in conditional formatting)
F3 past a name into a formula
F4 toggles absolute and relative references
ALT D E F this converts a column from text to numbers
Ctrl Backspace i learned this shortcut from Mike Girvin a couple of years ago. It avoids unnecessary scrolling
Ctrl ; enters the current date. I also use this to determine what the default date looks like (when it's not my laptop)
....so many more but I've got to drink my coffee and get back to Excel!
Cheers,
Kevin Lehrbass
F2 is a life saver while using formulas in conditional formatting.
CTRL+W: didn't know that one, useful for me because I always feel a bit of frustration when I open the last workbook, then have to open another one & wait for Excel to load, which takes some time due to add-ins.
Alt+T O = Alt+F T. Prefer the latter, it is more visual.
Alt+I R = insert row
Alt+I C = insert column
CTRL-F4 is another way to only close the current workbook while leaving Excel open, and for me it's easier to remember since ALT-F4 means 'close program'. And also CTRL-F4 works in other programs as well. Dunno if the same goes for CTRL-W
Why not use Ctrl+F3 to display the Name Manager?
Alt + E + S = Paste Special
Alt+F11 = open VBA side if you are into that side of excel
Ctrl + Space = Select Column
Shift +Space = Select Row
Ctrl + ArrowKey = Move in that direction to end/start of data
Ctrl + End = Moves to last cell that has/had data(can reset this by saving if you have deleted things) add in Shift to select from where you are to last cell
Ctrl + Home = Move to A1(This changes with Freeze panes
Ctrl+Alt+V will also bring up the Paste Special dialog (in all of the Office apps)
Chad, you are my savior with the "Alt+E+S" shortcut. My Evernote is almost always open and "Ctrl+Alt+V" works on Evernote as well and I don't know why Windows always gives precedence to Evernote over Excel.
Great post! My favorite topic so I can't restrain myself. Shortcuts below can all be done with the left hand on the keyboard and right hand on the mouse (I like keeping my right hand on the mouse):
Alt/Ribbon shortcuts:
Alt-F-R to open Recent files
Alt-F-A to Save As (2013)
Alt-F-A-B to Save As (2010)
Alt-F-D-A to Save & Send (Excel 2010) (Alt-F-H-E-A in 2013)
Alt-F-X to Exit Excel
Alt-A-T to add a Filter
Alt-A-C to Clear Filter
Alt-E-A-C to Clear Contents
Alt-E-A-A to Clear All (including formats)
Alt-W-F-F to Freeze Panes
Alt-A-S-A to Sort Ascending
Alt-A-S-D to Sort Descending
Alt-R-C for New Comment
Alt-R-T to Edit Comment
Alt-R-D to Delete Comment
"Hybrid" shortcuts that use both the mouse and keyboard ("RC" stands for Right-Click):
RC-F for Format Cells (a little faster than Ctrl+1)
RC-D for Delete
RC-E to Insert Copied Cells
Hybrid Paste Special shortcuts (after you've copied something):
RC-V to Paste Values
RC-R to Paste Formatting
RC-S for first Paste Special Sub-Menu
RC-S-S for second Paste Special Sub-Menu (the pop-up) (or use Alt-E-S)
RC-S-T to Transpose
RC-S-S-V-D- to Add Zero to convert text to numbers (after copying blank cell)
RC-F-Spacebar to Paste Formulas
Ctrl+F1 to hide/unhide ribbon
Alt+F1 for New Chart
Navigation/Selection:
Ctrl+A to Select All
Ctrl+Shift+End/Home to Select everything to End or Home
Ctrl+spin-mouse-wheel to Zoom in/out (to inspect what you've selected)
Ctrl+G to Go To specific cell
Ctrl+[ to go to Direct Precedent -- great when toggled with Ctrl+G to go back and forth -- can go between different worksheets
Alt-W-W to Switch Windows
Alt-Tab or Alt-Tab-Tab to Switch Windows (can be tricky)
Plus you can customize your QAT and get some easy Alt shortcuts. The icons on the left will be Alt-1, Alt-2, Alt-3, etc. Put frequently used icons there.
Correction:
Alt-F-A to Save As (2010)
Alt-F-A-B to Save As (2013)
RC-S-S-V-D- to Add Zero
Also, you can use the Menu Key (MK) instead of Right-Clicking (RC) if you prefer keeping both hands on the keyboard.
Wow, have to say your short cuts are pretty awesome. I never thought about using just the left hand to do short cuts while the right hand on the mouse.
I use short cuts alot, although mostly with both hands. Now I'll try just using the left hand where applicable.
Also the mouse and letter combinations. That's quality short cuts!
Alt-A-T to add a Filter
Alt-A-C to Clear Filter
A much easier alternative for both is SHIFT+CTRL+L
Alt + D L : Data validation dialog
If choosing validation criteria "allow list ", press F3 in "source" to get to named arrays .
Ctrl+F3 for Name Manager
F4 for repeated action, though Ctrl+Y gives the same effect, too
I was going to post CTRL-T as one of my favorite shortcuts in Excel 2010, to toggle between 'formula view' and regular. But in your original post, you already mentioned it to create a table. Weird... Or could the different meaning lie in the fact that I'm working with a Dutch Excel? But that doesn't really make sense, as other shortcuts are the same CTRL-P = print, CTRL-F = find etc.
I find below shorcuts very useful in various situations:
* CTRL+': copies the exact formula from the cell above
* CTRL+SHIFT+' (OR CTRL+" if you prefer): copies the value from the cell above (much easier than Paste Speacial -> Values)
* SHIFT+F3: brings the Insert Function window
* CTRL+SHIFT+1: formats number as # ##0.00
* CTRL+SHIFT+': formats number as 0%
* CTRL+SHIFT+~: formats number as General
* CTRL+{: traces the precedent cells or areas of a formula. Very useful! It also opens a file if the preceding cell is in external file.
* CTRL+}: traces the dependent cell or areas
However these shortcuts have some limitations compared to Formula Auditing tool
* F5: brings the 'Go to' window
* F7: brings a spell check window that helps to check the text in selected cells (or entire sheet) for any typing errors.
* F11: instantly creates a bar chart in new sheet
I also believe that repeating CTRL+S every 5-10 minutes could save you a lot of time, effort and nerves. Especially when dealing with complex calculations.
Thanks for this Articles....
"ALT + TO very easy to remember too".
Nice one Chandoo!
"Ctrl + Shift + ~" applies General formatting to cells--a very handy shortcut.
for paste value same formula cell press F2 then F9...