Specify rules to accommodate multiple conditions: Add up to three rules to change the formatting of a cell based on specific conditions you define. You can also drag tokens within the field to rearrange them.Ĭustomize a token element: Click the arrow on a token to show formatting options, such as the type of currency symbol or the number of digits to display. zip codes into a custom format, you can use an integer token with five digits. Use tokens to represent the type of information you will enter in a cell: Drag tokens to the custom format field. Type text in the field: The text you type appears in the cell. Type a name for your format, then click the Type pop-up menu and choose Number.ĭo any of the following to specify the format: In the Format sidebar, click the Cell tab.Ĭlick the Data Format pop-up menu, then choose Create Custom Format. Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.

Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Functions that accept conditions and wildcards as arguments.String operator and wildcards in formulas.Quickly calculate a sum, average, and more.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.Add checkboxes and other controls to cells.Intro to images, charts, and other objects.

Clear formating excel for a mac