Worksheets

The UK's most regular instructor-led training courses.
Training information: excel training · Excel training courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Worksheets

Sophie has attended:
Excel Introduction course

by - delegate Sophie [1 post] (2008 Jun 25 Wed, 15:55) Reply

How do you copy information from one worksheet to a new one with out the format being changed?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Worksheets

by - trainer Pete platinum contributer [868 posts] (2008 Jul 10 Thu, 12:11) Reply

HI Sophie, Thank you for your post and welcome to the forum,

In answer to your question, if you are finding that the format is changing when you paste from one workbook to another you should confirm that your Paste special dialog box has not been changed to cause this.

Copy a piece of data with specific formatting and then navigate to your new workbook, instead of just pasting it go to Edit>Paste Special and ensure that the All radio button is selected.

If it is selected you should check that your version of Excel has been correctly and fully installed, Excel is totally compatible with itself and should not experience any problems similar to the one you have described.

I hope that has helped, regards Pete

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Basic Excel Training
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Advanced Excel and PivotTable Reports
· Creating Charts with Excel

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

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Rate this page: