Oh Excel…the bane (of a majority) of corporate America’s existence.
While we can all hate away on the tedious chores assigned to us using Excel, I like to think that if I’m going to be forced to spend a large amount of my time in a program, I should master it.
I’ve given a few, “Become An Excel Master” corporate training sessions for new hires at my company and below I have shared the Top 30 Excel Keyboard Shortcuts using the control function that I have received feedback in being the most valuable (and I hope you do to).
These shortcuts are just the tip of the iceberg and there is so much more out there to use in your arsenal of tips and tricks. For example, there are numerous shortcuts using the function key. However, I find that each PC (including MAC’s) performs different tasks when using the function key, making it frustrating for users in search of new shortcuts. Thankfully, control function seems to work across platforms so I hope you find these available for immediate use!
Happy Spread Sheet Wednesday!
|Alt+ESV||Pastes copied cells as values|
|Ctrl+Y||Repeats the last command or action, if possible.|
|Ctrl+0||Hides the selected columns.|
|Ctrl+9||Hides the selected rows.|
|Ctrl+Shift+9||Unhides the selected rows|
|Ctrl+C||Copies the selected cells.|
|Ctrl+D||Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.|
|Ctrl+End||Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.|
|Ctrl+A||Selects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time, it selects the entire worksheet.|
|Ctrl+F||Displays the Find and Replace dialog box, with the Find tab selected.|
|Ctrl+H||Displays the Find and Replace dialog box, with the Replace tab selected.|
|Ctrl+Home||Moves to the beginning of a worksheet.|
|Ctrl+Minus||Displays the Delete dialog box to delete the selected cells. If you select an entire row or column, it will delete it all without the “Delete Dialog Box”|
|Ctrl+Shift+Plus||Displays the Insert dialog box to add additional cells. If you select an entire row or column, it will add an entire row or column without the “Insert” Dialog Box.|
|Ctrl+Page-Down||Moves to the next sheet in a workbook.|
|Ctrl+Page-Up||Moves to the previous sheet in a workbook.|
|Ctrl+Right-Arrow||Moves to the right corner of the current data region in a worksheet.|
|Ctrl+S||Saves the active file with its current file name, location, and file format.|
|Ctrl+Shift+:||Enters the current time.|
|Ctrl+Shift+Down-Arrow||Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.|
|Ctrl+Shift+End||Extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the endthis does not affect the height of the formula bar.|
|Ctrl+Shift+Home||Extends the selection of cells to the beginning of the worksheet.|
|Ctrl+Shift+Page-Down||Selects the current and next sheet in a workbook.|
|Ctrl+Shift+Page-Up||Selects the current and previous sheet in a workbook.|
|Ctrl+Shift+Right-Arrow||Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.|
|Ctrl+Shift+Spacebar||Selects the entire worksheet. If the worksheet contains data, the key combination selects the current region. Pressing the key combination a second time selects the current region and its summary rows. Pressing the key combination a third time selects the entire worksheet. When an object is selected, the key combination selects all objects on a worksheet.|
|Ctrl+Shift+Up-Arrow||Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.|
|Ctrl+Spacebar||Selects an entire column in a worksheet.|
|Ctrl+Up-Arrow||Moves to the top of the current data region in a worksheet.|
|Ctrl+V||Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.|