ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofit data in each individual cell (https://www.excelbanter.com/excel-discussion-misc-queries/124000-autofit-data-each-individual-cell.html)

tepickles

Autofit data in each individual cell
 
I know you can autofit the data in a column so that the largest string of
data in a cell is the width of that column, but is there a way to autofit the
data in each individual cell, outside of doing it by column?
--
Tom P.

Peo Sjoblom

Autofit data in each individual cell
 
No, that is not possible. It will use the size of the cell with the largest
string


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"tepickles" wrote in message
...
I know you can autofit the data in a column so that the largest string of
data in a cell is the width of that column, but is there a way to autofit
the
data in each individual cell, outside of doing it by column?
--
Tom P.





All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com