TomBrooklyn Wrote:
I want to merge adjacent horizontal cells and repeat that in a column
for 20 lines.

What is a quick way to do that so I don't have to repeat the merge
formatting 20 times?

Then I want to draw a line along the bottom of each of these merged
cells. Again, what is the fastest way to do that? Suppose it was
200 lines. What is the shortcut?

Thanks

Hi Tom

Use the Format Painter, it looks like a Paint Brush, click in the cell
with the format you want to repeat, click on the Format Painter and
then select the cells you want to copy the formats to


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480998