How to Use Excel Keyboard Shortcuts to Cut, Copy and Paste Formulas and Formatting

Keyboard Shortcuts for Cut, Copy & Paste

Keyboard Shortcuts for Cut, Copy & Paste

In addition to showing you the Keyboard Shortcuts to Cut, Copy and Paste in Excel, I demonstrate how these actions affect formulas and formatting.

Topics in this Tutorial

Here are the topics that I demonstrate in this video tutorial:

  • Select multiple cells using the keyboard
  • Use Ctrl + Enter to update all cells in the selection
  • Use Ctrl + ~ to “toggle” between showing and hiding formulas in all cells
  • Use F2 to edit in the cell – and to diagram cell references for formulas
  • Use Ctrl + C to copy the “relative cell references” in a formula
  • Use Ctrl + X to cut an Excel formula that retains the original cell references
  • Open and use the Office Clipboard to store up to 24 most recent copy and cut items
  • Use Ctrl + Z to undo multiple actions
  • Use Ctrl + A to select all cells in a contiguous range
  • Use the Delete key to delete the contents of a cell or range while retaining the formatting
  • Use the Clear All command to remove both formatting and contents in a range of cells

Download My Complete Charts of Popular Keyboard Shortcuts

Follow this link to my Excelusive Membership Content Page where you can download all of my charts and tables of Keyboard Shortcuts.

Watch Video in High Definition

Follow this link to view this tutorial in High Definition on my YouTube Channel – DannyRocksExcels

Keyboard Shortcuts – Part 1

Here are the steps to follow in this lesson:

  1. All shortcuts in this lesson require you to hold down the “CTRL” key while you press a single Letter.
  2. Ctrl+A will select either all of the cells in the current worksheet or just the range of cells where you are working.
  3. Ctrl+B (Bold), Ctrl+I (Italic) and Ctrl+U (Underline) will “toggle” the formatting on or off.
  4. Ctrl+D (Fill Down) and Ctrl+R (Fill Right) require you to select a range of cells beforehand.
  5. The “Office Clipboard” allows you to retain 24 items in memory. You can use them in all of the applications across the MS Office Suite. (Ctrl+F1 brings up the Task Pane for the Clipboard)
  6. Ctrl+Z (Undo) and Ctrl+Y (Redo) apply to the last 16 actions (provided you have not “saved” the workbook.)

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.