IBM Lotus Symphony
|
You can use shortcut keys to perform common tasks in spreadsheets. You can also use the general shortcut keys for Lotus® Symphony™. However, some keyboard shortcut conflicts with a default Exposé key assignment in Mac OS X version 10.6.3 or later. To use the shortcut in Symphony, you must first turn off the Exposé keyboard shortcut for this key.
Action | Shortcut |
---|---|
Moves the cursor to the first cell in the sheet (A1). | Ctrl+Home |
Moves the cursor to the last cell on the sheet that contains data. | Ctrl+End |
Moves the cursor to the first cell of the current row. | Home |
Moves the cursor to the last cell of the current row that contains data. | End |
Moves the cursor to the left edge of the current data range. If the column to the left of the cell that contains the cursor is empty, the cursor moves to the next column to the left that contains data. | Ctrl+Left Arrow |
Moves the cursor to the right edge of the current data range. If the column to the right of the cell that contains the cursor is empty, the cursor moves to the next column to the right that contains data. | Ctrl+Right Arrow |
Moves the cursor to the top edge of the current data range. If the row above the cell that contains the cursor is empty, the cursor moves up to the next row that contains data. | Ctrl+Up Arrow |
Moves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty, the cursor moves down to the next row that contains data. | Ctrl+Down Arrow |
Selects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected.hh | Ctrl+Shift+Up/Down/Left/Right Arrow |
Moves one sheet to the left. In Page Preview, moves to the previous print page. | Ctrl+Page Up |
Moves one sheet to the right. In Page Preview, moves to the next print page. | Ctrl+Page Down |
Moves one page to the left. | Alt+Page Up |
Moves one page to the right. | Alt+Page Down |
Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty rows and columns. | Ctrl+* - where * is on the numeric keypad only. Many laptop computers may not include a numeric keypad |
Selects the matrix formula range that contains the cursor. | Ctrl+/ - where / is on the numeric keypad only. Many laptop computers may not include a numeric keypad |
Moves the cursor down one cell in a selected range. | Enter (within a selected range) |
Type a new text line (in cell editing mode). | Alt+Enter |
Action | Shortcut |
---|---|
Opens Help. | F1 |
Displays the comment that is attached to the current cell. | Ctrl+F1 |
Turns Formula bar on or off. If drawing object is selected, enters input mode. | F2 |
Opens the Functions input dialog. | Ctrl+F2 |
Moves the cursor to the Input line where you can enter a formula for the current cell. | Ctrl+Shift+F2 |
Opens the Define Name window. | Ctrl+F3 |
Rearranges relative or absolute references in the input field. | Shift+F4 |
Closes application. | Ctrl+F4 |
Displays or hides the navigator. | F5 |
Opens the Navigator. | Ctrl+Shift+F5 |
Traces dependents. | Shift+F5 |
Traces precedents. | Shift+F7 |
Moves the focus among different sub-windows. | Shift+F6 |
Opens the Hyperlink dialog. | Ctrl+K |
Applies default formatting to the selected content. | Ctrl+T |
Selects entire column. | Ctrl+Shift+C |
Adds to the docking window. | Ctrl+Shift+E |
Hides the docking window when focus is on that window. | Ctrl+Shift+H |
Highlights cells containing values. | Ctrl+Shift+X |
Checks spelling in the current sheet. | F7 |
Turns additional selection mode on or off. In this mode, you can use the arrow keys to extend the selection. You can also click in another cell to extend the selection. | F8 |
Show window tabs list. | Ctrl+F8 |
Recalculates all formulas in the sheet. | F9 (Mac special use) |
Opens the Style List. | F11 (Mac special use) |
Updates selected chart. | Ctrl+F9 |
Ungroups the selected data range. | Ctrl+F12 |
Move to main menu. | Ctrl+F10 |
Increases the height of the current row. | Alt+Down Arrow |
Decreases the height of the current row. | Alt+Up Arrow |
Increases the width of the current column. | Alt+Right Arrow |
Decreases the width of the current column. | Alt+Left Arrow |
Optimizes the column width or row height based on the current cell. | Alt+Shift+Up/Down/Left/Right Arrow |
Recalculates the cell. | Ctrl+Shift+F9 |
Description | Shortcut |
---|---|
Two decimal places, thousands separator | Ctrl+Shift+1 (not the numeric keypad) |
Standard exponential format | Ctrl+Shift+2 (not the numeric keypad) |
Standard date format | Ctrl+Shift+3 (not the numeric keypad) |
Standard currency format | Ctrl+Shift+4 (not the numeric keypad) |
Standard percentage format (two decimal places) | Ctrl+Shift+5 (not the numeric keypad) |
Standard format | Ctrl+Shift+6 (not the numeric keypad) |
Switch
bidirectional text layout to right-to-left, right-aligned Note: Bidirectional
text, for example Hebrew or Arabic language text, is normally read
from right-to left.
|
Ctrl+Shift (Right) Note: You must first enable complex text language
(CTL) in Lotus Symphony Preferences. Select , and make sure that Complex text layout
(CTL) support is enabled.
|
Switch
bidirectional text layout to left-to-right, left-aligned Note: Bidirectional
text, for example Hebrew or Arabic language text, is normally read
from right-to left.
|
Ctrl+Shift (Left) Note: You must first enable complex text language
(CTL) in Lotus Symphony Preferences. Select , and make sure that Complex text layout
(CTL) support is enabled.
|
Description | Shortcut |
---|---|
Changes the focus by moving forward through the areas and buttons of the window. | Tab |
Changes the focus by moving backward through the areas and buttons of the window. | Shift+Tab |
Moves the focus up one item in the current window. | Up Arrow |
Moves the focus down one item in the current window. | Down Arrow |
Selects the first item in the current window. | Home |
Selects the last item in the current window. | End |
Multiple selection. | Ctrl+Click |
Opens the Layout menu. | Alt+L |
Removes the current field from the area. | Delete |
Launch filter window when focus on the field in the DataPilot table. | Ctrl+D |
Select the current item only In the filter window. | Ctrl+I |
Clear the current item only In the filter window. | Ctrl+Shift+I |
Switch between the DataPilot table and the DataPilot panel. | F6 |
Launch field menu when focus on one field on the DataPilot panel. | Enter |
Description | Shortcut |
---|---|
Gives focus to the vertical or horizontal outline window. | F6 or Shift+F6 |
Cycles through all visible buttons from top to bottom, or left to right. | Tab |
Cycles through all visible buttons in the opposite direction. | Shift+Tab |
Shows all levels up to the specified number, hiding all higher levels. | Ctrl+1 to Ctrl+8 |
Shows or hides the focused outline group. | + or - |
Activates the focused button. | Enter |
Cycles through all buttons in the current level. | Up/Down/Left/Right Arrow |
For text boxes that have a button to minimize the window, press F2 to enter the cell selection mode. Select any number of cells, then press F2 again to display the window. In cell selection mode, you can use the common navigation keys to select cells.