Tuesday, May 20, 2014

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.