Do you want to save time while creating reports in excel?

If your excel report consists the repeated data in many/all the sheets, don’t think about the copy and paste method we have something very interesting alternative.

Legacy way: Copy the required field and paste in all other required sheets.

Alternative way:

1.   Select the all/required sheets in which you want to duplicate the data (multiple selection can be done using ctrl key.
2.  Now enter a value at the required cell and press enter.

Done , now the entered value appears in all selected sheets in the same cell.