Prev: Excel 2003 - Skip a cell
Next: Recover lost excel tabs/spreadsheets from workbook
From: Matt S on 21 Apr 2010 12:01
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
From: Don on 21 Apr 2010 14:13
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
From: Matt S on 22 Apr 2010 08:03
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
From: Bob I on 22 Apr 2010 08:23
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?

From: Matt S on 27 Apr 2010 14:27
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?
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Excel 2003 - Skip a cell
Next: Recover lost excel tabs/spreadsheets from workbook