Multiple copying

  • Thread starter Thread starter Amadeo
  • Start date Start date
A

Amadeo

Does anybody know how, in one stroke, I can copy a
borderline (or, for that matter, any other item on the
worksheet) at intermittent rows (e.g. rows 3,6,9 etc.)?
(I thought that I could use the Ctrl-key to mark the
rows and then paste the object all at once).
 
If it is just border lines, then you should be able to copy the whole range and
paste special the formats only.

Failing that, select one of the border lines, double click the format painter,
and you can then use it to paste formats until you hit Esc to cancel.
 
Back
Top