FIX OR PRESERVE THE FORMATING

In Excel 7 I have a spreadsheet set up. I bring in rows of data and paste them. They mess up my formatting; test size, font & location, row and column dimensions. Is there a way to fix the formatting so it doesn't change when I paste?

Thanks,

Bob
pubbuddyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jimyXConnect With a Mentor Commented:
When you paste right click and select Paste special then select Values and OK.
0
 
thepcwizardCommented:
Try Paste Special, Unformatted Text.
0
 
pubbuddyAuthor Commented:
Try Paste Special, Unformatted Text.  Your answer admits there is no way to cause the formating to be immune to, incoming, pasted formatting. it is so hard for me to believe it hasn't given other users problems.
That won't work because I have to do a, "Paste, Transform.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
jimyXCommented:
Did you try Paste Special - Values?
0
 
thepcwizardCommented:
Are you running office 95 Excel 7.0, or 2007?
0
 
pubbuddyAuthor Commented:
Copy and Paste will not work because I have to do Copy & Transpose. They won't work together..
0
 
thepcwizardCommented:
In Excel 2002 (aka XP) under paste special, there is a check box for transpose.
So it allows me to paste values and also do a transpose.

If you let me know what version of Excel you are using, I can better answer you question.
I'm guessing you have an older version of Excel.
0
 
thepcwizardConnect With a Mentor Commented:
The easiest way to get to paste special is to right click on the first cell where you want to paste your vailes.  Paste Special is an option in all version of Excel that I have access to - 2000, 2002, 2007 and 2010.

I just checked, and Excel 2000 and 2007 are the same as 2002 - Paste Special has a transform check box.

In Excel 2010, you would do paste special, and then paste special again.  The transpose check box is available.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
jimyXCommented:
In my post #35157300, I have suggested to the author to use the method that works OK, but it seems that the author did not see my one-line comments.
0
 
thepcwizardCommented:
I posted detailed information that explained in depth how to accomplish the task.
With the information originally given, the answer was availble, and if not, further assistance was offered to help resolve the issue.
0
 
ModalotEE ModeratorCommented:
After Moderator review there seems to be a better disposition, as recommended by the contributing Experts.

Modalot
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.