![]() |
How do I group and edit multiple worksheets?
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. |
How do I group and edit multiple worksheets?
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. LeAnn wrote: 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 |
How do I group and edit multiple worksheets?
Thank you!!!!!
"Dave Peterson" wrote: 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. LeAnn wrote: 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 |
How do I group and edit multiple worksheets?
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? "LeAnn" wrote: Thank you!!!!! "Dave Peterson" wrote: 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. LeAnn wrote: 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 |
How do I group and edit multiple worksheets?
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. LeAnn wrote: 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? "LeAnn" wrote: Thank you!!!!! "Dave Peterson" wrote: 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. LeAnn wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com