ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I set the default paste option? (https://www.excelbanter.com/setting-up-configuration-excel/58058-how-do-i-set-default-paste-option.html)

Forester

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