entering same formula in multiple sheets

P

Paul B

ab, group the sheets, click on one sheet and hold the ctrl key down and
click on the other ones, if you want them all select the first one hold down
the shift key and click on the last sheet, put in your formulas, don't
forget to ungroup the sheets, right click and ungroup.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top