I have a data entry spreadsheet that contains many input fields. Some of these fields have formulas in them in order to set a default value, or conditionally add text to the cell with highlighting, etc. When the user first clicks on a cell with a formula in it, it appears that the column width is the appropriate size. But, as soon as one character is added the column width jumps to the size of the formula (which could be fairly long). Data entry moves from left to right. When the column width becomes too large, it blocks the view for the next field or two. It would not be very feasible to expand all the columns with formulas in them. Do you have any other ideas to keep these column widths as they are initially defined?
Bookmarks