Numbers I enter on one sheet transfer onto others sometimes. Why?

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

Guest

I use excel as a multi page system to do calculations. Sometimes the auto
calculate turns itself off and any fresh number I type in automatically
appears on other pages in the same cell location.
 
You will have grouped sheet tabs If you look on the title bar (top left) you
will see the file name and [grouped]

To group sheets either Ctrl and click another sheet tab or shift+click on
another tab. Anything you do on these sheets will be 'mirrored' on others

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 

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

Back
Top