Automatic cell Formating ina VLookup formula
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. |
Automatic cell Formating ina VLookup formula
Just a thought ..
Try format cell(s) to wrap text ? (via: Format Cells Alignment tab) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mike" wrote: 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. |
Automatic cell Formating ina VLookup formula
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? "Max" wrote: Just a thought .. Try format cell(s) to wrap text ? (via: Format Cells Alignment tab) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mike" wrote: 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. |
Automatic cell Formating ina VLookup formula
"Mike" wrote:
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? I'm out here, sorry. Hang around awhile for insights from others. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com