Use the Clear All command to remove both formatting and contents in a range of cellsĭownload My Complete Charts of Popular Keyboard Shortcutsįollow this link to my Excelusive Membership Content Page where you can download all of my charts and tables of Keyboard Shortcuts.Use the Delete key to delete the contents of a cell or range while retaining the formatting If youre disappointed by your elected officials, grab a clipboard, get some signatures, and run for office yourself.Use Ctrl + A to select all cells in a contiguous range.Open and use the Office Clipboard to store up to 24 most recent copy and cut items.Use Ctrl + X to cut an Excel formula that retains the original cell references.Use Ctrl + C to copy the “relative cell references” in a formula.Use F2 to edit in the cell – and to diagram cell references for formulas.Use Ctrl + ~ to “toggle” between showing and hiding formulas in all cells.Use Ctrl + Enter to update all cells in the selection.

Select multiple cells using the keyboard.Here are the topics that I demonstrate in this video tutorial: In addition to showing you the Keyboard Shortcuts to Cut, Copy and Paste in Excel, I demonstrate how these actions affect formulas and formatting.

Definition of office clipboard