Three ways to add Excel cell annotations: 1. Right-click the cell and select "New Comment" to add it; 2. Use the shortcut keys Shift F2 (Windows) or Command Option U (Mac) to quickly open the comment box; 3. View or edit existing comments by hovering over, or you can right-click to select "Edit Comment" or drag to adjust the comment box size.

Adding a comment to a cell in Excel is a handy way to leave notes or explanations without changing the actual data. It's simple once you know how, and it works pretty much the same whether you're using Excel on Windows, Mac, or even the online version.

Right-click and Add Comment

The most straightforward way is using the right-click menu. Just click on the cell you want to add a comment to, then right-click. In the menu that pops up, look for “New Comment” (or sometimes “Insert Comment”). Click that, and a box will appear next to the cell where you can type your note.

• This method works across all desktop versions of Excel.
• You'll see a small red triangle appears in the corner of the cell to indicate there's a comment.
• If you're using Excel Online, the option might say “Add Comment” instead of “New Comment.”

Once you're done typing, just click outside the comment box or hit "Enter" — your note is saved.

Keyboard Shortcut for Faster Commenting

If you like working with shortcuts to save time, there's a quick one for adding comments too. After selecting the cell, press Shift F2 (on Windows) or Command Option U (on Mac). That opens the comment box directly, so you can start typing without reaching for the mouse.

This comes in handy when you're going through multiple cells and want to leave notes quickly. It's easy to forget the shortcut at first, but after a few uses, it becomes second nature.

View and Edit Existing Comments

Once a comment has been added, you don't need to re-open the menu every time you want to read or change it. Just hover your mouse over the cell with the red triangle, and the comment will pop up automatically.

If you need to make changes:

• Right-click the cell and choose “Edit Comment”
• Or use the same keyboard shortcut ( Shift F2 ) to jump straight into editing mode

You can also resize the comment box by dragging its corners if the default size is too small for your message.

Basically that's it. Whether you're leaving yourself reminders or collaborating with others, comments are a great way to keep context without cluttering your spreadsheet.

The above is the detailed content of how to add comments to a cell in excel. For more information, please follow other related articles on the PHP Chinese website!