Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Applying Multiple Sheets

Inserting a Sheet

  1. 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 grey 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.

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.