January 1, 2008

One Change = Many Changes

Have you ever had an MS Excel workbook that you're constantly working in, making the same changes to several different worksheets?

What did you do?

Did you go to the first sheet, make changes, move to the next sheet, make the same changes, move to the next sheet, make the same changes again and so on?

How tiresome was that?

Want a quicker way to make identical changes on different sheets?

Maybe a way that allows you to make just one set of changes that will include all of the necessary worksheets?

Sounds too good to be true, doesn't it?!

Well, there's no need to pinch yourself. You're not dreaming. It can be done and it doesn't require any special feature or function. You just have to know about a couple extra clicks!

Ready to get started?

Yes?

Good, let's get going!

  • 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.

    • 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.

    • If you have non-consecutive sheets to change, hold down the Ctrl key and click on the tab for each sheet cialis wholesale to be changed.

  • Once you have all the tabs selected, you're ready to begin your changes.

So, 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.

Now, it's time to notice something way more exciting!

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

Wow!

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

It's time to do your little happy dance!

Permalink • Print • Comment

Leave a comment

You must be logged in to post a comment.

Made with WordPress and the Semiologic theme and CMS • Sky Gold skin by Denis de Bernardy