home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Applications and Operating Systems
Join TechIMO for Free!
Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply Get bargains at  »  Dealighted.com
 
Thread Tools Search this Thread
Currently Active Users: 1517
Discussions: 182,844, Posts: 2,184,648, Members: 225,644
Old July 3rd, 2008, 08:53 PM   Digg it!   #1 (permalink)
Cerca, trova
 
Socalgal's Avatar
 
Join Date: May 1999
Location: USA
Posts: 10,615
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!
__________________

Sign by Dealighted - Coupons & Discount Shopping


Socalgal is offline   Reply With Quote
TechIMO.com Ads - Login or register for less ads.


Guest, Register Free! to remove this ad and get your tech support questions answered in minutes!
Old July 5th, 2008, 04:59 PM     #2 (permalink)
Cerca, trova
 
Socalgal's Avatar
 
Join Date: May 1999
Location: USA
Posts: 10,615
No way to accomplish this? :/

Socalgal is offline   Reply With Quote
Old July 5th, 2008, 05:03 PM     #3 (permalink)
In DC Hell
 
Join Date: Oct 2001
Posts: 19,195
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

vass0922 is online now   Reply With Quote
Old July 5th, 2008, 05:53 PM     #4 (permalink)
Cerca, trova
 
Socalgal's Avatar
 
Join Date: May 1999
Location: USA
Posts: 10,615
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.
Socalgal is offline   Reply With Quote
Old July 5th, 2008, 07:31 PM     #5 (permalink)
In DC Hell
 
Join Date: Oct 2001
Posts: 19,195
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.
vass0922 is online now   Reply With Quote
Old July 5th, 2008, 08:16 PM     #6 (permalink)
Cerca, trova
 
Socalgal's Avatar
 
Join Date: May 1999
Location: USA
Posts: 10,615
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
Socalgal is offline   Reply With Quote
Old July 5th, 2008, 09:37 PM     #7 (permalink)
In DC Hell
 
Join Date: Oct 2001
Posts: 19,195
doesn't seem to be possible

here is one option
OpenOffice.org Forum :: Paste as unformatted text by default?

Not sure if its what you're looking for though

seems to be a new feature in Excel 2007
Set your own default Paste options with Word 2007 | Microsoft Office | TechRepublic.com
vass0922 is online now   Reply With Quote
Old July 5th, 2008, 09:37 PM     #8 (permalink)
In DC Hell
 
Join Date: Oct 2001
Posts: 19,195
does Paste Special --> Values do what you want?

Thats not exactly removing a step though :-/

Last edited by vass0922 : July 5th, 2008 at 09:49 PM.
vass0922 is online now   Reply With Quote
Old July 6th, 2008, 12:34 PM     #9 (permalink)
Cerca, trova
 
Socalgal's Avatar
 
Join Date: May 1999
Location: USA
Posts: 10,615
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
Socalgal is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Able to Export the Access Report to Excel, but not in the desired format. ShameerG Applications and Operating Systems 1 January 9th, 2008 10:34 AM
Excel Format Question ZeR0 Applications and Operating Systems 2 December 18th, 2006 08:08 AM
Excel help!! I fight Excel & Excel wins!!!!!!!!! Dooin' it Applications and Operating Systems 4 March 23rd, 2005 08:35 PM
Honeymoon destination help ILC IMO Community 24 June 15th, 2004 05:10 PM
dsl destination not reachable jdbic Networking and Internet 3 July 29th, 2003 11:37 PM

Most Active Discussions
Alaska Gov. Sarah Palin Is McCain's.. (97)
Is It Just Me? (10313)
Finally!! "Male enhancement sn.. (21)
Built a new PC, Getting Boot Failur.. (6)
Damn the Constitution, guns should .. (98)
Samsung T220 22" monitor not w.. (7)
Recent Discussions
Official World of Warcraft Thre.. (4023)
Abit VA-10 (0)
Logitech's G25 compatible games.. (5)
Budget vid card recommendations (1)
search items (0)
GeForce 6800 GT PCI-e fails to .. (2)
FolderChat: 8/28 - 3 day weeken.. (8)
trouble playing Blu-ray through.. (3)
PC doesn't boot, win xp doesn't.. (6)
FS: IBM t42 laptop, Dell 6000 n.. (1)
Alienware PC (0)
GIGABYTE GA-EP45T-DS3R,& C2.. (0)


All times are GMT -4. The time now is 10:17 PM.
TechIMO Copyright 2008 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28