Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Apply Or Remove Cell Shading. On the Home tab in the Styles group click the More dropdown arrow in the style gallery and select the cell style that you want to apply. To remove a border or shading do the following action.
For more information see Select cells ranges rows or columns on a worksheet. To remove a solid color pattern color or pattern style of selected cells open the Format Cells dialog box and clear the color or pattern selection. Set a default fill color for all cells in a worksheet.
Select the cells that you want to fill.
From the Table Design tab last tab on the ribbon right-click the style in the Table Styles gallery and then click Duplicate Enter a name for your new table style. Set a default fill color for all cells in a worksheet. To remove a solid color pattern color or pattern style of selected cells open the Format Cells dialog box and clear the color or pattern selection. Apply or remove a cell shading in Excel for Mac.