Sunday, July 28, 2013

How to Change Row Colors in Pivot Table


1. Open Microsoft Excel 2003, then open the workbook containing the pivot table you want to change the row colors.
2. Click the tab in the Excel workbook for the sheet that contains the pivot table. If workbook tabs are hidden, click the 'Tools' link in the menu bar, then click the 'Options' link in the drop-down menu to open the 'Options' dialog box. Click the 'View' tab in the dialog box, check the box next to 'Sheet tabs,' then click the 'OK' button.
3. Select one of the rows in the pivot table you want to change the color. Click the first cell in the row, then drag the pointer to the final cell. Do not select the row by clicking on the row number as this will result in the row color you apply extending beyond the limits of the pivot table.
4. Right click over the row you have selected and click the 'Format Cells' link in the context menu.
5. Click the 'Patterns' tab, then click the color you want from the set of colors displayed in the 'Cell Shading' section.
6. Click the 'OK' button to close the 'Format Cells' window and apply the color you chose to the row you selected. Repeat the process to apply color to other rows in the pivot table.

Blogger news