/text/scalc/guide/multitables.xhp Sun Microsystems, Inc. UFI: sc.features "Select tables with keyboard" YJ:checked FPE: Changed screenshot, modified content, pls recheck sheets; inserting inserting; sheets sheets; selecting multiple sheets; simultaneous multiple filling appending sheets Applying Multiple Sheets By default $[officename] displays three sheets "Sheet1" to "Sheet3", in each new spreadsheet. You can switch between sheets in a spreadsheet using the sheet tabs at the bottom of the screen. Sheet Tabs Inserting a Sheet Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. 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 Ctrl you can select multiple sheets. You can use Shift+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 Ctrl key. The sheet that is currently visible cannot be removed from the selection. Writing Values Simultaneously to Multiple Sheets If multiple sheets are selected, all values entered into the active sheet are automatically inserted into the other selected sheets. For example, data entered in Sheet1, cell A1 is automatically entered into the same cell in Sheet2. 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.