Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copy/Paste

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Copy/Paste

Resolved · Low Priority · Version 2003

Reply 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)?

For upcoming training course dates see: Pricing & availability

Reply 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

Reply 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!

Reply 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

Reply Tue 11 Oct 2011, 12:43Delegate Elise said...

RE: Copy/Paste

Thank you

Excel articles

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How Excel Can Help You See Into Your Business's Future
· How Getting Together Is Now Even Easier With Excel
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· Make A Custom Sort List In Excel

Please browse our web site to find out more about
introduction excel training and other Microsoft training courses.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips