Lotus: Lotus Symphony Help

THEMES: Lotus\Symphony
YEAR: 2015
Login Login
User: Anonymous


 
 

Comments/attachments: Close
 

http://infolib.lotus.com/resources/symphony/3.0.0/sym20abd014/en_us/HTML-accessible/spreadsheets/html-wrapper-spreadshets.html#keyboard

Keyboard Navigation
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.
Navigation keys for Lotus Symphony Spreadsheets

ActionShortcut
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.hhCtrl+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

Function keys for Lotus Symphony Spreadsheets
ActionShortcut
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)

F8 !! (LN)

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

Formatting cells using shortcut keys
DescriptionShortcut
Two decimal places, thousands separatorCtrl+Shift+1 (not the numeric keypad)
Standard exponential formatCtrl+Shift+2 (not the numeric keypad)
Standard date formatCtrl+Shift+3 (not the numeric keypad)
Standard currency formatCtrl+Shift+4 (not the numeric keypad)
Standard percentage format (two decimal places)Ctrl+Shift+5 (not the numeric keypad)
Standard formatCtrl+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 File > Preferences > Symphony > Language Settings > Languages, 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 File > Preferences > Symphony > Language Settings > Languages, and make sure that Complex text layout (CTL) support is enabled.

Using shortcut keys with the DataPilot
DescriptionShortcut
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
Using keyboard navigation in the Outline window
DescriptionShortcut
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