Copying

Resolved · Low Priority · Version 2003

Wed 21 May 2008, 15:43 Delegate Kerry said...

Kerry has attended:
Excel Introduction course

Copying

when you copy a spreadsheet on to a new page does it carry over the formulas

Wed 21 May 2008, 16:07 Trainer Katie said...

RE: copying formula

Hi Kerry,

I hope you have enjoyed your training. Thank you for your question.

Formula structures can be copied across to a different worksheet and files. But it is important to ensure the references are still valid on the destination worksheet.

For example, a formula in cell C1 reading =A1+B1 cannot be copied then pasted on cell A1 of a different worksheet. You will not get a valid answer as there are no cells to the left for any calculation.

Hope you find this useful.

Kind regards,

Katie (Microsoft Certified Trainer)

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips