26 votesJeff Chapman commented
This is a good observation. It's an annoying problem, no doubt.
That said, I wouldn't count on Microsoft fixing Excel 2011. Excel 2016 has already been released, and that is where their efforts are going.
In the meantime, I have a workaround for you. To select all objects on a worksheet in Excel 2011, select one object, and then type Command+A. That will select them all for you. Then, you can use Command+click to unselect only certain objects. It's quite easy, but a bit of a hidden trick.
In Excel 2016 for Mac, Microsoft has added a Selection pane. You're now able to select, hide, and even rename any and all objects on a worksheet. It's much more convenient. Unfortunately, Excel 2016 for Mac compares poorly to Excel 2011 (so far) in terms of basic performance, scrolling and so on. Anyway, hope this helps.
6 votesJeff Chapman shared this idea ·