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.
Video: Format shapes - Microsoft Support
Select the shapes you want to format. Tip: To select more than one, press and hold the Shift key. Select Shape Fill to fill the selected shapes with a solid color, gradient, texture, or picture. Select Shape Outline to pick the color, width, or line style for your shape's border.
Show or hide gridlines on a worksheet - Microsoft Support
Gridlines are used to distinguish cells on a worksheet. When working with gridlines, consider the following: By default, gridlines are displayed on worksheets using a color that is assigned by Excel. If you want, you can change the color of the gridlines for a particular worksheet.
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.
Add or remove a sheet background - Microsoft Support
To improve readability, you can hide cell gridlines and apply solid color shading to cells that contain data. A sheet background is saved with the worksheet data when you save the workbook. To use a solid color as a sheet background, you can apply cell shading to …
Use Excel with earlier versions of Excel - Microsoft Support
To avoid the loss of data or functionality in an earlier version of Excel, you can then make the necessary changes to your current workbook. When you save a workbook to an Excel 97-2003 file format, the Compatibility Checker runs automatically.
Use the Format Painter - Microsoft Support
On the Home tab, select Format Painter in the Clipboard group. The cursor changes to a paintbrush icon. Use the brush to paint over a selection of text or graphics to apply the formatting. This only works once. To change the format of multiple selections in your document, you must first double-click Format Painter.
Use conditional formatting to highlight information in Excel
How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.