| Edit Selected Cells | ||
| Ctrl + d | Copy above cell. | |
| Ctrl + r | Copy cell from the left. | |
| Ctrl + “ | Copy above cell value and edit. | |
| Ctrl + ' (apostrophe) | Copy above cell formulas and edit. | |
| Ctrl + l | Insert a table (display Create Table dialog box). | |
| Ctrl + - | Delete Cell/Row/Column Menu | |
| Ctrl + - with row or Column Selected | Delete row / delete column. | |
| Ctrl + Shift + = | Insert Cell/Row/Column Menu | |
| Ctrl + Shift + = with row or column selected | Insert row/ insert column. | |
| Shift + F2 | Insert / Edit a cell comment. | |
| Shift + f10, then m | Delete comment. | |
| Alt + F1 | Create and insert chart with data in current range as embedded chart object. | |
| F11 | Create and insert chart with data in current range in a separate Chart sheet. | |
| Ctrl + k | Insert a hyperlink. | |
| Select inside cells | ||
| Shift + Arrow Left | Select or unselect one character to the left. | |
| Shift + Arrow Right | Select or unselect one character to the right. | |
| Ctrl + Shift + Arrow Left | Select or unselect one word to the left. | |
| Ctrl + Shift + Arrow Right | Select or unselect one word to the Right. | |
| Shift + Home | Select from the insertion point to the beginning | |
| Shift + End | Select from the insertion point to the End |
Thursday, April 25, 2013
Excel Short Cuts Part-3
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment