Excel - How to Match Destination Format always  | | |
July 3rd, 2008, 09:53 PM
|
#1 (permalink)
| | Per aspera ad astra!
Join Date: May 1999 Location: USA
Posts: 10,950
| Excel - How to Match Destination Format always
Excel Gurus - I need you.
Pasting new data into a spreadsheet brings up the Paste Options icon to either Keep Source Formatting, or Match Destination Formatting.
How do I universally apply to the spreadsheet so that pasting new data automatically or always matches destination formatting?
Only need on a per worksheet basis (not for a default template).
Thanks!
__________________ |
| |
July 5th, 2008, 05:59 PM
|
#2 (permalink)
| | Per aspera ad astra!
Join Date: May 1999 Location: USA
Posts: 10,950
|
No way to accomplish this? :/ |
| |
July 5th, 2008, 06:03 PM
|
#3 (permalink)
| | Not Really a Member
Join Date: Oct 2001
Posts: 25,384
|
Hmm is this Excel 2003, or 2007?
I've seen that option, and found it quite annoying
give me a bit (possibly Monday) and I'll see what I can figure out
If anybody else has ideas, send 'em  |
| |
July 5th, 2008, 06:53 PM
|
#4 (permalink)
| | Per aspera ad astra!
Join Date: May 1999 Location: USA
Posts: 10,950
|
vass  thanks - I appreciate your effort.
Excel 2003
I did find a "workaround" that involved creating a macro, but that's still a PITA to hit a button every time.. not much of an improvement. |
| |
July 5th, 2008, 08:31 PM
|
#5 (permalink)
| | Not Really a Member
Join Date: Oct 2001
Posts: 25,384
|
does this do it? Topics: Turning Off Paste Options Quote:
Choose Options from the Tools menu. Excel displays the Options dialog box.
Make sure the Edit tab is displayed. (Click here to see a related figure.)
Clear the Show Paste Options Buttons check box.
Click on OK.
| |
| |
July 5th, 2008, 09:16 PM
|
#6 (permalink)
| | Per aspera ad astra!
Join Date: May 1999 Location: USA
Posts: 10,950
|
Nope :/
That only disables the Paste Options button from appearing while keeping the source formatting intact; it does not cause what I want to happen, which is to automatically *always match destination format* (i.e., without the paste option button).
Thanks, though  |
| |
July 5th, 2008, 10:37 PM
|
#7 (permalink)
| | Not Really a Member
Join Date: Oct 2001
Posts: 25,384
| |
| |
July 5th, 2008, 10:37 PM
|
#8 (permalink)
| | Not Really a Member
Join Date: Oct 2001
Posts: 25,384
|
does Paste Special --> Values do what you want?
Thats not exactly removing a step though :-/
Last edited by vass0922 : July 5th, 2008 at 10:49 PM.
|
| |
July 6th, 2008, 01:34 PM
|
#9 (permalink)
| | Per aspera ad astra!
Join Date: May 1999 Location: USA
Posts: 10,950
|
thanks for the help, vass
I'll try recording a macro using Ctrl + V as the shortcut.
Yeah, how great that they have that option in 2007  Maybe I can find a TS seminar to get it gratis  |
| |
September 14th, 2008, 08:00 PM
|
#10 (permalink)
| | Junior Member
Join Date: Sep 2008
Posts: 1
| Cut/n/Paste nightmare
Oh this is SOOOOOOOO frustrating....
What happened? What friggin genius (ha) thought this would be a good idea? |
| | | Thread Tools | Search this Thread | | | | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Most Active Discussions | | | | | Recent Discussions  | | | | | |