When I switched to the ribboned version of Excel it was indescribably painful. I was quick and efficient at Excel and I knew exactly where I needed to go to get what I wanted. The ribboned version blew all of my knowledge out of the water. This interactive tool from Microsoft was very useful. But I also grew to love the Quick Access Toolbar and every time I go to use Mac for Excel I’m disappointed that I don’t have one.
Step 1: select the little down arrow next to the current Quick Access Toolbar options
Step 2: Select “More Commands”
Step 3: This should give you a screen like this:
There are a number of functions/commands that I like to utilize in Excel that I can’t ever find unless I add them to my quick access toolbar. The main one being the option to “Select Visible Cells”.