Register
Log In
Unanswered
Home
July 4, 2016
Offline
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?
thanks
See Answer
July 16, 2010
Offline
Hi Craig,
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.
Mynda
Answers Post
Most Users Ever Online: 57
Currently Online:
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Max Neumann
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
