| CTRL + A |
Select all contents of a worksheet. |
| CTRL + B |
Bold all cells in the highlighted section. |
| CTRL + C |
Copy all cells in the highlighted section. |
| CTRL + D |
Fill down. |
| CTRL + E |
Adds more values to the active column by using data surrounding that column. |
| CTRL + F |
Displays the Find & Replace dialog box, with the Find tab selected. |
| CTRL + G |
Go to a certain area. |
| CTRL + H |
Find and replace. |
| CTRL + I |
Puts italics on all cells in the highlighted section. |
| CTRL + K |
Inserts a hyperlink. |
| CTRL + N |
Creates a new workbook. |
| CTRL + O |
Opens a workbook. |
| CTRL + P |
Print the current sheet. |
| CTRL + R |
Fill Right. |
| CTRL + S |
Saves the open worksheet. |
| CTRL + U |
Underlines all cells in the highlighted section. |
| CTRL + V |
Pastes everything copied onto the clipboard. |
| CTRL + W |
Closes the current workbook. |
| CTRL + X |
Cuts all cells within the highlighted section. |
| CTRL + Y |
Repeats the last entry. |
| CTRL + Z |
Undo the last action. |
| CTRL + 1 |
Changes the format of the selected cells. |
| CTRL + 2 |
Bolds all cells in the highlighted section. |
| CTRL + 3 |
Puts italics all cells in the highlighted section. |
| CTRL + 4 |
Underlines all cells in highlighted section. |
| CTRL + 5 |
Puts a strikethrough all cells in the highlighted section. |
| CTRL + 6 |
Shows or hides objects. |
| CTRL + 7 |
Shows or hides the toolbar. |
| CTRL + 8 |
Toggles the outline symbols. |
| CTRL + 9 |
Hides rows. |
| CTRL + 0 |
Hides columns. |
| Ctrl + ; |
Enters the current date. |
| Ctrl + ` |
Changes between displaying cell values or formulas in the worksheet. |
| Ctrl + - |
Deletes the selected column or row. |
| Ctrl + + |
Insert. |
| Ctrl + - |
Deletes the selected column or row. |
| Ctrl + / |
Selects the array containing the active cell. |
| Ctrl + \ |
Selects the cells that have a static value or don’t match the formula in the active cell. |
| Ctrl + [ |
Selects all cells referenced by formulas in the highlighted section. |
| Ctrl + ] |
Selects cells that contain formulas that reference the active cell. |
| Ctrl + Enter |
Fills the selected cells with the current entry. |
| Ctrl + Spacebar |
Selects the entire column. |
| Ctrl + Home |
Move to cell A1. |
| Ctrl + End |
Move to last cell on worksheet. |
| Ctrl + Tab |
Move between Two or more open Excel files. |
| Ctrl + F3 |
Open Excel Name Manager. |
| Ctrl + F4 |
Closes current Window. |
| Ctrl + F5 |
Restores window size. |
| Ctrl + F6 |
Next workbook. |
| Ctrl + F7 |
Moves the window. |
| Ctrl + F8 |
Resizes the window. |
| Ctrl + F9 |
Minimize current window. |
| Ctrl + F10 |
Maximize currently selected window. |
| Ctrl + F11 |
Inserts a macro sheet. |
| Ctrl + F12 |
Opens a file. |
No comments:
Post a Comment