Excel+One+Change+Many+Changes

Excel One Change Many Changes

Have you ever had an MS Excel workbook in which you find yourself constantly making the same changes to several different worksheets?

Did you go to the first sheet, make changes, move to the next sheet, make the same changes, move to the next sheet, again make the same changes, etc. How tiresome was that?

There exists a quicker way to make identical changes on different sheets?

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 should have these same changes.

To select a series of tabs, hold down the Shift key and then click on the last sheet tab in the series. You should see that the first, last and all the tabs in between are selected simultaneously.

If you have non-consecutive sheets to change, hold down the Control 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.

However, only one of the sheet will be visible sheet. Do not click out of that sheet or you will deselect 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.

Wow!

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

Does that make you a happier bunny?

Please post your comments in :- [|Queries and Comments]

To print off for your Crib Sheet:- Copy and Paste to Word.doc then Print  