When you type “5555103” in a cell, it’s displayed as “(952) 555-5103.” When you type “0” in a cell, the cell shows “No number on file.
In the example below, all positive numbers you enter are displayed as a phone number with the area code (952). 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.While you can use it on Mac, you’ll be much more limited. Excel is a Microsoft application and is therefore optimized for windows operating systems. Place objects inside a text box or shape This article outlines 32 shortcuts you should start with today to use Excel without the mouse and increase your efficiency.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.
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.