Format Menu Command Reference

The following table provides a quick reference to the commands available on the Format menu and lists any related shortcut menus. The commands listed are those available in the Query, Results, and OLAPQuery sections.

Command

Description

Keyboard Shortcut

Shortcut Menu

Font

Opens the Font page of the Properties dialog box.

 

*

Style

Select between Plain, Bold, Italics, Underline, Overline, Double Underline.

  

Number

Opens the Number page of the Properties dialog box.

 

*

Justify

Select between Left, Center, Right and Top, Middle, Bottom.

 

*

Column

By default, Results columns are evenly sized without regard to the length of data values. Numeric data that does not fit is replaced with pound signs (#).

To manually resize a column, drag the right edge of the column to a new position.

  

Auto-Size Width

Resizes the selected column to the width of the contents.

Ctrl+E

 

Standard Width

Resizes the selected column to the standard column width.

  

Row

Resizes all rows to the standard row height.

To resize all rows in a table, drag the bottom edge of a row to a new position. All rows in the table are resized.

  

Column Titles

Toggles the display of column titles.

  

Row Numbers

Toggles the display of row numbers. Row numbers are printed on reports, but cannot be copied to the clipboard or exported to a file.

  

Text Wrap

Wraps text in a column.

 

*

Suppress Duplicates

Suppresses duplicate values in a column. Use this feature to display only the first instance of a duplicate value when individual database records include redundant information.

 

*

Grid Lines

Opens the Gridlines page of the Properties dialog box.

  

Border and Background

Opens the Border and Background page of the Properties dialog box.

  

Conditional Formatting

Opens the Spotlight dialog box. Use to spotlight important values.

  

Export Properties

Opens the Export Properties dialog box. Use to set the number of rows that should be included on an HTML page before the data breaks to another page, and to export data that does not contain any quote to a tab-delimited text file.

  

Tip:

To automatically size all columns so that the column width fits its contents, press Ctrl+A Ctrl+E