Wednesday, November 19, 2008

Excel Shortcut keys from Joy E. Daniels

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
Print 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 (

24 comments:

Jhon Abraham said...

Thanks for sharing this excel tricks.
Regards,
Excel courses in Chennai | Excel vba Training in Chennai

Evelin Harriet said...

I have read your blog its very Interesting. Thanks for sharing. ERP Providers in Chennai | ERP in Chennai

Siva Seo said...

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.

Shivani Yuvanjalin said...

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

Brave Technologies said...

Good post..Keep Sharing.! I'm working in brave technologies private limited. We are the leading ERP software development company in chennai.

annika romy said...

Your website content nice nice and interesting to observe.
office 2013 professional plus key deutsch

chandhu said...

Your Blog is really interesting to read.thanks for sharing such a wonderful article..
Java Project Center in Chennai | Best Java Projects in Velachery

ALINAAMEL said...

Interesting post! This is really helpful for me. I like it! Thanks for sharing!
online marketing lüdenscheid

anudeep bichal said...

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

ijazz jazz said...

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

ijazz jazz said...

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

ijazz jazz said...

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

ijazz jazz said...

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

brunagari said...

really good
jobbörse südwestfalen

shabaz r said...

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

brunagari said...

Really nice post.Thanks for sharing.
jobbörse siegerland

brunagari said...


Your website content nice nice and interesting to observe.
jobbörse Neunkirchen

mari A said...

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

brunagari said...

really good
Jobvermittlung

brunagari said...


amazing
personalrekrutierung,

Jahan Murugassan said...

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

krishna swamy said...

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

Gandhi I said...

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

Gandhi I said...

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