September 20
Excel :- Keyboard Shortcut Keys
"Where can I find a complete list of Excel keyboard shortcut key?' This question comes up in my classes from time to time. You can find a full list on the Office On-Line web site. You may find the list just a little overwhelming, given that one or more shortcuts are associated with most or your keyboard keys. So, here a few of what I consider to be the more useful shortcut combinations.
| Shortcut | Description | Comment |
| CTRL + ; | Enter the current date | unchanging date stamp |
| CTRL + : | Enter the current time | unchanging time stamp |
| | | |
| CTRL + ` | Toggle display of cell values and formulas on the worksheet | this is the key on the left side of top row of standard keys (beside the '1' key |
| | | |
| CTRL + ' | Copies the formula from the cell above | |
| CTRL + SHIFT + " | Copies the value from the cell above | |
| | | |
| CTRL + SHIFT + * | Selects cells around the active cell bounded by blank rows and columns | this is the shifted 8 key in the top row of standard keys |
| | | |
| CTRL + HOME | Moves to the beginning of the worksheet | Usually moves to cell A1 unless Freeze Panes is in effect then CTRL + HOME will move to the Top Left Cell of the Bottom Right Quadrant |
| CTRL + SHIFT + HOME | Extends the selection from the current cell to the beginning of the worksheet | If Freeze Panes is in effect, extends the selection from the current cell to the Top Left Cell of the Bottom Right Quadrant (if the Active Cell is in the Bottom Right Quadrant).
If the Active Cell is not in the Bottom Right Quadrant, extends the selection to include the Top Left Cell of the Bottom Right Quadrant. |
| | | |
| CTRL + 9 | Hide the selected rows | |
| CTRL + 0 | Hide the selected columns | |
| CTRL + SHIFT + ( | Unhide rows within the selection | |
| CTRL + SHIFT + ) | Unhide columns within the selection | |
| | | |
| CTRL + C | Copy | Repeat CTRL + C to open the Office Clipboard |
| CTRL + X | Cut | |
| CTRL + V | Paste the last item cut or copied | If the marquee is active |
| | | |
| CTRL + Z | Delete the last entry you typed or reverse the last command you executed | |
| CTRL + Y | Repeat the last command or action if possible | (Re-does the last undo) |
| | | |
| F3 | Opens the Insert Name dialogue | useful to ensure you don't misspell user defined names in formulas |
| F4 | Creates absolute reference | while entering a formula |
This is just a small selection of the keyboard shortcuts available in Excel. Check the Office Online link at the beginning of this article for more that may be useful to you.
Tools 
Help
