excel

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

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

Excel

resolvedResolved · Low Priority · Version 2003

Jackie has attended:
Excel Advanced course

Excel

how do you copy a formula

RE: excel

Hi Jackie

Thanks for the post - sorry for our delay in replying

there are a couple of ways to copy formulas first way

click the cell you want to copy - go to the bottom righthand corner of that cell and click and drag the cell NB: make sure your pointer is a little black cross before you click and drag

the other way is copy and paste special the cell from the edit menu - click formula's then click OK

This will allow you to copy formula's

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn


 

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


Server loaded in 0.09 secs.