ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   display content of merged cells (https://www.excelbanter.com/excel-discussion-misc-queries/252066-display-content-merged-cells.html)

LucaRR

display content of merged cells
 
How can I display the content of merged cells in the adiacent empty cells?
e.g. if I put some long unwrapped text in A1 I can see it in A2 and A3,as
long as they are empty; but if I merge A1 and A2 i cannot see anymore the
extra text in A3 even if empty.
Thank you for any help!
Luca

David Biddulph[_2_]

display content of merged cells
 
Sounds like another good reason for not merging cells. The archives of this
group have countless other reasons.
--
David Biddulph

LucaRR wrote:
How can I display the content of merged cells in the adiacent empty
cells? e.g. if I put some long unwrapped text in A1 I can see it in
A2 and A3,as long as they are empty; but if I merge A1 and A2 i
cannot see anymore the extra text in A3 even if empty.
Thank you for any help!
Luca




LucaRR

display content of merged cells
 
Errata corrige: Please read B1 and C1 instead of A2 and A3!

"LucaRR" wrote:

How can I display the content of merged cells in the adiacent empty cells?
e.g. if I put some long unwrapped text in A1 I can see it in A2 and A3,as
long as they are empty; but if I merge A1 and A2 i cannot see anymore the
extra text in A3 even if empty.
Thank you for any help!
Luca



All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com