There’s no reason that your spreadsheets have to be boring and drab. With a bit of cell formatting, your spreadsheet can show your style and include your favorite colors.
It’s important when you change text color in Excel that you follow a consistent scheme. Color isn’t a random choice – it’s designed to help the spreadsheet user follow your data. Let’s learn how to change text color in Excel.
How to Change Text Color in Excel
In Excel, you probably already know that most options live on the ribbon. This is the menu that lives at the top of the app with many tabs that offer countless controls. To change text color in Excel, make sure that you’re working on the Home tab and find the Font panel.
Click on a cell that includes text. Then, find the Font Color box, which is a colored square shown in the screenshot below. Click on the dropdown arrow, then choose a color to set your text to.
If you don’t see a color that you love, click on the More Colors option. You can select completely custom colors with the help of a color wheel or hex code.
Remember that contrast is always important when you choose a text color. For example, don’t put a light grey text cell on a white box. That makes it easy to miss out on the cell content. Conversely, light-colored text on a dark background is a must to keep your spreadsheet readable.
How to Change Text Color of Multiple Cells in Excel
As you’re working to reformat and style your spreadsheet, there are many cells you might need to adjust. It takes too much time to change cell after cell with new color options. Luckily, it’s easy to change the text color of multiple cells in Excel with only a few clicks.
Start by highlighting the cells that include text that you wish to change. Then, repeat the same steps to select a new color. All selected text will change color to your new selection.
Remember: don’t overwhelm the viewer. Pick a few key colors and stick to them so that your spreadsheet is appealing but easy-to-follow.
Box and Whisker Plot in Excel