Format Menu

The Format menu gathers together all of the commands that you’re likely to use while altering the formatting of your sheets and workbooks.

Cells

Opens the Format Cells window, where you can choose all kinds of formatting options for the selected cells. This menu item changes to reflect the type of object is selected—Picture, Object, WordArt, or AutoShape—and then opens the appropriate Format window. Keyboard shortcut: ⌘-1.

Row

This menu has four options that govern the appearance of the selected row or rows:

  • Height. Opens the Row Height window, where you can set the height of the selected row or rows in pixels. If a worksheet is protected, this option is unavailable.

  • AutoFit. Makes the selected row precisely as high as it needs to be to accommodate the tallest text in the row. Measured in pixels.

  • Hide. Hides the selected row or rows from view (it doesn’t delete them).

  • Unhide. Reveals any hidden rows.

Column

Like its sibling menu item, Format → Row, this menu has five options that let you edit the appearance of the selected column or columns:

  • Width. Opens the column width window, where you can set the width of the selected column or columns (measured in characters).

  • AutoFit Selection. Makes the selected column precisely as wide as it needs to be to accommodate the longest text in the column. Measured in characters.

  • Hide. Hides the selected column or columns from view.

  • Unhide. Reveals any hidden columns.

  • Standard Width. Resets the selected column or columns to the original setting.

Selected Chart Area

If you have a chart selected, the Select Data Series menu item appears; it lets you format the selected chart’s area. This menu item changes to reflect the various items selected in the chart, including data series, plot areas, labels, and legends. All of these open the appropriate Format window.

Sheet

This menu item has four submenus, each of which deals with a formatting aspect for the active worksheet.

  • Rename. Lets you rename the currently active sheet.

  • Hide. Hides the selected sheet or sheets.

  • Unhide. Reveals any hidden sheets in the workbook by presenting you with a list of hidden sheets and letting you choose those you want shown.

  • Background. Lets you select a graphics file to use as a background for the front-most sheet.

AutoFormat

Opens the AutoFormat window, where you can select formatting from a range of presets for the selected cells or pivot table.

Conditional Formatting

Opens the Conditional Formatting window, where you can change the selected cells’ formatting based on conditions that you define—such as changing a cell’s text color to red when its value is negative.

Style

Opens the Style window, where you can add, edit, or remove styles. Styles are a saved set of formatting commands that you can apply to a cell or range of cells with ease.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
52.15.78.83