Hi all. I'm trying to work from home and I'm on my Mac. It's not lost on me that many Excel features just seem more convenient or work better on PC but most of the time I can find a solution for cross platform issues.
I have a frequent need to use 'Select all Visible' cells. On the PC this shortcut works by pressing Ctrl-Shift-8.
On the Mac I've been trying to use Command-Shift-Z and get the following message
'The selection already contains only visible cells'
..and then of course nothing is selected.
Am I missing something? Is there another shortcut that works?
Thanks in advance folks.
I have a frequent need to use 'Select all Visible' cells. On the PC this shortcut works by pressing Ctrl-Shift-8.
On the Mac I've been trying to use Command-Shift-Z and get the following message
'The selection already contains only visible cells'
..and then of course nothing is selected.
Am I missing something? Is there another shortcut that works?
Thanks in advance folks.
