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.

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

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%201.png image from Excel for iPad - a tour at Office-Watch.com

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

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%202.png image from Excel for iPad - a tour at Office-Watch.com

Table

Recommended

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.

This 670 page book shows you important features and details for all serious Windows 10 users.

Charts

Pictures

Shapes

Text Box


Formulas

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%203.png image from Excel for iPad - a tour at Office-Watch.com

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

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%204.png image from Excel for iPad - a tour at Office-Watch.com

Previous comment

Next comment

Show comment

Show all

Delete


View

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%205.png image from Excel for iPad - a tour at Office-Watch.com

Formula Bar

Sheet Tabs

Headings

Gridlines

Freeze Panes: Panes, Top row, First column