Laura from Wisconsin asks about changing the default Excel comment from light yellow to another color. While you can format an individual comment in Excel, the solution to this problem is in the control panel. Episode 976 shows you how.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the Mr. Excel netcast. I'm Bill Jump.
basically you start out with massive amounts of data.
So how we're going to analyze as well plus fire up a pivot table.
Lets's see if you can solve this problem.
Alright welcome back to the MrExcel netcast. I'm Bill Jelen.
Today's question. Laura in Wisconsin asked about comments.
Now you know that we can insert a cell comment here and it comes up in a light yellow color by default but if you click on the diagonal line surrounding the comment, you can actually select the comment.
Now Ctrl 1 to format that, and you can go in and change the color to another color.
you know, but Laura said, look I hate changing the colors of the comments all the time.
I'd like all comments to globally be created with some other colors.
Is there a way to do that?
Well unfortunately, there's not a way to do that in excel, but if you go to your control panel and then in XP its display and in Vista its appearance. I'll come back to "Appearance" and click "Advanced".
There's an item here called tooltip and tooltip is the format for, well tooltips, but also the format for comments.
So you can change color 1 to some other color.
We'll go with maybe See what's back here, Bright green.
Click "OK" we can change the font color "Blue" size "10" and leave the font as "Tahoma" Click "OK" and it'll take a second to apply those settings.
It should not go back and change the comments that have already existed.
What it's going to do though is impact the future comments.
So if we come here to new comment, see that we now have that color, that font size and that font color.
Now the downside to this is that you have now, also changed the tooltips.
Not here in excel 2007 but lots of tooltips that appear everywhere.
I actually changed this a couple of days ago on my main computer and all sorts of places, I'm noticing little tooltips popping up like when you start to type a date in word and it proposes to type the rest of the day for you.
Well that comes up in the other comment.
So you have to decide if it's worth it to you or not?
Well hey I want to thank you for stopping by. We'll see you next time for another netcast from MrExcel.
basically you start out with massive amounts of data.
So how we're going to analyze as well plus fire up a pivot table.
Lets's see if you can solve this problem.
Alright welcome back to the MrExcel netcast. I'm Bill Jelen.
Today's question. Laura in Wisconsin asked about comments.
Now you know that we can insert a cell comment here and it comes up in a light yellow color by default but if you click on the diagonal line surrounding the comment, you can actually select the comment.
Now Ctrl 1 to format that, and you can go in and change the color to another color.
you know, but Laura said, look I hate changing the colors of the comments all the time.
I'd like all comments to globally be created with some other colors.
Is there a way to do that?
Well unfortunately, there's not a way to do that in excel, but if you go to your control panel and then in XP its display and in Vista its appearance. I'll come back to "Appearance" and click "Advanced".
There's an item here called tooltip and tooltip is the format for, well tooltips, but also the format for comments.
So you can change color 1 to some other color.
We'll go with maybe See what's back here, Bright green.
Click "OK" we can change the font color "Blue" size "10" and leave the font as "Tahoma" Click "OK" and it'll take a second to apply those settings.
It should not go back and change the comments that have already existed.
What it's going to do though is impact the future comments.
So if we come here to new comment, see that we now have that color, that font size and that font color.
Now the downside to this is that you have now, also changed the tooltips.
Not here in excel 2007 but lots of tooltips that appear everywhere.
I actually changed this a couple of days ago on my main computer and all sorts of places, I'm noticing little tooltips popping up like when you start to type a date in word and it proposes to type the rest of the day for you.
Well that comes up in the other comment.
So you have to decide if it's worth it to you or not?
Well hey I want to thank you for stopping by. We'll see you next time for another netcast from MrExcel.
