Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Office general help » Excel 2007

	98.1 % recommend us
	More live stats...

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel 2007

Resolved · Low Priority · Version 2007

Reply Wed 21 Jan 2009, 16:19Delegate Claire said...

Claire has attended:
Upgrade to Office 2007 course

Excel 2007

How do I copy formula from one book to the next?

For upcoming training course dates see: Pricing & availability

Reply Fri 23 Jan 2009, 16:52Trainer Mark said...

RE: Excel 2007

Hi Claire

Thanks for your post

The way to do this is by using a copy paste special procedure as follows: copy the cells you want to copy then copy - from there go to the workbook you need them in then click the cell and go to the edit paste special then click formulas and click OK if you need anymore help on this reply to this post

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Fri 30 Jan 2009: Automatically marked as resolved.

Microsoft Office articles

· The Microsoft Office Relay Team
· How To Keep On The Move With Office
· The Diversity Of Microsoft Office
· When does your training become a consultancy requirement?
· Office Applications: A Star Turn From Each

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

Microsoft office tip:

Copying From Websites

If you find some interesting text on a website that you wish to use and adapt in your wordprocessor or other package, highlight and copy in the normal way first.

When you paste though, use the Paste Special option to insert as unformatted text. That cuts out all the fancy formatting and hyperlinks that may be embedded.

View all Microsoft Office hints and tips