Absolute/relative/mixed reference | F4 |
AutoSum | Alt = |
Bold | Ctrl-B |
Border lines off | Ctrl-Shift _ |
Border lines on | Ctrl-Shift & |
Calculate active sheet | Shift-F9 |
Calculate all worksheets | F9 |
Close | Ctrl-W |
Collapse selection to active cell | Shift-Backspace |
Comment insert/edit | Shift-F2 |
Copy | Ctrl-C |
Copy formula from cell above | Ctrl ' |
Copy value from cell above | Ctrl-Shift " |
Cut | Ctrl-X |
Date | Ctrl ; |
Delete range | Ctrl - |
Delete to end of line | Ctrl-Del |
Show values/formulas | Ctrl ` |
Edit cell | F2 |
Enter formula as array | Ctrl-Shift-Enter |
Fill down | Ctrl-D |
Fill right | Ctrl-R |
Find | Ctrl-F |
Format commas (2 decimal places) | Ctrl-Shift ! |
Format currency (2 decimal places) | Ctrl-Shift $ |
Format date (day, month, year) | Ctrl-Shift # |
Format exponential number (2 decimal places) | Ctrl-Shift ^ |
Format general number | Ctrl-Shift ~ |
Format percentage (0 decimal places) | Ctrl-Shift % |
Format time (hour and minute) | Ctrl-Shift @ |
Formula | = |
Function Wizard | Shift-F3 |
GoTo | Ctrl-G |
Group row/column | Alt-Shift-Right |
Hard Return in cell | Alt-Enter |
Hide selected column(s) | Ctrl-0 (zero) |
Hide selected row(s) | Ctrl-9 |
Insert chart sheet | F11 |
Insert Function components | Ctrl-Shift-A |
Insert range | Ctrl-Shift-Plus |
Insert worksheet | Shift-F11 |
Italics | Ctrl-I |
Menu bar | F10 |
Move between noncontiguous selections | Ctrl-Alt-Left/Right |
Move left/right one screen | Alt-PgUp/PgDn |
Move to beginning of worksheet | Ctrl-Home |
Move to edge of region | Ctrl-Arrow |
Move to end of row | End, Enter |
Move to end of worksheet | Ctrl-End |
Move to next corner of selection | Ctrl . |
Move up through a selection | Shift-Enter |
Name a range (Insert/Name/Create) | Ctrl-Shift-F3 |
Name a range (Insert/Name/Define) | Ctrl-F3 |
New | Ctrl-N |
Next window | Ctrl-F6 |
Next worksheet | Ctrl-PgUp |
Open | Ctrl-O |
Outline symbols display/hide | Ctrl-8 |
Paste | Ctrl-V |
Paste named range (Insert/Name/Paste) | F3 |
Previous window | Ctrl-Shift-F6 |
Previous worksheet | Ctrl-PgDn |
Ctrl-P | |
Repeat Find | Shift-F4 |
Repeat/Redo | Ctrl-Y |
Replace | Ctrl-H |
Save | Ctrl-S |
Save As | F12 |
Scroll to display active cell | Ctrl-Backspace |
Select array to which active cell belongs | Ctrl / |
Select cells directly referred to by selected formula | Ctrl [ |
Select cells referred to by selected formula | Ctrl-Shift { |
Select cells with comments | Ctrl-Shift ? |
Select column | Ctrl-spacebar |
Select current region | Ctrl-Shift * |
Select formulas that directly refer to active cell | Ctrl ] |
Select formulas that refer to active cell | Ctrl-Shift } |
Select objects on worksheet | Ctrl-Shift-spacebar |
Select row | Shift-spacebar |
Select to beginning of row | Shift-Home |
Select to beginning of worksheet | Ctrl-Shift-Home |
Select to edge of region | Ctrl-Shift-(Arrow) |
Select to end of row | End, Shift-Enter |
Select to end of worksheet | Ctrl-Shift-End |
Select visible cells in selection | Alt ; |
Select worksheet | Ctrl-A |
Shortcut menu | Shift-F10 |
Spelling and Grammar check | F7 |
Strikethrough on/off | Ctrl-5 |
Style box | Alt ' |
Tab inserted | Ctrl-Alt-Tab |
Time | Ctrl-Shift-Colon |
Underline | Ctrl-U |
Undo | Ctrl-Z |
Ungroup row/column | Alt-Shift-Left |
Unhide column(s) | Ctrl-Shift ) |
Unhide row(s) | Ctrl-Shift ( |
Useful links, tidbits, and other real world info. Plus assorted thoughts and opinions on this world.
Wednesday, November 19, 2008
Excel Shortcut keys from Joy E. Daniels
Subscribe to:
Post Comments (Atom)
35 comments:
Thanks for sharing this excel tricks.
Regards,
Excel courses in Chennai | Excel vba Training in Chennai
I have read your blog its very Interesting. Thanks for sharing. ERP Providers in Chennai | ERP in Chennai
Thank you for this wonderful information. I have got some important suggestions from it. erp software company in chennai | erp providers in chennai. Get your business to the next level in simple steps.
Really Nice Blog. Thank you for Sharing. We are the best erp software providers in chennai. For more details call +91 9677025199 or email us on info@bravetechnologies.in.
ERP in Chennai
Good post..Keep Sharing.! I'm working in brave technologies private limited. We are the leading ERP software development company in chennai.
Your website content nice nice and interesting to observe.
office 2013 professional plus key deutsch
Your Blog is really interesting to read.thanks for sharing such a wonderful article..
Java Project Center in Chennai | Best Java Projects in Velachery
Interesting post! This is really helpful for me. I like it! Thanks for sharing!
online marketing lüdenscheid
Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
java training in bangalore
It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
Selenium Training in Chennai
Selenium Training in Bangalore
It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
Selenium Training in Chennai
Selenium Training in Bangalore
It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
Selenium Training in Chennai
Selenium Training in Bangalore
It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
Selenium Training in Chennai
Selenium Training in Bangalore
really good
jobbörse südwestfalen
your information is really awesome as well as it is very excellent and i got more interesting information from your blogwhite label website builder
mobile website builder
Really nice post.Thanks for sharing.
jobbörse siegerland
Your website content nice nice and interesting to observe.
jobbörse Neunkirchen
Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
AWS Training in Chennai
really good
Jobvermittlung
amazing
personalrekrutierung,
Those guidelines additionally worked to become a good way to
recognize that other people online have the identical fervor like mine
to grasp great deal more around this condition.
digital marketing training in chennai
seo training in chennai
Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
Linux Training Institute in Chennai | Linux Training Institute in Chennai
Impressive blog with lovely information. really very useful article for us thanks for sharing such a wonderful blog.
Digital Marketing Training Institute in Chennai | SEO Training in Chennai
I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have taken for this.
Digital Marketing Training Institute in Chennai | SEO Training in Chennai
Learned a lot from your blog. Good creation and hats off to the creativity of your mind. Share more like this.
Loadrunner Training in Chennai
French Classes in Chennai
Big Data Training in Chennai
Hadoop Training in Chennai
Android Training in Chennai
Selenium Training in Chennai
Digital Marketing Course in Chennai
JAVA Training in Chennai
selenium certification in chennai
Really superb!!! I read your blog regularly and your content is truly good. I thank you for your effective and useful post.
IELTS coaching in Chennai
IELTS coaching centre in Chennai
IELTS Training in Chennai
Best IELTS coaching in Chennai
Best IELTS coaching centres in Chennai
Very good keep posting article
Advance Excel Training
Thanks for this kind of worthy information. this was really very helpful to me. keep continuing.
Best IELTS Classes in Mulund
IELTS Centres in Mulund East
IELTS Coaching Classes in Mulund
IELTS Training in Mulund
IELTS Coaching Centres in Mulund
Best IELTS Course in Mulund West
IELTS Training Institute near me
Nice article I was really impressed by seeing this blog, it was very interesting and it is very useful for me.
CCNA Course in Chennai
CCNA Training in Chennai
RPA Training in Chennai
Ethical Hacking Course in Chennai
Blue Prism Training in Chennai
CCNA Classes in Tambaram
CCNA Training in OMR
CCNA Training in Velachery
Thank you so much for providing information on this. It was very useful.
best aviation academy in Chennai
air hostess institute in Chennai
Airline Courses in Chennai
airport ground staff training in Chennai
medical coding institute in Chennai
weekend fashion designing courses in Chennai
interior design courses in Chennai part time
The young boys ended up stimulated to read through them and now have unquestionably been having fun with these things.
fire and safety course in chennai
Thanks for posting this article it has really a good content.
Spoken English Classes in Chennai
Spoken English in Chennai
German Classes in Chennai
TOEFL Coaching in Chennai
IELTS Coaching in Chennai
spanish language in chennai
Spoken English Classes in Velachery
Spoken English Classes in Tambaram
Hello, I read your blog occasionally, and I own a similar one, and I was just wondering if you get a lot of spam remarks? If so how do you stop it, any plugin or anything you can advise? I get so much lately it’s driving me insane, so any assistance is very much appreciated.
Machine Learning Training in Chennai | Machine Learning Training Institute in Chennai
Devops Training in Chennai | Devops Training Institute in Chennai
Data Science Training in Chennai | Data Science Course in Chennai
Selenium Training in Chennai | Selenium Training Institute in Chennai
Blue Prism Training in Chennai | Blue Prism Training Institute in Chennai
PHP Training in Chennai | PHP Training Institute in Chennai
Bigdata Training in Chennai | Bigdata Training Institute in Chennai
Power BI Training in Chennai | Power BI Training Institute in Chennai
Nice post, I was impressed to your blog and This is very interesting. I want more unique post and keep sharing.
Power BI Training in Chennai
Power BI Training
Tableau Training in Chennai
Spark Training in Chennai
Oracle Training in Chennai
Unix Training in Chennai
Oracle DBA Training in Chennai
Social Media Marketing Courses in Chennai
Pega Training in Chennai
Primavera Training in Chennai
Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
Regards,
cloud computing courses in chennai | Data Science Training in Chennai | digital Marketing Training in Chennai | salesforce training in chennai | software testing training in chennai
Post a Comment