Application Menu

File

New: Creates a new workbook. If a workbook is already open, it will open in a new window.
New from Server...: Opens a wizard to create a new workbook from a database template.
New from Samples: Allows you to open online sample workbooks.
Open: Opens an existing workbook. If a workbook is already open, it will open in a new window.
Recent: Provides access to recently opened workbooks.
Save: Saves the current workbook, including any changes made.
Save As...: Saves the current workbook under a new name.
Close: Closes the currently opened workbook.
Print: Opens the print dialog box.
Exit: Closes the application.

Undo: Reverses the last action.
Redo: Re-applies the last undone action.
Cut: Cuts the selected rows or cells. Note that you cannot cut columns.
Copy: Copies the selected rows, columns, or cells.
Paste: Pastes clipboard content into the selected rows, columns, or cells.
Insert from Clipboard: Inserts rows from the clipboard.
Find: Opens the Find dialog box.
Find Next: Searches for the next cell matching the current search criteria.
Find Previous: Searches for the previous cell matching the current search criteria.
Replace: Opens the Find and Replace dialog box.
Select All: Selects all table cells.
Select Columns: Selects entire columns.
Select Row: Selects entire rows.
Make Row Copy: Duplicates selected rows or rows of selected cells.
Insert Rows: Inserts new rows.
Delete Rows: Deletes the selected rows.
Clear Contents: Clears the contents of the selected cells.

Sort Ascending: Sorts data in ascending order based on the selected columns.
Press Ctrl to add additional sorting rules.
Sort Descending: Sorts data in descending order based on the selected columns.
Press Ctrl to add additional sorting rules.
Restore Source Order: Restores the initial order of the loaded rows.
Filters: Allows you to modify filters for the active table.
Hide Columns: Hides the selected columns.
Unhide Columns: Unhides columns within the selected range.
To unhide columns before the first visible column, select the first visible column and click the button.
To unhide columns after the last visible column, select the last visible column and click the button.
Freeze Columns: Freezes the columns before the selected column.
Unfreeze Columns: Unfreezes any frozen columns.
Resize Columns: Resizes columns to fit their contents.
Table Views: Allows you to save, apply, manage, and reload table views.
You can also use the rightmost drop-down field on the toolbar for these operations.
Show Zeros: Toggles the display of zeros.
Show Gridlines: Toggles the display of gridlines.

Align Left: Aligns the selected columns to the left.
Center: Centers the selected columns.
Align Right: Aligns the selected columns to the right.
Percent Style: Applies or removes the percent style from the selected columns.
Comma Style: Applies or removes thousand separators from the selected columns.
Increase Decimals: Increases the number of decimal places in the selected columns.
Decrease Decimals: Decreases the number of decimal places in the selected columns.

Save Changes: Saves data changes to the database.
Refresh: Reloads data from the database.
Refresh All: Reloads data on all worksheets from the database.
Refresh Selected...: Opens a dialog box to select objects for reloading data from the database.
Query Options...: Opens the Query Options dialog box to configure the active table.
Workbook Connection...: Opens the connection wizard to configure the workbook connection.
This wizard changes the connection but does not refresh data.
Show Command Text: Displays the command text of the active table in a new window.
Show Connection String: Displays the connection string of the active workbook in a new window.
Insert Worksheet: Opens the connection wizard to add a new worksheet for the connected object.
Delete Worksheet: Deletes the selected worksheet.
Hide Worksheet: Hides the selected worksheet.
Unhide Worksheet: Opens a dialog box to unhide worksheets.

Options: Opens the Options dialog box.
Interface Language: Allows you to select a UI language.
Default Data Language: Allows you to select the default data language.
Workbook Data Language: Allows you to select the data language for the active workbook.
Connection String Cache: Opens the DBEdit configuration file containing cached connection strings.
Show Row Editor: Opens the row editor window.
Show Cell Editor: Opens the cell editor window.
Show List Editor: Opens the list editor window.
Show Table Description: Opens the table description window.

DBEdit shows this menu if the active query has configured Actions menu items (see Developer Guide).

For example, this menu may display items added by the SaveToDB Developer Framework used to generate database objects: