Format worksheet cells to make text or fill color stand out. Create a color spectrum across a range of cells. Show color palettes near cells
Open the Format Cells with the keyboard or mouse, to change any of the formatting options for the selected cells
The Format Cells dialog box opens, and you can click any of the tabs, to change the formatting options for the selected cells.
To show an electromagnetic spectrum in a range of 6 cells, you can use a 2-color gradient fill in each cell.
Thanks to Robert Lepper, for sharing this tip. He used this technique to help with a homework assignment.
To show a color spectrum, like the one above, each cell is filled with a 2-color gradient. Each adjacent cell starts with the finishing color of the cell to the left.
While working on a worksheet, you might want to change a cell's fill color or font colour, or add borders. To do that, you can use the fill, font, and border commands on the toolbar.
If you have lots of formatting to do, it will be easier if the palettes are closer to the area where you're working.
In Excel 2007 and later, right-click on the cell that you want to format, to see the popup menu. A mini toolbar also appears, with several formatting options, including fill, font and borders.
If the mini toolbar does not appear, go into Excel Options, in the General category, and add a check mark to "Show Mini Toolbar on selection".
In Excel 2003 and earlier, you can detach the formatting palettes from the toolbar, and move them onto the worksheet. This video shows the steps, and the written instructions are below the video.
To move one of the “tear away” palettes (Font Color, Fill Color, Borders):
When you've finished working with the palette, click the X at its top right, to close it.
Download the sample formatting workbook. The zipped file is in xlsx format, and does not contain macros.
For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
Search Contextures Sites
Last updated: December 28, 2016 2:13 PM
Contextures RSS Feed