View Single Post
Old 01-27-2009, 08:38 PM   #11
Betty
Kicking up my heels!
 
Betty's Avatar
 
Join Date: Jan 2005
Location: The Silver State
Posts: 3,783
Betty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of cool
Quote:
Originally Posted by Drince88 View Post
For the second part - highlight ALL the tabs you want to make a change in (use the shift or control key) - it'll say [Group] at the top next to the workbook name. And then on the first tab, change the equation in the cell, and it should change it in all of them. I just tested it and it worked.

The BIG thing on this, though - is to un-group the tabs before you go and do more work - otherwise you run the risk of making changes to every sheet, that you didn't really mean to (not that I PERSONALLY have ever done anything like that - nope, not me!)
That's a great trick!
__________________
Nee Stell Thue
Betty is offline   Submit to Quotes Reply With Quote