The comment’s text doesn’t automatically adjust to the new shape, so be careful which shape you choose.This technique doesn’t change the shape of subsequent or existing comments - only the selected comment changes.You can’t change multiple comments at the same time.Otherwise, you must repeat the process and specify a square AutoShape. Ctrl + Z will undo the change, if you do so immediately. As yet, I’ve not found a way to reset the comment shape.If the new AutoShape isn’t large enough, use the handles to resize it.Īt first, this might seem like a neat visual trick, but it’s limited:.Next, choose one of the shapes from the resulting palette.I had them all to the right of the cell they applied to but now they are all over the place. Some are completely smashed together, while others are extraodinarily wide. Then, select one of the AutoShape categories from the resulting submenu. The comment boxes keep changing shape and location in my spreadsheet.Click the Draw button on the Drawing toolbar and choose Change AutoShapes.When you click the border, it changes to a bunch of small dots. Click the comment’s border - the border appears to be a series of diagonal slashes.Select the cell with the attached comment.In addition to changing the shape, you can also change a variety of other style options. From the drop down menu select your new shape for the comment box. You can change the shape of comments using Excel’s AutoShapes: In the Illustrations section, press the small Shapes icon. They’re easy to insert, edit, print, and delete. Using AutoShapes, you can change that square to any number of shapes.Ĭomments are an interesting and useful feature, allowing you to attach additional information to a cell.
0 kommentar(er)
