Fill Sheets

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

рдпреЛ рдЖрджреЗрд╢ рдкрд╣реБрдБрдЪ рдЧрд░реНрди...

Choose Sheet - Fill Cells - 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 or Shift.

In contrast to copying an area to the clipboard, you can filter certain information and calculate values.

рдПрдЙрдЯрд╛ рд╕реНрдкреНрд░реЗрдбрд╕рд┐рдЯ рднрд░реНрджрд╛

This dialog is similar to the Paste Special dialog, where you can find additional tips.