98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copy/Paste
Copy/Paste
Resolved · Low Priority · Version 2003
Tue 11 Oct 2011, 11:32Delegate Elise said...
Elise has attended:
Project Introduction course
Copy/Paste
When copying & pasting a row of data from one spreadsheet to another, how do I ensure that the format of the cells remains exactly the same (size of writing & size of cells)?
Tue 11 Oct 2011, 12:13Trainer Mark said...
RE: Copy/Paste
Hello Elise,
After you copy a range, use the paste Special option, by right clicking where the copied data should go, select Paste Special. There should be options to paste the column width/formatting. Try some of these options to see which gives the best. In Later versions, 2007 and 2010 there is a direct option for pasting all formatting.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Tue 11 Oct 2011, 12:28Delegate Elise said...
RE: Copy/Paste
Sorry Mark, I'm still stuck.
I have tried selecting a variety of options from the Paste Special selection & none are working.
I have tried "Columns", "Formats", both together too (which doesn't actually paste anything across?)
Please help!
Tue 11 Oct 2011, 12:34Trainer Mark said...
RE: Copy/Paste
Hello Elise,
If you copy a range, move to new sheet and do a regular paste (control+V), this pastes the data and format, you will see a smart tag appear beside the pasted range. Click this and select the option to Keep Column Widths.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving or Copying Sheets Between Workbooks in Excel 2010Here's how to move or copy sheets between workbooks in Excel 2010: |
