excel computer course london - displaying formulas

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 computer course london - Displaying formulas

excel computer course london - Displaying formulas

resolvedResolved · Low Priority · Version Standard

Rebecca has attended:
Excel Intermediate course
Excel Advanced course

Displaying formulas

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

RE: Displaying formulas

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.


 

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips


Server loaded in 0.09 secs.