Skip to content

Excel for iPad - Formula Keyboard

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

About this author