Excel 2007

Resolved · Low Priority · Version 2007

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

Claire has attended:
Upgrade to Office 2007 course

Excel 2007

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

Fri 23 Jan 2009, 16:52 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Renaming or Deleting Files when Saving or Opening

You can rename and delete files any time you are using a FILE > OPEN or a FILE > SAVE dialog box.
When you see the list of files when browsing in the current folder, you can treat is just like the windows explorer window, by selecting and then editing.

To rename, just give the file a single click to select, then a second to enter the file name. Type the name you want, and press enter.

To delete, a single click and hit the delete key.

View all Microsoft Office hints and tips