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
---
- May 27 Tue 2008 20:44
Automatic cell Formating ina VLookup formula
close
全站熱搜
留言列表
發表留言