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.
Showing posts with label Shortcuts. Show all posts
Showing posts with label Shortcuts. Show all posts
Friday, January 17, 2014
Subscribe to:
Posts (Atom)