Steve Kraynak
Microsoft
‎04-14-2017 03:53 PM

What's New in Excel 2.0 for iPhone and iPad

‎04-14-2017 03:53 PM

Hi Excel Fans,

On April 10, 2017, Microsoft released a new version of Excel for iOS that’s a significant update, as indicated by the version number, which is 2.0! Having a consistent experience in Excel regardless of which type of device you’re using is something we’re striving for, whether you’re using an iPad or an iPhone, an Android phone or tablet, or a Windows mobile device, and it begins now. 

 

We’re happy to announce some very important new features in this version of Excel.  Some were mentioned in the “What's New” message that appears when you launch the new version for the first time, but there’s even more to tell you about. Read on for more details about the many new features now at your fingertips. As always, we encourage you to visit Excel.uservoice.com to request and vote for other features that you’d like to see in Excel for iPhone and iPad.

 

The major new features are:

  1. Collaborative editing - Work with others at the same time in your workbook, also known as “co-authoring”. That's right, you can now edit a workbook at the same time with other people for files stored in SharePoint Online, OneDrive and OneDrive for Business.  Amazing!

 

  1. Shared document notifications - Now you don't need to keep checking your shared documents, workbooks, or presentations. We will send you a notification on your iPhone or iPad when there's activity.

 

  1. New types of charts - Now you can view, create and edit new types of charts, including Waterfall, Histogram, Box & Whisker, Pareto, Treemap, Funnel, and Sunburst to visualize your data in the most effective ways.
    Picture1.png

 

  1. New worksheet functions - Shorten the formulas you write using the new logical functions IFS() and SWITCH(). Read more about IFS and SWITCH on the Office blog.

 

 

In addition to the major features mentioned above, there are numerous other features that are new to Excel on iOS.  Here are the highlights:

 

  1. In-cell editing - You can edit right in the cell, so you no longer need to switch your focus to the formula bar when editing.
    image003.png

  2. Functions organized by category - When inserting a function by tapping the Fx button, it is easier to find the right function, because they're grouped in categories rather than one very long list.image005.png

     

  1. "Find" will now find text within formulas, not just cell values.

 

  1. More cell border options - there are more built-in border styles to choose from. You can also choose the line color and line style.image007.png

     

  1. Easier to insert hyperlinks - you can now insert links by tapping a button on the Insert tab, and keep the display value that was already in the cell. Previously, you had to type the link address into the cell first, then edit the display value if you wanted to show something other than the link address.

 

  1. Fill in any direction – you can now drag-fill in any direction and there's a tooltip with a preview of the values that will fill into the new cells. Previously, you could only fill down or to the right.
    image009.png

     

     

  2. Table insert options - when you insert a table using existing data, you can choose whether to use the first row as the column headers.image011.png

     

  3. Filter improvement - you can now search to find values in in filters. If you have a long list of filter values, just type what you’re looking for in the Search field and you’ll find it in the list.image013.png

     

     

  1. Drag and drop to move rows and columns - just tap and hold on a row or column header, then drag to move it.image015.png

     

  1. Autocomplete improvements - When editing, you'll be given autocomplete suggestions sooner to make editing faster.

 

 

We think it's great that we've been able to add all the features mentioned above, but we realize that some changes may not have a good impact on how you use Excel.  There may be some things that work a bit differently than what you’ve come to expect, and there may be a few buttons or options found in different places. Unfortunately, we had reason to stop supporting some features, even though we tried very hard to avoid doing so. We realize that this can have an impact on how you use Excel on iOS, and we don’t take it lightly.  One such change is that Excel now requires the use of our online service to perform a few actions, such as printing, exporting files to PDF format, and opening workbooks saved in the legacy “XLS” file format.  We realize that performing these actions directly on your device is a very nice convenience, but using an online service offers several advantages, most notably a consistent experience for all types of devices.

 

We’ll be listening carefully for feedback so that we can make things better, and you can help. Tell us what's important to you, so we can improve Excel in ways that really matter.  Please use the “Send Feedback” button and send us your thoughts and concerns.

 

image017.png 

For information about What's New in the latest release for Excel on iOS and other platforms, as well as all the Microsoft Office applications, go to Office.com.  Again, please visit Excel.uservoice.com to make your voice heard in the conversation about what features you hope to see next.

 

Thanks!

5 Comments
Sam Zhang
Visitor

2.0 seem to have complete broken on iOS, working spread sheet anything bigger than 100kb is nearly impossible, and that's on an iPad pro, and opening an user template has simple been instant crash. I need this app for work every single day, please fix ASAP, or maybe just allow users to revert to the last version. I've been having to use Numbers the last few days and I want excel back!!!

Steve Kraynak
Microsoft

Hi Sam - There was an issue with version 2.0 that was fixed in version 2.0.1 which was released last week. Please install the update and respond back to say whether it resolves the issue.

Sam Zhang
Visitor

 I did have the 2.0.1 (170412) build, and it was just as "crashy", I did find the main cause to be hidden rows and colums. When I unhide them on the desktop version and reopen them in iOS, the seem to be much more stable, but there are still occasional unexplained crashes, especially when opening .xltx files.

 

Also, why is internet require to generate a PDF from the worksheet. Generating PDFs and sharing them with other apps and devices while offline is a cruical part of my workflow, seems like a huge downgrade from 1.31

 

other minor complains:

 

Double tapping a cell does not highlight its contents to be overwritten. In 1.31 cells with calculated values could be quickly overwritten by double tapping and entering in new values. Now the process requires either deleting the entire formula, or double tapping to bring up the keyboard, then tap elsewhere, and then tap back to the desired cell and overwrite with the "new" in cell editing function. 

-  Please add a option to hightlight the entire cell content with a double tap 

 

PDF generation and Print layout options selections are not saved. Having to select orienation and scaling options each time I want to generate a PDF is a pain, another function present in 1.31

-  Please save the previsouly selected layout options selections so future prints and PDF generation are defaulted to the previously slected options

 

Please either just give us 1.31 back, or fix these issues ASAP!

Jake Swoboda
Occasional Visitor

Is the wrap text function in a different place than before? It no longer shows up as the last option when highlighting the cell.

Steve Kraynak
Microsoft

Hi Jake - the "wrap text" has been moved to the ribbon and you can find it under the cell Alignment button in the Home tab.