Fill Sheets

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

To access this command...

Choose Sheet - Fill Cells - Sheets.


Warning Icon

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.

Filling a Sheet

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