How to merge cells in a row, horizontally only, not vertically?

  • Thread starter Thread starter Dmitriy Kopnichev
  • Start date Start date
D

Dmitriy Kopnichev

Hello
How to merge cells in a row, horizontally only, not vertically? I want cells
in a selected area to merge with other cells in the same row, not in the
same column.
 
Hi
just select these cells and goto 'Format - Cells - Alignment'
That said: I strongly recommend NOT to use merged cells as they will
cause problems for filtering, sorting, etc.
 
'Format - Cells - Alignment' will merge the cells horizontally and
vertically, not horizontally only.
How to make a common heading for two rows or columns then?
 
Columns: Select two columns, choose Format/Cells/Alignment/Horizontal:
Center across selection
 
Hi
if you only select cells from ONE row this should work?
What cells do you select before you goto this menu?
 
Hi Dmitriy,
Unless I've misread John's macros do not take a selection
of A1:D4 and end up with A1, A2, A3, A4 but would
end up with A1

The following toolbar key will merge the cells as asked.
-- Merge Across -- customize, commands, format (preserves rows)
to see what the icon looks like see
Merge and Unmerge Cells
http://www.mvps.org/dmcritchie/excel/merge.htm#builtin

as noted previously merged cells will interfere with
with sorting, filtering, copying, pasting,
autofit of row height and column widths
 
Each row in the selection is independent of the other rows??

If yes, you might want to add an icon to your favorite toolbar.

Tools|Customize|commands|Format category
Look for the "merge across" icon.

In fact, there's a bunch of merge/unmerge icons in there. You may want to grab
a couple (unmerge especially???).
 
Dimitriy,

If you MUST merge the cells, we will watch for posts from you later where
you're having problems because of the merging. And we'll come to your house
and make faces. :)

If you select each row's worth of cells to be merged one at a time, holding
the Shift key after the first one, it will merge the rows separately.
You'll get several messages about it. You may go mad.

If you have a great many of them, a macro can do it.

Better yet, don't merge them. Consider using Format - Cells - Alignment -
Horizontal: Center across selection. First have the data in the leftmost
cell only.
 
Hide it, then protect the workbook, it won't prevent
a determined user but perhaps the average user,

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Yes, for some reason I forgot to include my "Do NOT under any
circumstances actually merge the cells - you'll be asking how to unmerge
them tomorrow" text.

THanks for the clarification...
 
Thanks for Format - Cells - Alignment -> Horizontal: Center across
selection. How to Vertical: Center across selection?
 
Thanks. How to Vertical: Center across selection?
JE McGimpsey said:
Columns: Select two columns, choose Format/Cells/Alignment/Horizontal:
Center across selection
Click to expand...
 
Hi
If I only select cells from ONE row this works.
How to make a common heading for two rows without merging?
 
i was also looking for a solution for this, as i had to merge two cells middle and last name into one.

Solution:
Copy the rows to Notepad. Go to Edit > Replace, select and copy the tab and replace it with a space. copy back to excel.

:cheers:
 
Back
Top