I have merged 2 cells and want to apply the format to number of rows. When I
highlight the rows and click edit repeat format cells all of the rows are
merged in to 1 cell. How do I apply merged cells format to individual rows
without merging them in to 1 cell

Thanks

Tony

In xl2003, I can add an icon to my favorite toolbar that merges cells on a row
by row basis.

Tools|Customize|Commands tab|Format category
Look for the "Merge Across" icon (about half way down the list)

Then drag it to your favorite toolbar (or create a new toolbar and put it on
that one).

Then select your range and click the icon.


Tony D wrote:
>
> I have merged 2 cells and want to apply the format to number of rows. When I
> highlight the rows and click edit repeat format cells all of the rows are
> merged in to 1 cell. How do I apply merged cells format to individual rows
> without merging them in to 1 cell
>
> Thanks
>
> Tony

--

Dave Peterson

And after you have looked for and used the merge across feature, look for
nothing but problems with copying, pasting, sorting, filtering and a gaggle of
others.


Gord Dibben MS Excel MVP

On Sun, 22 Jun 2008 13:01:49 -0500, Dave Peterson <(E-Mail Removed)>
wrote:

>In xl2003, I can add an icon to my favorite toolbar that merges cells on a row
>by row basis.
>
>Tools|Customize|Commands tab|Format category
>Look for the "Merge Across" icon (about half way down the list)
>
>Then drag it to your favorite toolbar (or create a new toolbar and put it on
>that one).
>
>Then select your range and click the icon.
>
>
>Tony D wrote:
>>
>> I have merged 2 cells and want to apply the format to number of rows. When I
>> highlight the rows and click edit repeat format cells all of the rows are
>> merged in to 1 cell. How do I apply merged cells format to individual rows
>> without merging them in to 1 cell
>>
>> Thanks
>>
>> Tony

Thanks Dave unfortunatley I am working on Excel 2002 at home, although I may
try this in work as we use xl 2003

Tony D

"Dave Peterson" wrote:

> In xl2003, I can add an icon to my favorite toolbar that merges cells on a row
> by row basis.
>
> Tools|Customize|Commands tab|Format category
> Look for the "Merge Across" icon (about half way down the list)
>
> Then drag it to your favorite toolbar (or create a new toolbar and put it on
> that one).
>
> Then select your range and click the icon.
>
>
> Tony D wrote:
> >
> > I have merged 2 cells and want to apply the format to number of rows. When I
> > highlight the rows and click edit repeat format cells all of the rows are
> > merged in to 1 cell. How do I apply merged cells format to individual rows
> > without merging them in to 1 cell
> >
> > Thanks
> >
> > Tony
>
> --
>
> Dave Peterson
>

xl2002 has the same icon and it can be found in the same manner.

Tony D wrote:
>
> Thanks Dave unfortunatley I am working on Excel 2002 at home, although I may
> try this in work as we use xl 2003
>
> Tony D
>
> "Dave Peterson" wrote:
>
> > In xl2003, I can add an icon to my favorite toolbar that merges cells on a row
> > by row basis.
> >
> > Tools|Customize|Commands tab|Format category
> > Look for the "Merge Across" icon (about half way down the list)
> >
> > Then drag it to your favorite toolbar (or create a new toolbar and put it on
> > that one).
> >
> > Then select your range and click the icon.
> >
> >
> > Tony D wrote:
> > >
> > > I have merged 2 cells and want to apply the format to number of rows. When I
> > > highlight the rows and click edit repeat format cells all of the rows are
> > > merged in to 1 cell. How do I apply merged cells format to individual rows
> > > without merging them in to 1 cell
> > >
> > > Thanks
> > >
> > > Tony
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson