ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I group and edit multiple worksheets? (https://www.excelbanter.com/excel-worksheet-functions/102515-how-do-i-group-edit-multiple-worksheets.html)

LeAnn

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.

Dave Peterson

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

LeAnn

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


LeAnn

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


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