The features in Excel for iPad.
Here’s a look at the major features in Excel for iPad, looking over the five main tabs. The buttons will be familiar in most cases, though the underlying menus/galleries are different and limited compared to Excel for Windows or Mac.
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.
Below each image is a list of the buttons / menus from left to right.
Home
Font
Font Size
Bold, Italic, Underline (one only)
Cell Borders: No, All, Outside, Thick Box, Bottom, Top, Left, Right
Cell Background Color
Font Color
Justify: Left, Center, Right, Top, Middle, Bottom
Merge and Center cells
Cell Formatting: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special
Cell Styles
Insert & Delete Cells: Shift Cells down, Shift Cells Right, Insert Sheet Rows, Insert Sheet Columns
Delete Cells: Shift Cells down, Shift Cells Right, Delete Sheet Rows, Delete Sheet Columns
Sort and Filter: Ascending, Descending, Filter
Insert
Table
Recommended
Charts
Pictures
Shapes
Text Box
Formulas
Many Excel functions are available, listed under the buttons on the Formulas tab. You can also click on the Formula Bar, press the = (Equals) key and start typing a formula, just like in Excel. As you type, function names will appear to autocomplete your typing.
See also the Formulas Keyboard – a special Excel keyboard to make entering/editing formulas easier.
AutoSum: Sum, Average, Count, Max, Min
Recent: recently used functions
Financial
Logical
Text
Date & Time
Lookup & Reference
Math & Trig
More Functions: Statistical, Engineering, Info, Database
Recalc: force a recalculation of the worksheet
Review
Previous comment
Next comment
Show comment
Show all
Delete
View
Formula Bar
Sheet Tabs
Headings
Gridlines
Freeze Panes: Panes, Top row, First column
