About This Shortcut

This shortcut toggles the visibility of the total row in an Excel Table. It’s equivalent to using the “Total Row” checkbox on the Table tab of the ribbon.

About This Shortcut

The default behavior for drag and drop is to cut data in cells (similar to using Edit > Cut). Just select the cells you want to cut, hover the mouse cursor over the selection until the cursor turns into a four headed arrow, and drag the selection to a new location.