How copy format, font, color and border without copy/paste?

  • Thread starter Thread starter Michel
  • Start date Start date
M

Michel

How can I copy data format, font, color and borders form one cell or
range to the other without using copy/paste?
 
Michel,

Try the Format Painter (that little paintbrush on the Standard toolbar).

Click the cell(s), click the paintbrush, click the cell to copy to.
For multiple pastes........
Click the cell(s), double click the paintbrush, click (and repeat)
on cells you want formatted.

John
 
Back
Top