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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Formula

ResolvedVersion 2003

Mon 30 Jun 2008, 15:20 Delegate Vanisha said...

Vanisha has attended:
Excel Introduction course

Formula

how do i copy formulas onto a different spreadsheet

Tue 1 Jul 2008, 10:54 Trainer Carlos said...

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 tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Formula

Formula

RE: Formula

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet