How to merge rows and columns into one cell without using Merge and Center Icon?

V

valerie

Tom:
What you suggested to me about the copy and paste thingy to my question
in the subject line seemed to have nothing wrong with it. According to
what you have said, u mentioned pasting all the data in A1. But though
i have said that I wanted to merge rows and columns; A1 to J2 into one
cell which is right, the text value in D1 and D2's position must not be
changed.
Is there any way to avoid changing the text value position in D1 and D2
respectively?
Thanks a lot.
 
D

David McRitchie

Hi Valerie,
Please stay in the original newsgroup thread so everyone knows what you
are talking about and those that look at that thread as a question of
interest will find the posted answers in the same thread. I can't even
find a thread you started that Tom replied to you did find one
with same subject that Gord replied to..
 
T

Tom Ogilvy

I gave a more detailed explanation in the original thread, but the answer is
no. Anything not in the top left cell is deleted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to merge columns and rows into one cell, besides using the Merge and Center icon? 1
Merging multiple columns into one column (dynamically) 1
merging multple columns into one column (dynamically) 2
How to set cell value to emptry if three other columns are empty too 1
How to merge columns and rows into one cell besides using Merge and Center Icon? 4
Merge and center 3
How can I merge data from multiple columns into a single column in Microsoft Excel? 0
How to merge columns and rows into one cell besides using Merge and Center Icon? 4

Top