excel - Allow text overflow despite data in adjacent cells -
is possible have text populate in cell , allow overflow adjacent cells though there data in cells? here layout , situation: i have worksheet acts "report" sheet populates data based on drop down selections @ top of report sheet. user can select 1 of 8 countries view specific data, , report sheet populates cells d16 through p25. user can select view 8 countries. in instance, country data populate in blocks of data (d16:p25, d27:p36, d38:p47, etc.) when looking @ 1 country, other cells data blank (the formulas return ""). i need text overflow because asked incorporate summary of applicable limitations below first data table when viewing 1 country in report. example, if report selected view belgium, data populates in cells d16:p26. now, need show in cell d18:d22 summary of local laws. can incorporate necessary text using if statements column d, cut off because there formulas in columns e - p returning no values need return values "all countries" view.