Not all things in Microsoft Excel for Mac require a fancy shortcut. Sometimes Microsoft makes our lives much easier with the ever-improving toolbar. The toolbar is that confusing looking thing above your worksheet that looks like this:
As you can see there are multiple tabs on the toolbar labeled Home, Layout, Tables, Charts, SmartArt, Formulas, Data, and Review. For our tip today we are going to be living in the Review tab.
Once you click on the review tab a new set of icons will appear.
The first icon is to check spelling and grammar. Something that is not often required in Microsoft Excel, but if you need it, it’s there. The second icon is what enables us to insert a comment into a cell in our Microsoft Excel spreadsheet.
Now select the cell you wish to insert the comment in.
Once the cell is selected, click the 2nd icon on the Review toolbar labeled New. This will pop open a comment box.
From here you can insert any information you want about the selected cell.
Once you click away from the sticky note, the comment will be hidden in the cell so it does not disrupt your spreadsheet too much. To reopen the comments simply slide your mouse over the red triangle in the upper right hand side of the cell and your comment will appear.
You will notice now all of the comment icons on the toolbar are available to use, where as before inserting a comment only the New comment icon was clickable.
Comments are a great way of adding hidden information to cells. The comment will only pop up when you want it to, and you can reduce clutter in your spreadsheet.
Comments will be approved before showing up.