Excel

Top 30 Excel Keyboard Shortcuts Using The Control Function

February 12, 2015

Become An Excel Master

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 end—this 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.

You Might Also Like

2 Comments

  • Reply Daron Willer February 20, 2015 at 4:20 pm

    These are such useful and efficient shortcuts! Thanks for sharing!

  • Reply Esther Maguire February 20, 2015 at 7:24 pm

    Daron, I’m so happy you found these tools helpful! Will definitely continue to share Excel tips as I come across them! Thank you for commenting.

  • Leave a Reply