How do I group and edit multiple worksheets?

[Guest]

How do I keep the tab reference in my formulas when I'm editing? Some of my
cells contain the tab name and others do not. When I try to group and edit
worksheets, I get this odd R566,+C233 label in the remaining worksheets.

 

[Dave Peterson]

It's interesting to see the inners of excel, huh?

When you enter a formula, excel "sees/parses" it as R1C1 reference style--but it
displays the formula the way you want according to that setting.

Your problem is that in the other sheets, the cells are formatted as Text.
Change the format to General (or Number or whatever you want except Text) and
you'll be ok.

 

[Guest]

Thank you!!!!!

It's interesting to see the inners of excel, huh?

When you enter a formula, excel "sees/parses" it as R1C1 reference style--but it
displays the formula the way you want according to that setting.

Your problem is that in the other sheets, the cells are formatted as Text.
Change the format to General (or Number or whatever you want except Text) and
you'll be ok.

 

[Guest]

This worked the first time I did it but it's doing it again. I've formatted
my cells to be numbers and I'm still getting these references when I try to
group edit. Any other suggestions?

 

[Dave Peterson]

Excel likes to help and sometimes changes the format to text. -- cells that
contain formulas to cells with text can get changed.

Try formatting those cells as General one more time.