» The Best Shortcut Keys in Microsoft Excel
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
| Ctrl+Z | Undo |
| Ctrl+C Enter, Ctrl+V Ctrl+X |
Copy, Paste, Multiple Paste, Cut |
| Ctrl+F, Ctrl+H |
Find, Find&Replace |
| Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4 |
Print, Save, Close, Close Excel |
| Ctrl+Arrow | Move to edge of region |
| Ctrl+* |
Select current region |
| Ctrl+A | Select all cells |
| Ctrl+Home Ctrl+End |
Select A1, Select last cell in used range |
| Ctrl+Shift+End | Select from active cell to last cell in used range. |
| Ctrl+Shift+Home | Select from active cell to A1 |
| Ctrl+Page Down Ctrl+Page Up |
Move to the next sheet, Move to the previous sheet |
| Ctrl+Tab | Move to next open workbook |
| Ctrl+N | Open new workbook |
| Shift+F11 | Insert new worksheet |
| Shift+F3 | Paste function window |
| =+FunctionName+Ctrl+A | Insert new function |
| Alt+F11 | Open VBE |
| Ctrl+Shift+Enter | Array formula |
| Ctrl+F3, F3 |
Define name, Paste name |
| Ctrl+Spacebar Shift+Spacebar |
Select columns, Select rows |
| Ctrl+1, Ctrl+B, Ctrl+U |
Format cells, Bold, Underline |
| Ctrl+; , Ctrl+shift+: |
Current date, Current time |
Book Store:
Recommended Books:
- Business Plans Kit for Dummies (With CD-ROM)
- Accounting the Easy Way
- Absolute Beginner's Guide to Microsoft Excel 2002
- Business Analysis with Microsoft Excel (2nd Edition)
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The Financial Numbers Game: Detecting Creative Accounting Practices
Tips and Tricks #7
Schultz, John
This is a geat website to learn Excel tips from. I learned about shortcut I never knew existed. I think there is a high value for others if they would take a look at this website.
Short cut - F2
mark
Why not mention F2 - allowing you to alter text/entries within a cell rather than moving to the entry box at top
ps Great site!
Shortcut to Center alignment?
Vishal
Can a cell in msecel be aligned without using mouse and ony using a keyboard shotrcut?
euro sign
Effie
Please can you tell me the short cut in excel for the euro sigh. eg. in word its ctrl alt with the E key.
thank you
Effie dreams@srh.forthnet.gr
why does excel have 2 shortcuts to do the same thing
Lincoln
why does excel use crtl shift F1 and shift F11,, both perform the same function
Changing default shortcuts
Heather
I want to change the Ctrl + Page Down for "move to next sheet" to something I can do with my left hand, similar to Alt+Tab. How do you change the default shortcut keys?
heatherful@yahoo.com
i don't understanding
famitha
sorry this execl keys i don't understanding so you teach me
i don't understanding
famitha
sorry this execl keys i don't understanding so you teach me
and i mean this in a nice way...
randi
for a geek like me this is a dream come true.
and i mean this in a nice way...
randi
for a geek like me this is a dream come true.
Hide Cell & Hide Collum
Tinku Malhotra
Ctrl+9 Hide Cell & Shift+Ctrl+9 Unhide The cell .
Ctrl+0 Hide the Collum & Shift+Ctrl+0 Unhide The Collum
Formula
Rajesh
Hi known few formula after seeing this site i learn few more. (Bzc learning is endless). I send this site to all my friends.
Rename & Paste shrtcuts
M.Hussain
We can easly rename the cell value through F2. And also we can Paste through Enter press, Just Copy the data and where u want take data just press enter.
Insert / Delete Row
Pratap K
To insert a row, hit "Ctrl + '+'"
To delete a row, hit "Ctrl + '-'"
Cheers
Can anyone tell me how to get to a print preview in excel (only for selected text)
excel formulas
rashid
i want to know how to enter the formulas on values in different conditions
Excellent Tips for Beginners
Pranav
Great i am using excel since last 3 years, but during my last tenure of 1 year i have learned a lot shortcut and it makes wonders if applied.
COPY OF PROPERITY OF ABOVE CELL
shailesh
CAN U GUIDE ME HOW 2 COPY THE ABOVE CELL PROPERITY BY SHORT CUT KEY
Excellent Tips
Narinder Chauhan
Hi known few formula after seeing this site i learn few more. (Bzc learning is endless).
Very Useful
Muhammad Ali
These are Very Useful Shorcut Keys for Key Board Users to working fast than using a Mouse.
Hyperlink to the Validation
Sudarshan Kulkarni
Hi, I am Sudarshan. I have one query can you insert Hyperlink to the validation field. that is there are more than 1 objects in the validation & if u want to link the particular object to the particular say worksheet. How you can do it.
Pls suggest
Thanx
Copying Shortcut
Charles
Does anyone know of a shortcut to copy a formula down a column, other than having to highlight the whole column?
Some shortcuts to my friends###$$$%%%***
Hi Friends This is Gopinath
Ctl + Shift + 1 = two decimal point added in selected cell
use the number(with shift 1-10) and (without shift 1-10) is ur excel u the differs.
More shortcut keys
Marcello
If you go into Excel help and type in keyboard shortcuts, you will get a long list of shortcut keys.
REquest for more shortcut keys
Sundeep Khemka
Hi..
Is it possible that more shortcut keys be displayed in this site of yours. Thanks.
Highlight Row or Column
Sumedh
Highlight Row => "Shift" + Spacebar
Highlight Column => "Ctrl" + Spacebar
excel short key required
Aamir
how to convert from CAPITAL CASE INTO LOWER CASE
please reply soon
waiting
Upper Case into Lower Case
Andy
use function lower() to convert into lowercase and function upper() to convert into uppercase
ASSIGN A COLOR USING KEY BOARD SHOTCUT
K.T.BHANU PRATAP
Hey can any body mail me how to assign a color to a cell using keyboard short cut. I hopei can get the answer
Short Cut for Format Painter
Jen
Hey is there any short Cut of Format Painter ?
If there Please Do mail me or reply me .
Thanks In Advance.
Jen
Short Cut Key
Gulzar Ahmad
I visited may sites for short cut keys but i think this is the best one.
shortcut keys
pragati
i want shortcut keys of font colour and column border, fill colour
