How copy format, font, color and border without copy/paste?
How can I copy data format, font, color and borders form one cell or
range to the other without using copy/paste? |
How copy format, font, color and border without 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 Michel wrote: How can I copy data format, font, color and borders form one cell or range to the other without using copy/paste? |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com