Hello all,
Here are a few of my most used/favorite short cut keys for Excel. Not having to always rely on using the mouse has made me much more efficient in my work.
Quick Functions:
Ctrl + V = Paste
Ctrl + X = Cut
Ctrl + C = Copy
Ctrl + Z = Undo
Ctrl + Y = Redo
Ctrl + S = Save
Ctrl + O = Open
Ctrl + P = Print
Ctrl + B = Bold
Ctrl + I = Italicize
Ctrl + U = Underline
Ctrl + T = Open the Insert Table Dialog box
Ctrl + F = Find
Ctrl + H = Find/Replace
F2 - Open/Activate a cells contents for editing
Alt + F4 = Close Current Window
Tab - Close Cell Editing and move 1 cell to the Right
Enter - Close Cell Editing and move 1 cell Down
For movement without using the Mouse:
Arrow directional Keys (Up, Down, Left, Right) = Move 1 cell in that direction
Ctrl + Home = Goto Upper-Left most cell in spreadsheet
Ctrl + End = Goto Lower-Right most cell in spreadsheet
Ctrl + [Arrow direction Key] = Goto the end of column/row or next empty cell in that direction
Ctrl + PageUp = Spreadsheet Tab to the Left
Ctrl + PageDown = Spreadsheet Tab to the Right
For Highlighting Cells:
Use the Movement Keys above, but hold "Shift" as well.
For a comprehensive list of shortcuts, go to the following Microsoft Link:
http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP010073848.aspx
Using Microsoft Excel 2013, Everyday Excel 1-2-3 is designed to share some "everyday" experiences, tips or tricks for Microsoft Excel users. Target reader experience will range from Beginner to Expert and posts will often reach out to each group but not every group always. Comments are welcome and highly encouraged. Suggestions for topics are welcome, but solutions to specific problems will not necessarily be provided. Part of learning is struggling, and we're all struggling together.
A couple other shortcuts that I find useful are F2 and F4
ReplyDeleteF2 – can be used to edit a cell’s contents that you may have used the keyboard to navigate. Helpful for correcting misspellings or editing formulas
F4 – can be used to repeat the previous action. If you select a cell, or range or cells, right-click/Format Cells and update the font size, bold/italicize, fill, border, etc. then click OK, you can click on another cell or range of cells, hit F4 and that same formatting will apply. Great for deleting cells/columns/rows as well. Highlight a cell/column/row and right-click/Delete (Ctl-) or right-click/Insert (Ctl+) then highlight the next cell/column/row, hit F4 and it will perform the same action.
Great point on F4! I do actually use this one a lot. It ties directly back to my post on "Dollar Signs in Formulas". Thanks for the Comment!
ReplyDeleteWhat a thrilling post, you have pointed out some excellent points, I as well believe this is a superb website. I have planned to visit it again and again. 2ms office 2016 product key
ReplyDelete