Not working anymore the shift+cmd+* shortcut!!
Could you please help me with the following issue related to this post?
I have Excel 2016 in a Mac and previously I was using the following shortcut to select ONLY VISIBLE ROWS from filtered data:
SHIFT + CMD + *
After that I could copy the data and will copy only the visible information and not the hidden information, or I could delete only the visible rows without deleting the hidden ones.
But a month or so ago after an update I cannot longer do that and when I do SHIFT + CMD + * what it does is to select all cells including the headings and it includes the hidden cells.
Do you know if there's a new shortcut to do what I was previously doing? Or another way to do so? Take into account that in Mac there's no "GoTo Special" function available.
Thanks in advance