Solved

Excel - Display Formula Result Beyond Cell Boundary

Posted on 2014-03-25
2
483 Views
Last Modified: 2014-03-26
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
0
Comment
Question by:pcamis
2 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39953981
Not really, you can't do that with formatting alone. You can set an on-calculation event in your workbook that will regenerate the formulas, analyze their results and according to the results, delete or not, but I think that's the only way you'll be able to achieve that (unless you expand the columns).

Thomas
0
 

Author Closing Comment

by:pcamis
ID: 39957229
Bummer - that's the answer I was afraid of.  This is just a small section of a much more expansive spreadsheet, so I don't have the option to expand the columns any wider, on top of which the result will occasionally be much longer.  If I pursue this project further, I may just have to delete the formula from adjacent cells, but this would end being extra work for others when manipulating the sheet.

Thanks for the confirmation, Thomas!
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question