Dark Side | search
Click here to view Dark Side news from 60+ newspapers.
Bookmark or Share- Apply or remove cell shading - Microsoft SupportYou can add shading to cells by filling them with solid colors or specific patterns. If you have trouble printing the cell shading that you applied in color, verify that print options are set correctly. Select the cells that you want to apply shading to or remove shading from.
- Add or change the background color of cells - Microsoft SupportYou can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how: Select the cells you want to highlight. To use a different background color for the whole worksheet, click the Select All button.
- Design the layout and format of a PivotTable - Microsoft SupportTo change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting. Need more help?
- Use conditional formatting to highlight information in ExcelConditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
- Change the style of your PivotTable - Microsoft SupportApply a style to format your PivotTable, turn on banded rows to make a lot of data easier to scan, or highlight important information.
More
