Blog Archive

Excel: Entering Same Information in Multiple Sheets

0778f7ed4c2200330f801753a6b246fb.png

How to edit multiple worksheets at the same time; this includes adding, editing, deleting, and formatting data.

Steps

Hold down the Ctrl key and click each sheet tab that you want to edit, or hold Shift and click the last tab to edit to select all tabs in the middle.
3ee413c01635d55d8c97bbcbbe2c6a61.jpg
Start working:
05ff15e8b7ca5f825c31892553b25862.png
Once you hit Enter or navigate to any other tab, you will see that what you did was copied to all selected worksheets.
28632113c83fd5642f77dda4bc802cd7.png
This also works for formatting.
0778f7ed4c2200330f801753a6b246fb.png

Notes

Be careful when using this feature! If there is data in the worksheets that are selected, it can be overwritten and Excel will not give you a warning about this. As such, you should only do this with worksheets that are formatted exactly the same or that start out empty, like in my example.
To deselect the tabs, click any tab when all are selected or click a non-selected tab.
Download the sample file for this tutorial if you'd like to work with the above example in Excel.
Source: TeachExcel