Many of you are transitioning to Excel for the Mac, and have asked us what our favorite Excel Mac shortcuts are. Ctrl+Shift+Spacebar selects the entire worksheet. Shift+Spacebar selects an entire row in a worksheet. Ctrl+Spacebar selects an entire column in a worksheet. In a dialog, performs the action for the selected button, or selects or clears a check box. 222 Excel shortcuts for Windows and Mac File Ribbon General Tables and Filters Drag and Drop Navigation Selection Active Cell Extend Selection Select Special Cell edit mode Entering data Formatting Number Formatting Borders Formulas Grid Operations Pivot Tables Workbook Dialog boxes Other.