Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merged Cell will initally show text from 1st worksheet but then wo
I have setting up documents with multiple worksheets. When I initially set
the file up I can type info in worksheet one and have the text display on a 2nd,3rd (etc.) with no problems. However, sometimes this stops working and the 2nd,3rd worksheets will only display the formula for example =Sheet1!A1 instead of the text written. WHY? |
#2
|
|||
|
|||
Excel likes to help you.
If you put a date into A1 (ctrl-semicolon is good enough), then put =a1 in an empty cell (say B1). You'll see that excel helped by formatting B1 as a date. Excel works the same way with text cells. format A1 as text (and put something into that cell) put =A1 in cell B1 Now hit F2 (to edit B1) and just hit enter. B1 now is text and the formula shows. I don't think you can stop this "helpful" behavior. Just change the format to what you want (General?) and hit F2|Enter to reenter the formula. === If that's not it, any chance you're showing formulas? tools|options|View tab Is "formulas" checked? neil57 wrote: I have setting up documents with multiple worksheets. When I initially set the file up I can type info in worksheet one and have the text display on a 2nd,3rd (etc.) with no problems. However, sometimes this stops working and the 2nd,3rd worksheets will only display the formula for example =Sheet1!A1 instead of the text written. WHY? -- Dave Peterson |
#3
|
|||
|
|||
I checked under tools options and "formulas" is not checked. If I use a "new"
worksheet I am able to use "=Sheet1! " with no problem. I am not finding the pattern. I've tried matching cell formating ie. "text" to "text" or "general" to "general" but that does'nt help. What I'm seeing is the formula in the Enty box (at the top) =Sheet1!D6 for example and =Sheet1! in the merged cell itself. I am unable to recreate the problem. It is happening inconsistantly w Once it occurs I am no longer able to use fromulas to share the text. Thank your for responding any other ideas? "Dave Peterson" wrote: Excel likes to help you. If you put a date into A1 (ctrl-semicolon is good enough), then put =a1 in an empty cell (say B1). You'll see that excel helped by formatting B1 as a date. Excel works the same way with text cells. format A1 as text (and put something into that cell) put =A1 in cell B1 Now hit F2 (to edit B1) and just hit enter. B1 now is text and the formula shows. I don't think you can stop this "helpful" behavior. Just change the format to what you want (General?) and hit F2|Enter to reenter the formula. === If that's not it, any chance you're showing formulas? tools|options|View tab Is "formulas" checked? neil57 wrote: I have setting up documents with multiple worksheets. When I initially set the file up I can type info in worksheet one and have the text display on a 2nd,3rd (etc.) with no problems. However, sometimes this stops working and the 2nd,3rd worksheets will only display the formula for example =Sheet1!A1 instead of the text written. WHY? -- Dave Peterson |
#4
|
|||
|
|||
I don't have another guess.
But if it happens again, take good notes and paste what happened into a new message. Maybe someone has seen the problem before. neil57 wrote: I checked under tools options and "formulas" is not checked. If I use a "new" worksheet I am able to use "=Sheet1! " with no problem. I am not finding the pattern. I've tried matching cell formating ie. "text" to "text" or "general" to "general" but that does'nt help. What I'm seeing is the formula in the Enty box (at the top) =Sheet1!D6 for example and =Sheet1! in the merged cell itself. I am unable to recreate the problem. It is happening inconsistantly w Once it occurs I am no longer able to use fromulas to share the text. Thank your for responding any other ideas? "Dave Peterson" wrote: Excel likes to help you. If you put a date into A1 (ctrl-semicolon is good enough), then put =a1 in an empty cell (say B1). You'll see that excel helped by formatting B1 as a date. Excel works the same way with text cells. format A1 as text (and put something into that cell) put =A1 in cell B1 Now hit F2 (to edit B1) and just hit enter. B1 now is text and the formula shows. I don't think you can stop this "helpful" behavior. Just change the format to what you want (General?) and hit F2|Enter to reenter the formula. === If that's not it, any chance you're showing formulas? tools|options|View tab Is "formulas" checked? neil57 wrote: I have setting up documents with multiple worksheets. When I initially set the file up I can type info in worksheet one and have the text display on a 2nd,3rd (etc.) with no problems. However, sometimes this stops working and the 2nd,3rd worksheets will only display the formula for example =Sheet1!A1 instead of the text written. WHY? -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Good advice, Thanks again
"Dave Peterson" wrote: I don't have another guess. But if it happens again, take good notes and paste what happened into a new message. Maybe someone has seen the problem before. neil57 wrote: I checked under tools options and "formulas" is not checked. If I use a "new" worksheet I am able to use "=Sheet1! " with no problem. I am not finding the pattern. I've tried matching cell formating ie. "text" to "text" or "general" to "general" but that does'nt help. What I'm seeing is the formula in the Enty box (at the top) =Sheet1!D6 for example and =Sheet1! in the merged cell itself. I am unable to recreate the problem. It is happening inconsistantly w Once it occurs I am no longer able to use fromulas to share the text. Thank your for responding any other ideas? "Dave Peterson" wrote: Excel likes to help you. If you put a date into A1 (ctrl-semicolon is good enough), then put =a1 in an empty cell (say B1). You'll see that excel helped by formatting B1 as a date. Excel works the same way with text cells. format A1 as text (and put something into that cell) put =A1 in cell B1 Now hit F2 (to edit B1) and just hit enter. B1 now is text and the formula shows. I don't think you can stop this "helpful" behavior. Just change the format to what you want (General?) and hit F2|Enter to reenter the formula. === If that's not it, any chance you're showing formulas? tools|options|View tab Is "formulas" checked? neil57 wrote: I have setting up documents with multiple worksheets. When I initially set the file up I can type info in worksheet one and have the text display on a 2nd,3rd (etc.) with no problems. However, sometimes this stops working and the 2nd,3rd worksheets will only display the formula for example =Sheet1!A1 instead of the text written. WHY? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
cannot view all of text in large cell, even though I have it to w. | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
How do I get merged cells to display all text. | Excel Discussion (Misc queries) |