Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automation of Font Resizing
Select all of the cells and bump the font size down.
"Pitt" wrote: URGENT: PLEASE HELP I would like to know of a cell format setting, a formula, VB program, or any other method to automatically resize the font size if the value entered is too large and results in the display of the following: "####..." It would be ideal if the font would downsize so that numbers could be displayed. The cells display numbers, size 12 font, tahoma. Numbers up to 999.99 diplay, 1,000.00 (+) displays "###". Workbook was originally designed to accomodate larger numbers using size 10 font, but other parties decided much later in the game that they wanted larger text. INFO: My workbook has many similar worksheets that are intended to be changed regularly. Each workesheet has hundreds of cells that are referenceing another worksheet's data or some other source. When a value entered in the "referenced cell(s)" is too large, several worksheets could have cells displaying the aformentioned error. My deadline is near and the workbook has grown too large to make the affected cells larger (ex. by merging more cells) to accomodate more text and/or to review each worksheet for any affected cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default font for Comments | Excel Worksheet Functions | |||
Changing default font for copy / paste | Excel Discussion (Misc queries) | |||
Why is first font action v-e-r-y slow? | Excel Discussion (Misc queries) | |||
xl chart font sizing into PPT | Charts and Charting in Excel | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) |