Home »
» Microsoft Excel Shortcut Keys
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
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:
Post a Comment