Techies Hangout Headline Animator

Techies Hangout

Featured Video

Tuesday, May 17, 2011

Microsoft Excel Shortcut Keys, Basic, Easy and Useful

Top Blogs


Microsoft Excel Shortcut Keys


Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts

ShortcutDescription
Double-click (on a cell)Edit the cell contents.
Double-click (on a row/column divider)Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column dividerAdjust height/width to auto-fit of all high-lighted rows/columns
Triple-clickSelect the entire contents in the cell
Click on row/column divider then dragAdjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then dragAdjust height/width of the rows/colunns
Ctrl + Mouse wheelZooms in and out of document.
Hold Shift + Click the cellsSelect multiple cells


Keyboard shortcuts

ShortcutDescription
F2Edit the selected cell.
F5Goto a specific cell. For example, C6.
F7Spell check selected text and/or document.
F11Create chart.
Ctrl + ASelect all.
Ctrl + BBold.
Ctrl + CCopy.
Ctrl + FFind (same as Shift + F5).
Ctrl + GGo To.
Ctrl + HReplace.
Ctrl + IItalic.
Ctrl + KInsert link.
Ctrl + NNew Workbook.
Ctrl + OOpen Workbook.
Ctrl + PPrint dialog.
Ctrl + SSave.
Ctrl + UUnderline.
Ctrl + VPaste.
Ctrl + ZUndo.
Ctrl + YRedo.
Ctrl + XCut.
Ctrl + 5Strikethrough text.
Ctrl + F3Define Name.
Ctrl + F4Exit Excel.
Ctrl + F6Switch between open workbooks.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize current window.
Shift + F1Activate Help on Item.
Shift + F2Insert Comments
Shift + F3Insert Function.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Ctrl + Page downMove to next worksheet.
Ctrl + Page upMove to previous worksheet.
Ctrl + Shift + #Number Format: Date
Ctrl + Shift + @Number Format: Time.
Ctrl + Shift + !Number Format: Commas.
Ctrl + Shift + $Number Format: Currency
Ctrl + Shift + %Number Format: Percentage
Ctrl + Shift + ^Number Format: Scientific.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.
Ctrl + (Arrow key)Move to next section.

1 comments:

Very helpful short cuts. I know some of these short cuts. and most are new for me. To know about technology world visit techni.

Post a Comment

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More