How do I set the default paste option?
I really don't want the extra step of the paste option box on a worksheet,
but when I eliminate the appearance of that box it always uses the "match source formatting" option. I always want to use the "match destination formatting" option on my worksheets. Isn't there any way to set the default paste option to "match destination formatting" or am I forced to go through the extra step every time I copy and paste? |
All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com