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

[Dmitriy Kopnichev]

something

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]

something

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.

--
Regards
Frank Kabel
Frankfurt, Germany


Dmitriy Kopnichev wrote:
> 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.

[JE McGimpsey]

something

Take a look at

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

In article <u7IS0laQEHA.3988@tk2msftngp13.phx.gbl>,
"Dmitriy Kopnichev" <kopn@hotbox.ru> wrote:

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

[Dmitriy Kopnichev]

something

'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?
"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:e2ZGznaQEHA.132@TK2MSFTNGP09.phx.gbl...
> 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.
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> Dmitriy Kopnichev wrote:
>

[JE McGimpsey]

something

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

In article <uoMkl2cQEHA.2132@TK2MSFTNGP11.phx.gbl>,
"Dmitriy Kopnichev" <kopn@hotbox.ru> wrote:

> How to make a common heading for two rows or columns then?

[Frank Kabel]

something

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

--
Regards
Frank Kabel
Frankfurt, Germany


Dmitriy Kopnichev wrote:[vbcol=seagreen]
> '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?
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:e2ZGznaQEHA.132@TK2MSFTNGP09.phx.gbl...

[David McRitchie]

something

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message news:jemcgimpsey-362F88.10142924052004@msnews.microsoft.com...[vbcol=seagreen]
> Take a look at
>
> http://www.mcgimpsey.com/excel/mergedata.html
>
> In article <u7IS0laQEHA.3988@tk2msftngp13.phx.gbl>,
> "Dmitriy Kopnichev" <kopn@hotbox.ru> wrote:
>

[Dave Peterson]

something

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



Dmitriy Kopnichev wrote:
>
> 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.

--

Dave Peterson
ec35720@msn.com

[Earl Kiosterud]

something

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.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dmitriy Kopnichev" <kopn@hotbox.ru> wrote in message
news:u7IS0laQEHA.3988@tk2msftngp13.phx.gbl...
> 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.
>
>

[Peo Sjoblom]

something

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

"Earl Kiosterud" <nowhere@nowhere.com> wrote in message
news:uBek7VfQEHA.3452@TK2MSFTNGP10.phx.gbl...
> 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.
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "Dmitriy Kopnichev" <kopn@hotbox.ru> wrote in message
> news:u7IS0laQEHA.3988@tk2msftngp13.phx.gbl...
> cells
>
>

[JE McGimpsey]

something

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

In article <#YHSohdQEHA.1620@TK2MSFTNGP12.phx.gbl>,
"David McRitchie" <dmcritchie@msn.com> wrote:

> 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

[Dmitriy Kopnichev]

something

Thanks. How to Vertical: Center across selection?
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-C8D041.14382024052004@msnews.microsoft.com...[vbcol=seagreen]
> Columns: Select two columns, choose Format/Cells/Alignment/Horizontal:
> Center across selection
>
> In article <uoMkl2cQEHA.2132@TK2MSFTNGP11.phx.gbl>,
> "Dmitriy Kopnichev" <kopn@hotbox.ru> wrote:
>

[Dmitriy Kopnichev]

something

Thanks for Format - Cells - Alignment -> Horizontal: Center across
selection. How to Vertical: Center across selection?
"Earl Kiosterud" <nowhere@nowhere.com> wrote in message
news:uBek7VfQEHA.3452@TK2MSFTNGP10.phx.gbl...
> 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.
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "Dmitriy Kopnichev" <kopn@hotbox.ru> wrote in message
> news:u7IS0laQEHA.3988@tk2msftngp13.phx.gbl...
> cells
>
>

[Dmitriy Kopnichev]

something

Hi
If I only select cells from ONE row this works.
How to make a common heading for two rows without merging?
"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:OynF58cQEHA.1620@TK2MSFTNGP12.phx.gbl...
> Hi
> if you only select cells from ONE row this should work?
> What cells do you select before you goto this menu?
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> Dmitriy Kopnichev wrote:
>

[Dmitriy Kopnichev]

something

Hi
How to make a common heading for two rows without merging then?
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-9304F2.19395224052004@msnews.microsoft.com...[vbcol=seagreen]
> 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...
>
> In article <#YHSohdQEHA.1620@TK2MSFTNGP12.phx.gbl>,
> "David McRitchie" <dmcritchie@msn.com> wrote:
>

[Dmitriy Kopnichev]

something

Thanks.
How to make a common heading for two rows without merging then?
"David McRitchie" <dmcritchie@msn.com> wrote in message
news:%23YHSohdQEHA.1620@TK2MSFTNGP12.phx.gbl...
> 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
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-362F88.10142924052004@msnews.microsoft.com...
cells[vbcol=seagreen]
the[vbcol=seagreen]
>
>

[Earl Kiosterud]

something

Dmitriy,

Don't have vertical. Sorry. ):
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dmitriy Kopnichev" <kopn@hotbox.ruDELETE> wrote in message
news:OQkUEYiQEHA.3012@TK2MSFTNGP09.phx.gbl...
> Thanks for Format - Cells - Alignment -> Horizontal: Center across
> selection. How to Vertical: Center across selection?
> "Earl Kiosterud" <nowhere@nowhere.com> wrote in message
> news:uBek7VfQEHA.3452@TK2MSFTNGP10.phx.gbl...
where[vbcol=seagreen]
> house
> holding
Alignment -[vbcol=seagreen]
leftmost[vbcol=seagreen]
the[vbcol=seagreen]
>
>