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

T

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
 
P

Paul Sheppard

TomBrooklyn said:
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
Click to expand...

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
 
S

swatsp0p

Try this:

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

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

Does this work for you
 
Top