View Single Post
  #1   Report Post  
TomBrooklyn
 
Posts: n/a
Default Repeating a Cell Format For Many Rows: What's Fastest Way?


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


--
TomBrooklyn
------------------------------------------------------------------------
TomBrooklyn's Profile: http://www.excelforum.com/member.php...fo&userid=7398
View this thread: http://www.excelforum.com/showthread...hreadid=480998