Excel Keyboard Tips
Have you ever been working diligently on your computer and just wish you could do your work faster? There are a lot of keyboard shortcuts that you can use to make your life easier. For those of you who use the mouse, this is probably going to be a little challenging.
EDITING WORKSHEETS
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Copy Formula Above Cell Ctrl + `
Copy Value Above Cell Ctrl + Shift + ’
Undo Ctrl + Z
Redo Ctrl + Y
Repeat Last Command F4
Find Ctrl + F
Find Again Ctrl + F4
Replace Ctrl + H
MANAGING YOUR WORKBOOK
Create New File Ctrl + N
Open A File Ctrl + O
Print File Ctrl + P
Save File Ctrl + S
FORMATTING YOUR WORKSHEET
Center Text Ctrl + E
Justify Ctrl + J
Left Align Ctrl + L
Right Align Ctrl + R
Apply Currency Format Ctrl + Shift + $
Apply Date Format Ctrl + Shift + #
Apply Number Format Ctrl + ~
Apply Percentage Format Ctrl + %
Apply Scientific Number Ctrl + ^
Apply Time Format Ctrl + Shift + @
Clear Del
Hide Columns Ctrl + 0
Hide Row(s) Ctrl + 9
Insert Current Date Ctrl + ;
Insert Current Time Ctrl + Shift + ;
NAVIGATING YOUR WORKSHEET
Go To Ctrl + G
Up One Screen PgUp
Down One Screen PgDn
Move to Cell A1 Ctrl + Home
Move to Last Used Cell Ctrl + End
Move to Column A Home
Next Worksheet Ctrl + PgDn
Previous Worksheet Ctrl + PgUp
SELECTING ITEMS IN YOUR WORKSHEET
Select All Ctrl + A
Select Entire Row Shift + Spacebar
Select Entire Column Ctrl + Spacebar
February 15th, 2007 at 11:01 pm
This is a fantastic resource, Catherine! Thank you for posting it. I use some of these shortcuts on a daily basis but there were others I didn’t even know existed.
I’m going to copy and paste this into a Word document and print it out to use by my keyboard until I become familiar with all of them.
Thanks again for sharing this valuable information.
Evy
February 16th, 2007 at 9:49 am
Great resource Catherine. Thank you!
February 16th, 2007 at 1:29 pm
Evy,
My pleasure! It’s all about sharing. Please send me your email address. I have a sheet that has both Excel and Word shortcuts available. I will be posting the Word shortcuts early next week.
Cheers,
Cathy
February 17th, 2007 at 6:59 am
Thank you for getting this into the list early. Just a few of these keyboard tips (from the daysa before we had a mouse) can save a mouse shoulder.
I wrote a little ‘lesson’ on copy/paste for a group of realtors who were also typing challenged. Everytime they had the keyboard set in their minds’ eye, they had to think about the mouse. One of them still uses it; he is getting to be a pretty quick and accurate ‘hunt and peck’ typist!
JudyA