Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.

Use at your own risk.

Mouse shortcuts

Shortcut    Description

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 divider    Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click    Select the entire contents in the cell
Click on row/column divider then drag    Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag    Adjust height/width of the rows/colunns
Ctrl + Mouse wheel    Zooms in and out of document.
Hold Shift + Click the cells    Select multiple cells

Keyboard shortcuts

Shortcut    Description
 

F2    Edit the selected cell.
F5    Goto a specific cell. For example, C6.
F7    Spell check selected text and/or document.
F11    Create chart.
Ctrl + A    Select all.
Ctrl + B    Bold.
Ctrl + C    Copy.
Ctrl + F    Find (same as Shift + F5).
Ctrl + G    Go To.
Ctrl + H    Replace.
Ctrl + I    Italic.
Ctrl + K    Insert link.
Ctrl + N    New Workbook.
Ctrl + O    Open Workbook.
Ctrl + P    Print dialog.
Ctrl + S    Save.
Ctrl + U    Underline.
Ctrl + V    Paste.
Ctrl + Z    Undo.
Ctrl + Y    Redo.
Ctrl + X    Cut.
Ctrl + 5    Strikethrough text.
Ctrl + F3    Define Name.
Ctrl + F4    Exit Excel.
Ctrl + F6    Switch between open workbooks.
Ctrl + F9    Minimize current window.
Ctrl + F10    Maximize current window.
Shift + F1    Activate Help on Item.
Shift + F2    Insert Comments
Shift + F3    Insert Function.
Ctrl + Shift + ;    Enter the current time.
Ctrl + ;    Enter the current date.
Ctrl + Page down    Move to next worksheet.
Ctrl + Page up    Move 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 + Space    Select entire column.
Shift + Space    Select entire row.
Ctrl + (Arrow key)    Move to next section.

0 Comments
Disqus
Fb Comments
Comments :

0 comments:

Post a Comment