How to merge columns and rows into one cell, besides using the Merge and Center icon?

  • Thread starter Thread starter valerie
  • Start date Start date
V

valerie

Hello,
I want to merge the columns and rows starting from A1 right up to J2;
no lines in between as one whole cell. I have text data value in D1 and
D2 respectively. Using merge and center icon can only retain upper-left
most data only. This means that only the text data in D1 is retained,
data in D2 is deleted. How can I merge the stated rows and columns into
one cell and center the text within?
Note: I’m not talking about any formula here)
Thanks for any help.
 
Back
Top