A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Have you ever thought to change text color and font in Excel?
Till now, we are only aware of how to change color and font for the entire cell contents.
Yes, right? But, sometimes you would be needed to change text color and font. I mean changing the color and text to little piece of the text. Do you know how to do it or ever thought of doing so?
Do not worry. Our very own Excel expert Szilvia Juhasz lets us know how to do it simply. The trick to change text color and font is really useful, attractive and mostly very simple.
First, rather than jumping in to the trick, let us look at how to color contents in a cell.
Did you see that?
Color, font and font size got applied to all contents of the cell. This is the general and straight forward way to change color and font in Excel. This is what we know and what we are doing till now. Now, the actual trick comes in to the picture. Let us see, how we can change text color and font in Excel rather than whole contents of the cell.
The actual technique follows as,
Changing text color and font in Excel can be done in two simple steps as follows,
These are the simple steps to change text color and font in Excel. Now you could see that, only particular text of the cell contents is colored.
Amazing Trick! Thanks Szilvia Juhasz for this interesting trick.
This trick can be used when you want users to input values to the Excel. Let us take an example of an Excel which has VBA Code taking SQL Query as it’s input. Let us say that SQL Query has two attributes ‘StartDate’ and ‘EndDate’. To warn the users that, they need to provide these two values to run the VBA, you can add red color to these texts in the Query. In this way, users will be aware that they need to input these values to proceed further.
Give it a try buddies! Also, if you have any excel tips or want to add anything to this trick, please do share with us through comments.
Share this trick with your friends and colleagues. Enjoy the trick!
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide