 |
| hackers001.blogspot.com |
Today i am posting shortcuts of Microsoft Excel. 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. |
see also:
shortcuts of microsoft word
great tip - Happy St Paddy's day!
ReplyDeleteit helps me alot
ReplyDeletehttp://ifile.it/e3lbruj
ReplyDeleteall microsoft keys are in txt