Change+multiple+sheets+in+Excel+with+one+manoeuvre

Change multiple sheets in Excel with one manoeuvre

The first thing you need to do is go to the first worksheet to be changed/edited. Next, you need to select the sheet tabs of all the worksheets that need the same changes. o To select a series of tabs, hold down the Shift key and click on the last sheet tab in the series. You should see that the first, last and all tabs in between are selected simultaneously. o If you have non-consecutive sheets to change, hold down the Ctrl key and click on the tab for each sheet to be changed. Once you have all the tabs selected, you're ready to begin your changes. Go ahead and make those changes, only on the visible sheet. Be sure not to click out of that sheet or you will deselect all of the sheets. Are your changes all done?

If so, click on another sheet tab.

Immediately, you should notice that the multiple tabs are no longer highlighted.

Take a look at all the sheets you had selected to change.

All of the changes on all of the selected sheets, including data, formatting, etc., have been completed in one simple move!  