Update forumla in same cell on each sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to update the formula for the same cell on each worksheet of a
workbook without having to individually change each one?
 
Hi
Yes it is possible.
Add the sheets in your selection using the Ctrl Key and clicking the
relevant worksheets tabs
Place your formula, validate and ungroup the sheets.

HTH
Cordially
Pascal
 
Thank you. This did what we were looking for.

papou said:
Hi
Yes it is possible.
Add the sheets in your selection using the Ctrl Key and clicking the
relevant worksheets tabs
Place your formula, validate and ungroup the sheets.

HTH
Cordially
Pascal
Click to expand...
 
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

referencing a cell in another worksheet 5
Must I use IRM to protect an entire workbook? 1
count if multiple sheets in workbook 2
Forumla rows and columns 3
Paste Values in linked Cells Only 4
Forumlas Aren't Auto Recalculating 1
Excel cells randomly don't get updated unless each cell is updated 5
Dragging a formula across the row in 2007 2

Back
Top