Apply shading to alternate rows or columns in a worksheet
There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data. Technique 1: Apply shading to alternate rows or …
Apply or remove cell shading - Microsoft Support
You 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. Fill cells with solid colors. Select the cells that you want to …
Add or change the background color of cells - Microsoft Support
When you want something more than a just a solid color fill, try applying a pattern or fill effects. Select the cell or range of cells you want to format. Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want.
Change the color, style, or weight of a line - Microsoft Support
Change the color, style, or weight of a line. You can change the look of a line shape by changing its color, line style, or weight. If you are using Excel, Outlook, Word, or PowerPoint, you can apply a predefined Quick Style to quickly change the look of your line.
Change the shape fill, outline, or effects of chart elements
You can fill a selected shape (such as data markers, titles, data labels, or a legend) with a solid color, gradient, picture, or texture. You cannot use shape fill to format lines in a chart (such as gridlines, axes, trendlines, or error bars).
Ways to format a worksheet - Microsoft Support
Formatting data manually. Using borders and colors to emphasize data. Changing the alignment or orientation of data. Copying an existing format to other data. In Excel, there are many ways to formatt a worksheet, such as applying themes, styles, borders and colors, to name a few.
Create a Venn diagram - Microsoft Support
You can create a SmartArt graphic that uses a Venn diagram layout in Excel, Outlook, PowerPoint, and Word. Venn diagrams are ideal for illustrating the similarities and differences between several different groups or concepts. Overview of Venn diagrams. A Venn diagram uses overlapping circles to illustrate the similarities, differences, and ...
Use conditional formatting to highlight information in Excel
How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.
Change the colors in a text box or shape - Microsoft Support
Change the colors in a text box or shape. Applies To. In a text box or shape, you can quickly change the color of text, the inside (fill) color, or the color of the border. Let's select the shape—the Drawing Tools appear in the ribbon, with the Format tab active.
Change the format of a cell - Microsoft Support
Format text in cells. Format numbers. Format a date the way you want. Format cells by including predefined formatting styles, and things like borders and fill colors.
Apply or remove cell borders on a worksheet - Microsoft Support
Here's how: Select the cell or range of cells that you want to add a border around, change the border style on, or remove a border from. The Borders button shows the most recently used border style. To apply that style, click the Borders button (not the arrow).