Merging multiple sets of cells

[Brian]

Howdy All,

I would like to merge cells d2 and e2, d3 and e3, etc. all the way down the
columns.

Is there a simpler way to do this than selecting the sets of cells
individually and clicking 'merge'?

Thanks,
Brian

[Anne Troy]

Copy d2 and e2 and paste at d3...
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Brian" <[email protected]> wrote in message
news:[email protected]...
> Howdy All,
>
> I would like to merge cells d2 and e2, d3 and e3, etc. all the way down
> the columns.
>
> Is there a simpler way to do this than selecting the sets of cells
> individually and clicking 'merge'?
>
> Thanks,
> Brian
>

[Dave Peterson]

You can add an icon to your favorite toolbar.

Tools|customize|commands tab|format category
Look for Merge Across
and drag it to where you want.


Brian wrote:
>
> Howdy All,
>
> I would like to merge cells d2 and e2, d3 and e3, etc. all the way down the
> columns.
>
> Is there a simpler way to do this than selecting the sets of cells
> individually and clicking 'merge'?
>
> Thanks,
> Brian

--

Dave Peterson

[Anne Troy]

Oh... and try the F4 key to repeat the last command...
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Brian" <[email protected]> wrote in message
news:[email protected]...
> Howdy All,
>
> I would like to merge cells d2 and e2, d3 and e3, etc. all the way down
> the columns.
>
> Is there a simpler way to do this than selecting the sets of cells
> individually and clicking 'merge'?
>
> Thanks,
> Brian
>

[Ian]

Merge D2 & E2. Select and copy the merged cell. Select D3 to E100. Go to
Edit>Paste Special>Formats

--
Ian
--
"Brian" <[email protected]> wrote in message
news:[email protected]...
> Howdy All,
>
> I would like to merge cells d2 and e2, d3 and e3, etc. all the way down
> the columns.
>
> Is there a simpler way to do this than selecting the sets of cells
> individually and clicking 'merge'?
>
> Thanks,
> Brian
>

[Dave Peterson]

Then select
D2:Exx
and click that button

Dave Peterson wrote:
>
> You can add an icon to your favorite toolbar.
>
> Tools|customize|commands tab|format category
> Look for Merge Across
> and drag it to where you want.
>
> Brian wrote:
> >
> > Howdy All,
> >
> > I would like to merge cells d2 and e2, d3 and e3, etc. all the way down the
> > columns.
> >
> > Is there a simpler way to do this than selecting the sets of cells
> > individually and clicking 'merge'?
> >
> > Thanks,
> > Brian
>
> --
>
> Dave Peterson

--

Dave Peterson

[Brian]

Thanks to everyone for the useful info!!!


"Brian" <[email protected]> wrote in message
news:[email protected]...
> Howdy All,
>
> I would like to merge cells d2 and e2, d3 and e3, etc. all the way down
> the columns.
>
> Is there a simpler way to do this than selecting the sets of cells
> individually and clicking 'merge'?
>
> Thanks,
> Brian
>