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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base