• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Checking a formula on multiple tabs

Jaimee001

Jaimee001

Member
Hi All....I recently given access to a spread sheet with multiple tabs. Each tab has about 10-15 different formulas. I recently noticed that a couple of the formulas were incorrect in a few of the tabs. example: b165 has the formula =sum(b162:164), however in one of the tabs it was =sum(b162).


Is there an easier way to check the formulas in each tab than going into each tab?

If the formulas are all correct in tab 1, is there a way to view/check the formulas in the other tabs to make sure they're all the same?


Hope that makes sense :)

Regards,

Jaimee
 
Hi Jaimee001. Is the layout of each tab identical?


Also, note that there is a 'show formulas' option in Excel that you can toggle on and off by pushing the Ctrl + ` key, that should be useful in this case.
 
Hi, if the formula is in the same cell on all the sheets you could "group" them then rewrite the formula, it will then show up on all of the grouped tabs/sheets. Might not be very helpful if there are very many sheets.
 
You must log in or register to reply here.
Back
Top