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