How to Change the Cell Shading Color in Excel 2010

Cell shading, or fill color, is an effective way to highlight data in a spreadsheet, or to indicate that certain cells are associated with one another. But if a cell already has an existing fill color, then you may be looking for a way to change it. Fortunately cell fill colors can be changed in a manner very similar to how they were set in the first place. You can even choose to remove the fill color of a cell if you wish.

Out guide below will show you how to select the cells with the shading that you wish to remove, then direct you in the steps that you need to perform in order to have those cells be filled with a different color.

 

Changing a Fill Color in Excel 2010

The steps in this tutorial were written using Microsoft Excel 2010. These steps may vary slightly in different versions of Excel.

 

  1. Open your spreadsheet in Microsoft Excel 2010.
  2.  

  3. Select the cells for which you wish to change the fill color. Note that you can select an entire row by clicking the row number at the left side of the row, the column by clicking the letter at the top of the column, or the entire sheet by clicking the gray cell above the first row number, and to the left of the first column letter.
  4. select the cells

     

     

  5. Click the Home tab at the top of the window.
  6. click the Home tab

     

     

  7. Click the down arrow to the right of the Fill Color button.
  8. click the down arrow next to the fill color button

     

     

  9. Click the color that you wish to use instead. If you wish to remove the fill color, select the No Fill option.

select the new fill color

 

 

Are you printing your Excel worksheet, and you want to make it easier to read? One helpful change to make is to repeat your row of column identifiers at the top of each page. This will make it much easier for people to associate cells with their proper columns, and can help to reduce mistakes.