Excel for iPad – Formula Keyboard


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

A close look at the new Formula Keyboard in Excel for iPad.

One of the highlighted innovations in Excel for iPad is a dedicated Formula Keyboard which looks like this:

http://img.office-watch.com/ow/Excel%20for%20iPad%20special%20keyboard.png image from Excel for iPad - Formula Keyboard at Office-Watch.com

It’s necessary because none of the supplied iPad virtual keyboards work well when you’re trying to enter Excel formula. Hunting and pecking around different symbol keyboards gets tired very fast.

Shameless plug:
Office for iPad: The Complete Guide is now available.  Every tab, ribbon and menu in the detail that Microsoft’s own documentation/help misses out.  Only $4.95 for Office-Watch.com readers and available to read today.  Click here.

 

Click on the ‘123’ button at top right to switch to the formula keyboard and ‘Abc’ to return to the standard keyboard.

This dedicated keyboard has a few trick beyond the obvious keys for brackets, comma, colon, percentage, arrows and the numbers.

Five keys have little green marks on the top right corner. Hold down any of these keys to see more, related, symbols.

For example, hold down the $ sign to enter cents, Yen/Renminbi, Euro, Pound and Won symbols

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20Formula%20Bar%202.png image from Excel for iPad - Formula Keyboard at Office-Watch.com

‘Under’ the round brackets are square and curly brackets.

The comma button has the semi-colon underneath it.

The colon button also has the @ and # symbols available.

Entering formula is much like in Excel for Windows or Mac. Press = then a list of common formula will appear or type in the name of the function you want. The function will appear and you can point to cells to enter them into the formula. The formula bar fills in with color coding to match the cells highlighted in the worksheet.

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20Formula%20Bar%203.png image from Excel for iPad - Formula Keyboard at Office-Watch.com

subs profile e1563205311409 - Excel for iPad - Formula Keyboard
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address