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 …
Headers and footers in a worksheet - Microsoft Support
You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own, or use many built-in headers and footers.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
Format Objects or Text with Glow or Soft Edges - Microsoft …
In Microsoft Word, Excel, and PowerPoint, you can apply glow and soft edge effects to shapes, text, and other objects. To view the glow and soft edges options: Select the object that you want to format. Under Drawing Tools, on the Format tab, click Shape Effects or Text Effects. Click Glow > Glow Options. The following options appear.
Keyboard shortcuts in Excel - Microsoft Support
Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below. You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options.
Use Goal Seek to find the result you want by adjusting an input …
On the Home tab, in the Number group, click Percentage. Click Increase Decimal or Decrease Decimal to set the number of decimal places. If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.
Choosing colors in the Colors dialog box - Microsoft Support
The Colors dialog box lets you fine-tune your choice of colors. If you don't like any of the choices on the Standard tab, switch to the Custom tab and refine your choice.
Use conditional formatting to highlight information in Excel
To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values. You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report. Windows Web.
Format Objects or Text with Glow or Soft Edges - Microsoft Support
Select the object that you want to format. Under Drawing Tools, on the Format tab, click Shape Effects or Text Effects. Click Glow > Glow Options. The following options appear. Glow. Presets — To apply one of the most common Glow Variations, click …
Change the colors in a text box or shape - Microsoft Support
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.
Format elements of a chart - Microsoft Support
You can change the format of individual chart elements, such as the chart area, plot area, data series, axes, titles, data labels, or legend. Two sets of tools are available for formatting chart elements: the Format task pane and the Chart Tools Ribbon.