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

M

Michel

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

John Wilson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to paste this down? 3
Printing Outline view - formatting lost 0
Paste to excel from word - auto format problem 1
Dealing with a Pivot Table (when I don't want to) 0
Border formatting row of cells 22
Copy Range of Cells to Outlook 1
Copy addition formula of non-consecutive horizontal cells 2
How can the font and size of (all) citation numbers be altered? 1

Top