Incorporating the Same Data on Another Worksheet

If you have to type the data into a cell (not range or not mutiple cells), then you can also enter these values in the same cells located on another worksheet in the workbook file without having to type again.

The trick is to choose the tab names of the worksheet to be filled (if consecutive press SHIFT, if not press CTRL).

If the tab is not visible slide the worksheet name using the scrolling button so that the tab name is visible.


Click on the destination worksheet cells that will be filled in with data. Then on the Home tab, click the Fill button located in the Editing group, and select Across Worksheet.