excel training class - excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - How to show a formula in Excel

excel training class - How to show a formula in Excel

resolvedResolved · Low Priority · Version Standard

replyReply Wed 16 May 2007, 12:02Delegate Melanie said...

Melanie has attended:
Excel Intermediate course

How to show a formula in Excel

How do I show the formulas?

For upcoming training course dates see: Pricing & availability

replyReply Thu 17 May 2007, 09:38Trainer Amanda said...

RE: Excel

Hi Melaine

Thanks for your question.

You can show formulas in a spreadsheet by holding down the Ctrl key and pressing the pipe key at the same time. The pipe key is below the Esc key, to the left of the '1' key and above the Tab key on most keyboards.

Amanda

 

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard