Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
I have a 2003 worksheet with many lines of wrapped text. When I select a
cell I can read all the text in the formula bar. But I sent it to someone with 2007 and they claim only the first line of text is visible. Is there an option in 2007 that needs to be selected to read all text? -- Matt S |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
ask the person to double click on the cell or at the top, widden the area
where you see the text. If the text had a control break (alt+enter) then it may have stacked the data and they are looking at only the first line "Matt S" wrote: I have a 2003 worksheet with many lines of wrapped text. When I select a cell I can read all the text in the formula bar. But I sent it to someone with 2007 and they claim only the first line of text is visible. Is there an option in 2007 that needs to be selected to read all text? -- Matt S |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
Thanks, I don't understand " -- widden the area where you see the text"
How would they do that? Matt S "Don" wrote: ask the person to double click on the cell or at the top, widden the area where you see the text. If the text had a control break (alt+enter) then it may have stacked the data and they are looking at only the first line "Matt S" wrote: I have a 2003 worksheet with many lines of wrapped text. When I select a cell I can read all the text in the formula bar. But I sent it to someone with 2007 and they claim only the first line of text is visible. Is there an option in 2007 that needs to be selected to read all text? -- Matt S |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
Have them press "CTRL+Shift+U"
Matt S wrote: I have a 2003 worksheet with many lines of wrapped text. When I select a cell I can read all the text in the formula bar. But I sent it to someone with 2007 and they claim only the first line of text is visible. Is there an option in 2007 that needs to be selected to read all text? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
Perfect - Thanks much
-- Matt S "Bob I" wrote: Have them press "CTRL+Shift+U" Matt S wrote: I have a 2003 worksheet with many lines of wrapped text. When I select a cell I can read all the text in the formula bar. But I sent it to someone with 2007 and they claim only the first line of text is visible. Is there an option in 2007 that needs to be selected to read all text? . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
You're welcome, have a great day!
Matt S wrote: Perfect - Thanks much |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing text 2003 vs. 2007
Thanks Don I see what you mean about widening the formula bar
-- Matt S "Don" wrote: ask the person to double click on the cell or at the top, widden the area where you see the text. If the text had a control break (alt+enter) then it may have stacked the data and they are looking at only the first line "Matt S" wrote: I have a 2003 worksheet with many lines of wrapped text. When I select a cell I can read all the text in the formula bar. But I sent it to someone with 2007 and they claim only the first line of text is visible. Is there an option in 2007 that needs to be selected to read all text? -- Matt S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Box Issues for 2003 vs. 2007 | Excel Discussion (Misc queries) | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Help Text in an Excel 2003 or 2007 Worksheet | Excel Discussion (Misc queries) | |||
Wrap Text in 2007 vs 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 - Lock for viewing | Excel Discussion (Misc queries) |