Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
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
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
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.