ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numbers I enter on one sheet transfer onto others sometimes. Why? (https://www.excelbanter.com/excel-discussion-misc-queries/115299-numbers-i-enter-one-sheet-transfer-onto-others-sometimes-why.html)

Chazzer555

Numbers I enter on one sheet transfer onto others sometimes. Why?
 
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.

Nick Hodge

Numbers I enter on one sheet transfer onto others sometimes. Why?
 
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

HIS
www.nickhodge.co.uk

"Chazzer555" wrote in message
...
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.





All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com