It doesn’t do a little red line underneath to warn you, either… but let’s face it, this program is all about the numbers, not the text. Have you ever seen a little red triangle in the corner of a cell and wondered what it’s all about?Īre you like, meh, I know all this already? Then this post is still for you, as I give a couple of pointers about spell checks and show you some really cool things to do with comments which few people seem to know about. Have you ever sent a spreadsheet to a client or colleague and then realised there’s a glaring spelling mistake? Saving your spreadsheets into other file formats.Merging cells, wrapping text, cell alignment and super/subscript.Here are other things you can do with threaded comments on your iPhone: Here are other things you can do with threaded comments on your iPad:Ĭlick the green down arrow once you are done.
Excel 2016 show comments when printing android#
Here are other things you can do with threaded comments on your Android phone: Tap Comment, type your comment, and then tap the Post button. (the ellipsis icon) next to the first comment in the thread, and tap Resolve thread. To resolve a thread, tap the cell (that has the comment), tap the purple comment icon that appears above it, tap. (the ellipsis icon) next to the first comment in the thread, and tap Delete thread. 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. 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). Right-click the cell and then click New Comment.
0 kommentar(er)
