From 66d9968bba9fe381183387089509ed928ee8a6d9 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 10 Feb 2020 20:47:55 -0300 Subject: tdf#129554 keyboard shortcuts for Pivot dialog Change-Id: I95abc0b5f2ba6447c8d034f12a9babebbc5a2db1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88419 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/04/01020000.xhp | 81 +++++++++++++++++++-------------------- 1 file changed, 39 insertions(+), 42 deletions(-) (limited to 'source/text/scalc/04') diff --git a/source/text/scalc/04/01020000.xhp b/source/text/scalc/04/01020000.xhp index b59110d9ec..a065820312 100644 --- a/source/text/scalc/04/01020000.xhp +++ b/source/text/scalc/04/01020000.xhp @@ -1,7 +1,4 @@ - - - - - - + Shortcut Keys for Spreadsheets @@ -33,8 +28,8 @@ spreadsheets; shortcut keys in shortcut keys; spreadsheets sheet ranges; filling -mw deleted "matrices;..."Shortcut Keys for Spreadsheets - +mw deleted "matrices;..."

Shortcut Keys for Spreadsheets +

To fill a selected cell range with the formula that you entered on the Input line, press Option @@ -45,7 +40,7 @@ To select multiple sheets in a spreadsheet, hold down CommandCtrl, and then click the name tabs at the lower edge of the workspace. To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet. To insert a manual line break in a cell, click in the cell, and then press CommandCtrl+Enter. To delete the contents of selected cells, press Backspace. This opens the Delete Contents dialog, where you choose which contents of the cell you want to delete. To delete the contents of selected cells without a dialog, press the Delete key. -Navigating in Spreadsheets +

Navigating in Spreadsheets

@@ -288,8 +283,8 @@
-The ` key is located next to the "1" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose Tools - Customize, click the Keyboard tab. Select the "View" category and the "Toggle Formula" function. -Function Keys Used in Spreadsheets +The ` key is located next to the "1" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose Tools - Customize, click the Keyboard tab. Select the "View" category and the "Toggle Formula" function. +

Function Keys Used in Spreadsheets

@@ -531,7 +526,7 @@
-Formatting Cells Using Shortcut Keys +

Formatting Cells Using Shortcut Keys

The following cell formats can be applied with the keyboard: @@ -602,7 +597,9 @@
-Using the pivot table +

Using the pivot table

+ The shortcut keys below are for the Pivot Table Layout dialog. + @@ -614,7 +611,7 @@ -Tab +Tab Changes the focus by moving forwards through the areas and buttons of the dialog. @@ -622,7 +619,7 @@ -Shift+Tab +Shift+Tab Changes the focus by moving backwards through the areas and buttons of the dialog. @@ -630,7 +627,7 @@ -Up Arrow +Up Arrow Moves the focus up one item in the current dialog area. @@ -638,7 +635,7 @@ -Down Arrow +Down Arrow Moves the focus down one item in the current dialog area. @@ -646,7 +643,7 @@ -Left Arrow +Left Arrow Moves the focus one item to the left in the current dialog area. @@ -654,7 +651,7 @@ -Right Arrow +Right Arrow Moves the focus one item to the right in the current dialog area. @@ -662,7 +659,7 @@ -Home +Home Selects the first item in the current dialog area. @@ -670,7 +667,7 @@ -End +End Selects the last item in the current dialog area. @@ -678,87 +675,87 @@ -OptionAlt and the underlined character in the word "Row" +OptionAlt and the underlined character in the label "Row Fields" -Copies or moves the current field into the "Row" area. +Copies or moves the current field into the "Row Fields" area. -OptionAlt and the underlined character in the word "Column" +OptionAlt and the underlined character in the label "Column Fields" -Copies or moves the current field into the "Column" area. +Copies or moves the current field into the "Column Fields" area. -OptionAlt and the underlined character in the word "Data" +OptionAlt and the underlined character in the label "Data Fields" -Copies or moves the current field into the "Data" area. +Copies or moves the current field into the "Data Fields" area. -CommandCtrl+Up Arrow +OptionAlt and the underlined character in the label "Filters" -Moves the current field up one place. +Copies or moves the current field into the "Filters" area. -CommandCtrl+Down Arrow +CommandCtrl+Up Arrow -Moves the current field down one place. +Moves the current field up one place. -CommandCtrl+Left Arrow +CommandCtrl+Down Arrow -Moves the current field one place to the left. +Moves the current field down one place. -CommandCtrl+Right Arrow +CommandCtrl+Left Arrow -Moves the current field one place to the right. +Moves the current field one place to the left. -CommandCtrl+Home +CommandCtrl+Right Arrow -Moves the current field to the first place. +Moves the current field one place to the right. -CommandCtrl+End +CommandCtrl+Home -Moves the current field to the last place. +Moves the current field to the first place. -OptionAlt+O +CommandCtrl+End -Displays the options for the current field. +Moves the current field to the last place. -Delete +Delete Removes the current field from the area. -- cgit