Friday, September 27, 2013

How to Change Default Colors in Excel


Adjust the Color in a Worksheet
1. Change the font color. Click on one cell to select it or click on the first cell in a group and drag the mouse to highlight all the cells. You can also click on the gray box at the top left corner of the worksheet to select all the cells on the page.
2. Click on the 'Font Color' button on the tool bar. Click to select one of the standard colors displayed on the palette. The font color button has an 'A' on it, with a bar of the current font color underneath the A.
3. Change the background color of a cell. Highlight the cell or cells you would like to adjust and then click on the arrow on the right side of the 'Fill Color' button on the toolbar. Click on a color to apply it to the cell.
4. Change the color in a chart. Open the chart you want to format and double-click on the element you want to change. You can change the color of the background, labels and font of the chart.
Adjust a Color in the Color Palette
5. Open the workbook containing the color palette you want to change. You can also make the changes for a new workbook.
6. Open the 'Options' dialog box. Select 'Tools' from the tool bar and click on 'Options.' This dialog box contains various selections that you can use to change the default attributes of a workbook.
7. Click on the 'Color' tab. Select the color you want to change and click on 'Modify.' A 'Colors' pop up box should appear.
8. Replace the current color. To switch the color you have selected with another, select a different color from the standard tab of the colors dialog box.
9. Customize a color. Click on the 'Customize' tab of the 'Colors' box to adjust the intensity of the color you have selected.

Blogger news