Dan Carp
asked on
Excel - Display Formula Result Beyond Cell Boundary
I am working on the attached spreadsheet which includes the same formula in cells I2:P2. When there are no values in the cells below, the formula is set to output a blank. Is there a way for the display of a cell's results to span across over adjacent cells with null output to the right? In other words, can I get J2 to look like J10 (achieved by deleting the formulas in K10 and L10)? Deleting the formulas is less than ideal, and merging cells is not an option, nor would be resizing the cell / enabling word wrap.
Thanks in advance!
Test.xlsx
Thanks in advance!
Test.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the confirmation, Thomas!