When you point your mouse to the cell and pause a short while, the comment will appear and you can read it: These are handy little things that can act as explanatory notes or reminders. Adding comments (or РІР‚Вthose little red trianglesРІР‚в„ў)Р”Р„ red triangle in the right corner of your cell means someoneРІР‚в„ўs added a Comment. Select all your sheets (go here for a reminder) before you press F7 or go to Review, Spelling. Of course, if you have no data below P32 РІР‚вЂњ say, itРІР‚в„ўs all in A1:G15 РІР‚вЂњ this is the first thing youРІР‚в„ўll see! It can really confuse people if they donРІР‚в„ўt know thatРІР‚в„ўs the way itРІР‚в„ўs thinking! Important note 3: This is fine if youРІР‚в„ўre in cell A1, but if youРІР‚в„ўre in, say, cell P32, itРІР‚в„ўll start from there and when it gets to the end, itРІР‚в„ўll ask you if you want to carry on from A1 back to P32: People merrily click Change without actually appraising what theyРІР‚в„ўre amending! YouРІР‚в„ўre in luck with this error, though, as Excel will change it automagically.) Important note 2:Р”В®xcel will start its spell check from whatever cell youРІР‚в„ўre in (your active cell). As РІР‚ВdefinateРІР‚в„ў is a common misspelling of РІР‚ВdefiniteРІР‚в„ў, when the spell check hits this word it will suggest РІР‚ВdefiantlyРІР‚в„ў before РІР‚ВdefinitelyРІР‚в„ў, as it can often list suggestions in alphabetical order. (Incidentally, this is why I think some people put РІР‚ВdefiantlyРІР‚в„ў when they mean РІР‚ВdefinitelyРІР‚в„ў. In the example below, weРІР‚в„ўre talking car manufacturers, so the first option is wrong and IРІР‚в„ўd have to click on Renault before clicking on Change. When it finds a problem, itРІР‚в„ўll list suggestions РІР‚вЂњ you can choose to Ignore this one suggestion or Ignore All of them or Change to this one suggestion or Change All identical errors to the same suggestion.Р”ВonРІР‚в„ўt just automatically accept the first choice on offer!Sometimes itРІР‚в„ўs not correct. ItРІР‚в„ўll scan through, cell by cell, and pick up anything it thinks should be changed. (That works in Microsoft Word and PowerPoint as well, by the way!)Р”Р„lternatively, you can click the Review tab and Spelling is the very first button on the left hand side. To spell check, I use another keyboard shortcut: F7. 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.

If you want to print your document together with your comments (along with any other markup made to your document), make sure Print Markup is selected and that you choose one of the options in the Document section.If you want to print just your comments (along with any other markup made to your document), choose List of Markup in the Document Properties section (Word 2010) or Document Info section (later versions of Word).The choices in this drop-down list allow you to specify exactly what it is you want to print. Click the drop-down list immediately under the Settings label.Word displays the Print portion of the File tab. If you are using Word 2010 or a later version, follow these steps instead: (The first prints just the comments and other document markup, the second prints the document together with any comments and other document markup.) Using the Print What drop-down list, choose either List of Markup or Document Showing Markup.Follow these steps if you are using Word 2007: Word provides a variety of ways that your comments can appear when printed. If you've defined a group of comments in your document, you may want to print them at some time.

Excel 2016 show comments when printing