excel computer course london - Displaying formulas

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

Resolved · Low Priority · Version Standard

Displaying formulas

Rebecca has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Rebecca [1 post] (2007 Nov 13 Tue, 17:09) Reply

How do I display a formula in a cell as opposed to the formula bar

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Displaying formulas

by - trainer Pete platinum contributer [867 posts] (2007 Nov 14 Wed, 09:37) Reply

Hi Rebecca, Thank you for your post, I hope you enjoyed the Excel Intermediate Course. In answer to your question.
To display all formulas in a Worksheet you can use the toggle button combination (Toggle on and off) CTRL+Pipe key (the pipe key is found immediatly above the Tab key next to the number 1 key.)
If you just want to display the formula in the selected cell then try a double click on the cell, this will open the cell in Edit mode and display the formula. Hope that answers your post. Pete.

· Fun Things I've Done With Excel
· Microsoft Excel Training: Essential for Today's Employees
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Customized Financial Excel Courses in London
· Creating Charts with Excel

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Rate this page: