Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007

Excel 2007

ResolvedVersion 2007

Wed 8 Jul 2009, 16:03 Delegate Debra said...

Debra has attended:
Excel Introduction course

Excel 2007

How do you copy formulas into a separate worksheet?

Wed 8 Jul 2009, 16:51 Trainer Andrew said...

RE: Excel 2007

Hi Debra

Thank you for your question. You can copy any formula (click on the cell containing the formula and click on Home tab > Clipboard group > copy) then switch to your destination sheet and cell and from the same group on the ribbon click paste.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Wed 15 Jul 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Excel 2007

Excel 2007

RE: Excel 2007

Excel articles

Excel tip:

Quickly create a list of numbers