\<bookmark_value\>sheets; transferring values\</bookmark_value\>\<bookmark_value\>multiple sheets\</bookmark_value\>\<bookmark_value\>copying;values, to multiple sheets\</bookmark_value\>\<bookmark_value\>pasting;values in multiple sheets\</bookmark_value\>\<bookmark_value\>values;inserting in multiple sheets\</bookmark_value\>\<bookmark_value\>selecting;multiple sheets\</bookmark_value\>

Copying to Multiple Sheets

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

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

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

• Now when you insert values, text or formulas into the sheets, they will also appear in the identical positions in the other selected sheets.