Conditinoal Font formatting
Dear,
I have a sheet for pre-printed forms. Most of the fields are fixed at font size 10. A field containing address keep expanding, I wonder if there is any way to format the font size in this field should the length of the field (cell) exceeding, say, 100 characters. Thanks. John |
You may want to look at:
format|cells|Alignment tab|Shrink to fit. John wrote: Dear, I have a sheet for pre-printed forms. Most of the fields are fixed at font size 10. A field containing address keep expanding, I wonder if there is any way to format the font size in this field should the length of the field (cell) exceeding, say, 100 characters. Thanks. John -- Dave Peterson |
All times are GMT +1. The time now is 06:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com