IBM Lotus Symphony


Editing bar in spreadsheets

The Editing toolbar is located at the top edge of the workspace. Use the icons on this toolbar to access the most common tasks.

Table 1. Icons for editing spreadsheets
Function Name Icon Description
Undo Undo icon

Reverse the last action or the last entry typed.

Redo Redo icon

Reverse the action of the last Undo command.

Cut Cut icon

Removes and copies the selection to the clipboard.

Copy Copy icon

Copy the selection to the clipboard.

Paste Paste icon

Inserts the contents of the clipboard at the location of the cursor, and replaces any selected text or objects. Long-click to select the format.

Duplicate Formatting Format Paintbrush icon

Applies same formatting on other texts or objects as the one selected.

Create Sheet Create Table icon

Defines the options to be used to insert a new sheet.

Create Chart Create Chart icon

Inserts a chart into the document.

Create Graphic Create Graphic icon

Inserts a graphic into the document.

Create Rows Create Rows icon Inserts rows into the current spreadsheet. The number of rows inserted depends on how many rows are selected. The content of the original rows is moved downward.
Create Columns Create Columns icon Inserts columns into the current spreadsheet. The number of the columns to be inserted is determined by the number of columns that are selected. The content of the original columns is shifted to the right.
Shift Cells Down Shift Cells Down icon Moves the contents of the selected range downward.
Shift Cells Right Shift Cells Right icon Moves the contents of the selected range to the right.
Merge Cells Merge Cells icon Combines the selected cells into a single cell or splits merged cells.
Split Cells Split Cells icon Separates the merged area of cells back into the original cell components.
Sort Ascending Sort Ascending icon

Sorts the text fields alphabetically, and numeric fields in ascending order.

A field is always selected as soon as you place the cursor in the field. Data of the currently selected field are always sorted.

To sort more than one data field, select Data > Sort, then click the Sort Criteria tab, where you can combine several sort criteria.

Sort Descending Sort Descending icon

Sorts the text fields alphabetically, and numeric fields in descending order.

A field is always selected as soon as you place the cursor in the field. Data of the currently selected field are always sorted.

To sort more than one data field, select Data > Sort, then click the Sort Criteria tab, where you can combine several sort criteria.

Instant Filter Instant Filter icon Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.
Zoom Zoom icon

Reduces or enlarges the screen display of the current document. The current zoom factor is displayed in the status bar.

Spell Check
Spell Check icon

Checks the current document, or selection for spelling errors.


Product Feedback | Additional Documentation | Trademarks