The Format menu gathers together all of the commands that you’re likely to use while altering the formatting of your sheets and workbooks.
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.
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.
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.
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.
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.
Opens the AutoFormat window, where you can select formatting from a range of presets for the selected cells or pivot table.
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.
52.15.78.83