How to Use a Gradient Fill Effect in Excel 2013

Using fill colors in Microsoft Excel 2013 is a great way to identify similar data and give people that are reading your data an additional, visual way to understand and interpret that data. But did you receive a spreadsheet from someone else that had multiple colors for a fill color, and you want to know how to do that yourself?

You can use a multi-color fill in Excel 2013 by taking advantage of a gradient fill effect that is found on the Font Settings menu. Our guide below will show you where to find and how to use this fill option so that you can start applying gradient fills to your cells as needed.


How to Do a Gradient Fill in Excel 2013

The steps in this guide are going to show you how to fill a cell or selection of cells in Excel 2013 with a gradient. You will be able to select from a few options of gradients that are available in Excel 2013.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the cell(s) to which you would like to apply the gradient fill.

excel 2013 fill effects



Step 3: Click the Home tab at the top of the window, then click the small Font Settings button at the bottom-right corner of the Font section of the ribbon.

gradients in excel 2013



Step 4: Click the Fill tab at the top of the window.

custom fill colors in excel 2013



Step 5: Click the Fill Effects button.

gradient inside cell in excel 2013



Step 6: Select the colors and shading style for your gradient fill, then click the OK button at the bottom of the window.

how to use gradient fill in excel 2013



Step 7: Click the OK button to apply your gradient fill to the selected cells.

multicolor fill in excel 2013



Are you having difficulty getting your spreadsheet to print the way that you need? Read our Excel printing guide for some tips and tricks that will aid you in printing spreadsheets that fit easily on a page and are simpler to read.