Fill Sheets
Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets.

This menu command is only active if you have selected at least two sheets in the document.
To select multiple sheets, click each sheet tab while pressing Command Ctrl or Shift.
In contrast to copying an area to the clipboard, you can filter certain information and calculate values.
ΠΠ°ΠΏΠΎΠ»Π½Π΅Π½ΠΈΠ΅ Π»ΠΈΡΡΠ°
-
ΠΡΠ±Π΅ΡΠΈΡΠ΅ Π²Π΅ΡΡ Π»ΠΈΡΡ ΡΠ΅Π»ΠΈΠΊΠΎΠΌ, ΡΡΠ»ΠΊΠ½ΡΠ² ΠΏΡΡΡΠΎΠ΅ ΡΠ΅ΡΠΎΠ΅ ΠΏΠΎΠ»Π΅ Π² Π²Π΅ΡΡ Π½Π΅ΠΌ Π»Π΅Π²ΠΎΠΌ ΡΠ³Π»Ρ Π»ΠΈΡΡΠ°. Π’Π°ΠΊΠΆΠ΅ ΠΌΠΎΠΆΠ½ΠΎ Π²ΡΠ±ΡΠ°ΡΡ ΠΊΠΎΠΏΠΈΡΡΠ΅ΠΌΡΡ ΠΎΠ±Π»Π°ΡΡΡ Π»ΠΈΡΡΠ°.
-
ΠΠ°ΠΆΠΌΠΈΡΠ΅ ΠΊΠ»Π°Π²ΠΈΡΡ COMMANDCTRL ΠΈ ΡΡΠ»ΠΊΠ½ΠΈΡΠ΅ Π²ΠΊΠ»Π°Π΄ΠΊΡ Π»ΠΈΡΡΠ°, Π½Π° ΠΊΠΎΡΠΎΡΡΠΉ Π½Π΅ΠΎΠ±Ρ ΠΎΠ΄ΠΈΠΌΠΎ Π²ΡΡΠ°Π²ΠΈΡΡ ΡΠΎΠ΄Π΅ΡΠΆΠΈΠΌΠΎΠ΅.
-
Select the command Sheet - Fill Cells - Sheets. In the dialog which appears, the check box Numbers must be selected (or Paste All) if you want to combine operations with the values. You can also choose the desired operation here.
-
ΠΠ°ΠΆΠΌΠΈΡΠ΅ ΠΊΠ½ΠΎΠΏΠΊΡ ΠΠ.
This dialog is similar to the Paste Special dialog, where you can find additional tips.