noobcj.blogg.se

1. #Excel for mac 2016 comments how to
2. #Excel for mac 2016 comments full
3. #Excel for mac 2016 comments android

To delete an entire thread, tap the cell (that has the comment), tap the purple comment icon that appears above it, tap. To delete a particular comment in a thread, tap the cell (that has the comment), tap the purple comment icon that appears above it, tap the comment you want to delete, and then tap Delete. Modify the comment as necessary and then click Save. To edit a particular comment in a thread, tap the cell (that has the comment), tap the purple comment icon that appears above it, tap the particular comment you want to edit, and then tap Edit. To view all threads in the worksheet, tap Review and then tap Show Comments. To view a particular thread, tap the cell, and then tap the purple comment icon.

#Excel for mac 2016 comments android

Here are other things you can do with threaded comments on your Android tablet: To reply to a comment, tap the cell (that has the comment), tap the purple comment icon that appears above it, and in the Reply text box, enter a reply and tap the Post button. Type your comment and tap the Post button. In an Excel workbook, tap in the worksheet. Anyone who has write access to a workbook can resolve or reopen comments. The comment will still be viewable, but no further additions can be made to it unless it's reopened. If a comment thread is complete, then you can mark it as Resolved: rest your cursor over the cell, then click More thread actions > Resolve thread. Then select the comment, select the More thread actions menu, and select Edit comment. If you need to edit a threaded comment, rest your cursor over the cell. If other people have something to add, they can right-click the cell and choose New Reply. Select the Post Comment button (or press Ctrl+ Enter).

Right-click the cell and then select New Comment. If a comment thread is complete, then you can mark it as Resolved: rest your cursor over the cell, then click. Then rest your cursor over the reply text itself, and click Delete. If you need to delete a reply, rest your cursor over the cell. If you need to delete a threaded comment, right-click the cell and then click Delete Comment. Then rest your cursor over the comment text itself, and click Edit. If other people have something to add, they can right-click the cell and choose Reply to Comment. You can someone to address the comment to them - this sends them email notification of the comment.Ĭlick the Post button (or press Ctrl+Enter). There's every chance the inexperienced user will never realise that the apparently same "Format Comment." option available at the comment border actually reveals a whole lot more tabs.Right-click the cell and then click New Comment. What I find disappointing about the Excel UI in this case is that right-clicking while hovering over the body of the comment instead produces a context menu that looks almost exactly the same (one word is different: "Exit Edit Text" replaces "Edit Text"), but here the "Format Comment." option reveals only the Font tab.

#Excel for mac 2016 comments full

On mine (Excel 2016) there's a sense in which both suggestions for step 2 are correct: if I hover over one of the 'o handles' (turning the cursor into a double-headed arrow _or_ if I hover over any other part of the comment border (turning the cursor into a four-headed arrow) I can right-click and Format Comment will then reveal the full set of tabs including Colors and Lines. I agree with Redd, Manning - these tips are very valuable and welcome, notwithstanding slight variations between systems and versions. You can then follow steps 4 through 7, the same as above. Adjust the transparency of the fill color, as desired.Īn alternative way to display the Format Comment dialog box is to simply click once on the comment (step 1) and then press Ctrl+1.Use the Color drop-down list (the one at the top of the dialog box) to specify what color you want used to fill your comment box.Make sure the Colors and Lines tab is displayed.Word displays the Format Comment dialog box. Right-click and then choose Format Comment from the resulting Context menu.Hover the mouse pointer over the border it will look like a four-headed arrow.

Handles should appear around the border of the comment.

#Excel for mac 2016 comments how to

When working with comments, Heather figured out how to change the font color in the comment.