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

[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.

 

[Frank Kabel]

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.

 

[JE McGimpsey]

Take a look at

http://www.mcgimpsey.com/excel/mergedata.html

 

[Dmitriy Kopnichev]

'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?

 

[JE McGimpsey]

Columns: Select two columns, choose Format/Cells/Alignment/Horizontal:
Center across selection

 

[Frank Kabel]

Hi
if you only select cells from ONE row this should work?
What cells do you select before you goto this menu?

 

[David McRitchie]

Hi Dmitriy,
Unless I've misread John's macros do not take a selection
of A14 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

 

[Dave Peterson]

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???).

 

[Earl Kiosterud]

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.

 

[Peo Sjoblom]

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

 

[JE McGimpsey]

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...

 

[Dmitriy Kopnichev]

Thanks for Format - Cells - Alignment -> Horizontal: Center across
selection. How to Vertical: Center across selection?

 

[Dmitriy Kopnichev]

Thanks. How to Vertical: Center across selection?

Columns: Select two columns, choose Format/Cells/Alignment/Horizontal:
Center across selection

 

[Dmitriy Kopnichev]

Hi
If I only select cells from ONE row this works.
How to make a common heading for two rows without merging?

 

[Dmitriy Kopnichev]

Hi
How to make a common heading for two rows without merging then?

 

[Dmitriy Kopnichev]

Thanks.
How to make a common heading for two rows without merging then?

 

[Earl Kiosterud]

Dmitriy,

Don't have vertical. Sorry. ):

 

[flik0001]

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.