Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer course london - Formulas
excel computer course london - Formulas
Resolved · Low Priority · Version Standard
Lan has attended:
Excel Intermediate course
Powerpoint Intermediate Advanced course
Formulas
how do i display formulas in cells as opposied to the fomula bar
For upcoming training course dates see: Pricing & availability
RE: Formulas
Hi Lan, Thank you for your post, I hope you have enjoyed the courses that you have attended with Best Training. 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.
|
