Format Menu /text/scalc/00/00000405.xhp Sun Microsystems, Inc.

Format Menu

Choose Format - Sparklines.

In a cell with sparklines, choose Sparklines.

On the Data menu of the Data tab, choose Sparklines.

Choose Format - Spreadsheet Themes.

Choose Layout - Spreadsheet Themes.

Icon Themes Choose Themes

Choose Format - Number Format.

Choose Home.

Access the Number Format deck of the Properties Panel.

Choose Format - Cells.

Choose Format Cells.

Press CommandCtrl+1.

Choose Format - Cells - Cell Protection tab.

Choose Format - Rows.

Choose Format - Rows - Optimal Height.

Choose Format - Rows - Hide. Choose Format - Columns - Hide.

Click on the rows headers to select, choose Hide Rows. Click on the columns headers to select, choose Hide Columns.

Choose Home - Rows - Hide Rows. Choose Home - Columns - Hide Columns. Choose Layout - Rows - Hide Rows. Choose Layout - Columns - Hide Columns.

Icon Hide Rows Hide Rows

Icon Hide Columns Hide Columns

Choose Format - Rows - Show. Choose Format - Columns - Show.

Click on the rows headers to select, choose Show Rows. Click on the columns headers to select, choose Show Columns.

Choose Home - Rows - Show Rows. Choose Home - Columns - Show Columns. Choose Layout - Rows - Show Rows. Choose Layout - Columns - Show Columns.

Icon Show Rows Show Rows

Icon Show Columns Show Columns

Choose Format - Columns.

Choose Format - Columns - Optimal Width. Double-click right column separator in column headers.

Choose Sheet. Choose Format - Page Style. Choose Format - Page Style - Sheet tab.

Choose Format - Print Ranges.

Choose Layout tab. On the Layout menu of the Layout tab, choose Print Ranges.

Icon Print Ranges Print Ranges

Choose Format - Print Ranges - Define.

Choose Layout - Print Area tab. On the Layout menu of the Layout tab, choose Print Ranges - Define

Icon Define Print Area Define Print Area

Choose Format - Print Ranges - Add.

Choose Layout - Add Print Ranges tab. On the Layout menu of the Layout tab, choose Print Ranges - Add.

Icon Add Print Area Add Print Area

Choose Format - Print Ranges - Clear.

Choose Layout - Clear Print Ranges tab. On the Layout menu of the Layout tab, choose Print Ranges - Clear.

Icon Clear Print Ranges Clear Print Ranges

Choose Format - Print Ranges - Edit.

Choose Layout - Edit tab. On the Layout menu of the Layout tab, choose Print Ranges - Edit.

Icon Edit Print Ranges Edit Print Ranges

Choose Format - Conditional - Condition.

Choose Home - Conditional - Condition.

Icon Conditional Format - Condition Conditional Format

Choose Format - Conditional - Color Scale

Choose Home - Conditional - Color Scale.

Icon Color Scale Color Scale

Choose Format - Conditional - Data Bar

Choose Home - Conditional - Data Bar.

Icon Data Bar Data Bar

Choose Format - Conditional - Icon Set

Choose Home - Conditional - Icon Set.

Icon Icon Set Icon Set

Choose Format - Conditional - Date

Choose Home - Conditional - Date.

Icon Date Date

Choose Format - Conditional - Manage

Choose Home - Conditional - Manage.