Excel because that historicsweetsballroom.com 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More...Less

You can add shading to cells by filling them v solid color or certain patterns. If you have trouble print the cabinet shading the you used in color, verify the print alternatives are set correctly.

You are watching: A feature that outlines cells in color

Fill cells through solid colors

On the Home tab, in the Font group, do among the following:

To fill cells with a hard color, click the arrow next to Fill Color , and also then under Theme Colors or Standard Colors, click the color that friend want.

To to fill cells through a custom color, click the arrowhead next come Fill Color , click More Colors, and then in the Colors dialog box select the shade that friend want.

To apply the many recently selected color, click Fill Color .

Note: historicsweetsballroom.com Excel saves your 10 many recently selected custom colors. To quickly use one of this colors, click the arrowhead next come Fill Color , and then click the color that you desire under Recent Colors.


Tip: If you desire to usage a different background shade for the whole worksheet, click the Select all button prior to you click the shade that you desire to use. This will certainly hide the gridlines, yet you can improve worksheet readability through displaying cell borders about all cells.

Fill cells with patterns

On the Home tab, in the Font group, click the Format Cells dialog box launcher.


keyboard shortcut you can additionally press CTRL+SHIFT+F.

In the Format Cells dialog box, on the Fill tab, under Background Color, click the background color that you want to use.

Do one of the following:

To use a pattern through two colors, click an additional color in the Pattern Color box, and then click a pattern style in the Pattern Style box.

To usage a pattern with special effects, click Fill Effects, and then click the options that you desire on the Gradient tab.

Verify print choices to publish cell shading in color

If print alternatives are set to Black and also white or Draft quality — one of two people on purpose, or since the workbook contains large or facility worksheets and also charts that brought about draft mode to it is in turned top top automatically — cell shading cannot print in color.

On the Page Layout tab, in the Page Setup group, click the Page Setup dialog crate launcher.


On the Sheet tab, under Print, make certain that the Black and also white and Draft quality inspect boxes room cleared.

Note: If you carry out not view colors in the worksheet, it might be the you space working in high contrast mode. If you carry out not see colors once you preview before you print, it may be that you do not have actually a shade printer selected.

Remove cabinet shading

On the Home tab, in the Font group, click the arrowhead next to Fill Color, and also then click No Fill.

Set a default fill shade for every cells in a worksheet

In Excel, girlfriend cannot change the default fill color for a worksheet. By default, every cells in a workbook contain no fill. However, if you frequently create workbooks that contain worksheets v cells that all have a details fill color, you can create an Excel template. For example, if you frequently create workbooks wherein all the cells are green, friend can produce a theme to leveling this task. To perform this, follow these steps:

Create a new, blank worksheet.

Click the Select All button, to choose the totality worksheet.

On the Home tab, in the Font group, click the arrowhead next to Fill Color , and also then choose the shade that you want.

Tip once you adjust the to fill colors the the cells on a worksheet, the gridlines can become daunting to see. To do the gridlines stand out on the screen, you deserve to experiment through border and line styles. These settings are situated on the Home tab, in the Font group. To use borders to your worksheet, select the whole worksheet, click the arrowhead next to Borders

, and then click All Borders.

On the File tab, click Save As.

In the File name box, kind the name that you desire to usage for the template.

In the Save as type box, click Excel Template, click Save, and then near the worksheet.

The design template is instantly placed in the Templates folder to make certain that it will be obtainable when you want to use it to produce a new workbook.

To open a new workbook based on the template, execute the following:

On the File tab, click New.

Under Available Templates, click My templates.

See more: Did Taylor Swift Get Butt Implants, Top Docs Claim, Taylor Swift Plastic Surgery Mystery Solved!

In the New dialog box, under Personal Templates, click the design template that you simply created.