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 » Excel

Excel

ResolvedVersion 2003

Wed 6 Aug 2008, 16:12 Delegate Natalie said...

Natalie has attended:
Excel Intermediate course

Excel

How do I cjange formulas in to values?

Fri 8 Aug 2008, 08:35 Trainer Pete said...

RE: excel

Hi Natalie,
Welcome to the forum, and thank you for your post. To answer your question:

1. Select the cells containing the formulas that you wish to adjust...
2. Copy the contents (CTRL+C)
3. Go To Menu command Edit>Paste Special
4. Choose Option Values and click OK
I hope that helped, regards Pete

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: excel

Excel articles

Excel tip:

Create a unique items table from a duplicating table