Repeating a Cell Format For Many Rows: What's Fastest Way?

[TomBrooklyn]

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

[Paul Sheppard]

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

[swatsp0p]

Try this:

Select your cells to merge in the top row. Click Format>Cells. On the Alignment tab, select Merge. On the Borders tab, set your desired underline. Click OK to apply these changes.

Now, with this merged cell highlighted, click on the Format Painter on the toolbar (looks like a paint brush). Click and hold down the mouse button on the cell below your merged cell and drag over and down as far as needed (2 columns, 200 rows?) and release. Your format should now be applied to all of the rows.

Does this work for you?

[TomBrooklyn]

Thanks, Paul and Bruce. That did it. Format painter.

Cheers, Tom