Excel for iPad – a tour
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.
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.
Bold, Italic, Underline (one only)
Cell Borders: No, All, Outside, Thick Box, Bottom, Top, Left, Right
Cell Background 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
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
Windows 10 from people 'in the know'
A detailed and independent look at Windows 10, especially written for the many people who use Microsoft Office.
Fully up-to-date with coverage of the Anniversary 2016 major update of Windows 10.
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
Date & Time
Lookup & Reference
Math & Trig
More Functions: Statistical, Engineering, Info, Database
Recalc: force a recalculation of the worksheet
Freeze Panes: Panes, Top row, First column
- Office for iPad, September updates
- Office for iPad update April 2014
- Office for iPad can print – sort of
- Word for iPad – a tour
- Office for iPad – the preview look