Formulas

The UK's most regular instructor-led training courses.
Training information: excel vba courses · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formulas

Diane has attended:
Excel Introduction course

by - delegate Diane [1 post] (2008 Mar 26 Wed, 16:59) Reply

How do you clear a formula that has been entered previously, not allowing you to enter your own?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Formulas

by - trainer Rich platinum contributer [744 posts] (2008 Mar 26 Wed, 20:38) Reply

Hello

You should be able to click in the cell with the formula and the formula will show in the formula bar above all the cells. Delete the formula here. You should then be able to enter your own formula

regards

· Fun Things I've Done With Excel
· Excel and Inventory Management
· Advanced level training: Microsoft Excel and the Web
· MS Excel: Excel At Making The Most Of Your Christmas
· What's Better Than the Help Function in Excel? Microsoft Training

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

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