While we wait for Microsoft to add the promised real time co-authoring features to its free Office Web Apps, it has been busy adding new functions to the Excel Web App. This week, Microsoft revealed several new features that it had added to the free browser-based spreadsheet program.
In a post on the Office blog, Microsoft said the most requested features from users was adding freeze frames to the Excel Web App and now it has the ability to view workbooks that have freeze panes. Microsoft states, "That means you can see all of those column headings at the top of your sheet all the time, as opposed to scrolling up and down as you've done in the past."
The new version also adds a way to sort data that's not in a table by clicking on the Sort commands on the Home ribbon, along with right clicking on sheet tabs to hide or unhide them. The Excel Web App adds support for Data Validation and Autocomplete in this update. Microsoft says:
Data Validation works just as you'd expect (like Excel) in that it provides a list of valid values a user can enter into a cell. And, we took Autocomplete a step further than desktop Excel - not only does it complete what you're typing, but if you start typing and there's more than one possible match, we'll show you the whole list that you can pick from!
Finally, the app now allows users to clear any formatting or content that's put into to a cell or range. Microsoft says we can expect a lot of other new features to be added to Excel Web App in the coming months.
Source: Office blog | Image via Microsoft