Edit Multiple Worksheets at Once in Excel

Add to Favorites

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.

Like this tutorial? Follow us on Google +

Downloadable Files: Excel File