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

Copying to Multiple Sheets

In Office Calc, you can insert values, text or formulae that are simultaneously copied to other selected sheets of your document.

  • Select all desired sheets by holding down the Ctrl key and clicking the corresponding register tabs that are still grey at the bottom margin of the workspace. All selected register tabs are now white.

You can use Shift+Ctrl+Page Up or Page Down to select multiple sheets using the keyboard.

  • Now when you insert values, text or formulas into the active sheet, they will also appear in the identical positions in the other selected sheets. For example, data entered in cell "A1" of the active sheet is automatically entered into cell "A1" of any other selected sheet.