close

Is there a way that a cell can automatically size itself by height to fit the
information pulled into the cell as part of a Vlookup formula. I use Vlookup
in a spread, but I have to constantly stop and size the cells to view all the
information.

Appreciations to anyone who can help.

Just a thought ..

Try format cell(s) to wrap text ?
(via: Format gt; Cells gt; Alignment tab)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Mikequot; wrote:
gt; Is there a way that a cell can automatically size itself by height to fit the
gt; information pulled into the cell as part of a Vlookup formula. I use Vlookup
gt; in a spread, but I have to constantly stop and size the cells to view all the
gt; information.
gt;
gt; Appreciations to anyone who can help.

Wrap Text does not work. It mearly wraps the text inside the existing size of
the cell in discussion. I am trying to have the cell automatically size
itself by height to fit the information pulled into the cell by the Vlookup
formula. ThankYou for the post any other suggestions?

quot;Maxquot; wrote:

gt; Just a thought ..
gt;
gt; Try format cell(s) to wrap text ?
gt; (via: Format gt; Cells gt; Alignment tab)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Mikequot; wrote:
gt; gt; Is there a way that a cell can automatically size itself by height to fit the
gt; gt; information pulled into the cell as part of a Vlookup formula. I use Vlookup
gt; gt; in a spread, but I have to constantly stop and size the cells to view all the
gt; gt; information.
gt; gt;
gt; gt; Appreciations to anyone who can help.

quot;Mikequot; wrote:
gt; Wrap Text does not work. It mearly wraps the text inside the existing size of
gt; the cell in discussion. I am trying to have the cell automatically size
gt; itself by height to fit the information pulled into the cell by the Vlookup
gt; formula. ThankYou for the post any other suggestions?

I'm out here, sorry. Hang around awhile for insights from others.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()