Apply or remove cell shading - Microsoft Support
网页Apply or remove cell shading. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. 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 …
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 columns by using conditional formatting.
Apply or remove cell borders on a worksheet - Microsoft Support
网页Apply or remove cell borders on a worksheet. By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border. Note: Cell borders that you apply appear on …
Change the color of gridlines in a worksheet - Microsoft Support
网页To change the color of gridlines, you can use the following procedure. Select the worksheets for which you want to change the gridline color. Click File > Excel > Options. In the Advanced category, under Display options for this worksheet, make sure that the Show gridlines check box is selected.
Change the appearance of your worksheet - Microsoft Support
网页To change the text fonts, colors, or general look of objects in all worksheets of your workbook quickly, try switching to another theme or customizing a theme to meet your needs. If you like a specific theme, you can make it the default for all new workbooks.
Add or change the background color of cells - Microsoft Support
网页If print options are set to Black and white or Draft quality — either on purpose, or because the workbook has large or complex worksheets and charts that caused draft mode to be turned on automatically — cells won't print in color. Here's how you can fix that: Click Page Layout > Page Setup dialog box launcher.
Change the color, style, or weight of a line - Microsoft Support
网页Change the color of a line. Select the line that you want to change. If you want to change multiple lines, select the first line, and then press and hold Ctrl while you select the other lines. On the Shape Format tab, select Shape Outline, then select the color that you want.
Change the colors in a text box or shape - Microsoft Support
网页On the Drawing Tools Format tab, click Text Fill > More Fill Colors. In the Colors box, either click the color you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors on the Standard tab aren't updated if you later change the document theme.
Page Setup - Microsoft Support
网页Black and white Select the Black and white check box when you use a color printer but you want to use black and white only when printing. This option is off by default. You do not have to select it when you are using a printer that prints black and white only.
Show or hide gridlines on a worksheet - Microsoft Support
网页Show or hide gridlines in Word, PowerPoint, and Excel. Print gridlines in a worksheet. Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel.
Basic tasks in Excel - Microsoft Support
网页The preview window displays the pages in black and white or in color, depending on your printer settings. If you don’t like how your pages will be printed, you can change page margins or add page breaks.