July 4, 2016
Using Excel 2010
I have a spreadsheet that contains numerous comments.
I would like to change the appearance of some of them (e.g. - fill colour, remove line, change font, centre align, etc.), in one operation, i.e. - making changes to the selected comments once & not for each comment.
Any tips on how it can be done?
July 16, 2010
There is no built in way to edit comment formatting to all or even some comments in one operation. If the comments are all the same then you could make your changes to one and then Copy and Paste Special > Comment to the other cells you want to apply the changes to.
The other option is to set all comments to 'show' then apply the formatting you want to one comment > then click on the outer edge of that comment > double click the format painter icon > left click once on the outer edge of the other comments you want to apply your formatting to.
Note: You have to get your click perfectly on the outer edge of the comment box otherwise the format painter won't apply correctly.
Otherwise it's VBA, I'm afraid.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas