Feedback by UserVoice

How can we improve Excel for Mac?

Not working anymore the shift+cmd+* shortcut!!

Hi!

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

2 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Marco Mojarro shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base