The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts
Keyboard shortcuts
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. |
No comments:
Post a Comment
Hello Dear,
We hope this post is very useful for you.
If you want any kind help related this post kindly reply.
If You Love Or Like This Post Then Share It With Your Friends.
.
.
.
.
Regards:> internettip Management.