entering same formula in multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Reference different lines in the same cell 1
Formula Based on Multiple Sheets 5
using the =page! feature to transpose a row to column 0
summing same cell in multiple worksheets 3
Excel formula help please 3
sum values from the listed sheets 9
Copy corresponding cell in Column B if cell in A contains certain text? 1

Back
Top