formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Formula

resolvedResolved · Low Priority · Version 2003

Vanisha has attended:
Excel Introduction course

Formula

how do i copy formulas onto a different spreadsheet

RE: Formula

Hi Vanisha

You copy formulas the same way as any other values.

If you copy a cell containing a formula when you paste the cell at its destination the formula will be pasted.

This means that the formula may cause errors if the cells required to complete the calculation in the formula are empty or contain the wrong values.

If when copying a formula you use Paste Special / Paste Values the value of the original formula is pasted in place of the formula

Hope this helps

Carlos


 

Excel articles

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

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.11 secs.