LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy
 
Posts: n/a
Default paste options - set default to match destination formatting

Hi,
Is it possible to set the default paste option to "match destination
formatting" so I don't have to go through paste options each time?

Same with using autofill - can I set the default to "fill without formatting"?

Also, occasionally the paste options don't come up properly - after I paste
something the paste options icon pops up but the arrow next to it isn't there
and I can't click on it to access the paste options. This only happens
occasionally and seems to usually happen when the pasted section is next to
the edge of the screen.

Thanks,
Amy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste in "match destination format" macro code Hopelesslylost Excel Discussion (Misc queries) 2 June 18th 06 01:58 PM
Excel should allow more options for formatting cells rj123 Excel Worksheet Functions 0 July 23rd 05 03:45 AM
Pivot Table - Default Settings for Table Options Nacho Excel Discussion (Misc queries) 0 February 25th 05 06:05 PM
Make "Match Destination Format" the default ethan0818 Excel Discussion (Misc queries) 2 February 11th 05 02:33 PM
excel - numbers as text Thuferhawat New Users to Excel 12 January 24th 05 09:29 PM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"