Shortcuts in Excel for macOS using asterisk key (*)

Select range of non-empty cells around the active cell

control  +  Shift  +   *