If you’re on Mac, there are a few steps you should start with:
Preparing to Go Mouse-less on Excel for Mac
Cntrl + Shift + Arrow to highlight an array of empty or full cells.F4 to toggle between anchor references in a formula.Cntrl + Click & Drag sheet to duplicate the sheet.Cntrl + A to highlight a table, array, or the whole workbook.Cntrl + H + E + S to open the paste window, then navigate to appropriate paste values selection with the arrow keys.
If you’re a data analyst, a business analyst, a financial professional (or anyone who uses Excel for that matter) then you know the feeling of wanting to move faster in Excel.