From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/multitables.xhp | 73 ++++++++++++++++++++++ 1 file changed, 73 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/multitables.xhp (limited to 'helpcontent2/source/text/scalc/guide/multitables.xhp') diff --git a/helpcontent2/source/text/scalc/guide/multitables.xhp b/helpcontent2/source/text/scalc/guide/multitables.xhp new file mode 100644 index 000000000..7061c99dc --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/multitables.xhp @@ -0,0 +1,73 @@ + + + + + + + + + Applying Multiple Sheets + /text/scalc/guide/multitables.xhp + + + +sheets; inserting + inserting; sheets + sheets; selecting multiple + appending sheets + selecting;multiple sheets + multiple sheets + calculating;multiple sheets +MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;" +Applying Multiple Sheets + + Inserting a Sheet + + + Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. + + + +Sheet Events +Opens a dialog box where you can assign macros to sheet events. + +Tab Color + +Opens a window where you can assign a color to the sheet tab. + + +Click to select all sheets in the document. + +Click to deselect all sheets in the document, except the current sheet. + Selecting Multiple Sheets + The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing CommandCtrl you can select multiple sheets. + You can use Shift+Command +Ctrl+Page Up or Page Down to select multiple sheets using the keyboard. + Undoing a Selection + To undo the selection of a sheet, click its sheet tab again while pressing the CommandCtrl key. The sheet that is currently visible cannot be removed from the selection. + Calculating Across Multiple Sheets + You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, =SUM(Sheet1.A1:Sheet3.A1) sums up all A1 cells on Sheet1 through Sheet3. + + +
+ + +
+ + \ No newline at end of file -- cgit v1.2.3