You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
About a month ago, we announced that Excel Web App and the Office Web Apps are destined to become a comprehensive productivity experience on more browsers and devices (not just companions to the desktop applications). We didn't give any specific timelines as part of that, but last week we released our first feature update since that announcement. I'm excited to share some of the awesome new things you can do in Excel Web App now in both SkyDrive and Office365, and I’ll give a peek at some of what we've got coming in future updates!
If there's one underlying theme that I hope everyone reading this notices is that we've been watching and listening to our various support channels (like the Web Excel group over at answers.microsoft.com and the Give Feedback file menu item) and we’ve added some of the most requested features to the application. I'll touch on a few of them here, but I wholeheartedly recommend that you try the new Excel Web App today to get a sense for yourself for how great it is.
Also - if you are interested in trying this yourself, you can give it a shot here: June 2013 Web Excel Update Demo.xlsx (you’ll need to copy the workbook to your own SkyDrive and view it in edit mode to see some of the features)
Freeze Panes has been our most requested feature for quite a while, and we now support viewing workbooks that contain freeze panes. 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.
Figure 1: Freeze Panes in Excel Web App
Header Row Snapping is similar to freeze panes, in that it allows you to more easily work with tabular data. With it, if you create a Table out of your data (on the Home ribbon, choose "Sort and Filter as Table"), and then scroll down, the Table headers and the ability to Sort/Filter will move up into the sheet headers, so you always know what's going on with your data.
Figure 2: Header Row Snapping in Excel Web App
Even with these improvements, we know that not everyone uses Tables in Excel, but that it's still important to Sort data that's not in a table - so now you can do that by selecting any range of data and clicking on the Sort commands on the Home ribbon.
Figure 3: Sort in Excel Web App
Hiding and unhiding sheets is something that's been missing from Excel Web App up until now, but no longer. Right click on sheet tabs to hide or unhide them, just like Excel.
Figure 4: Hiding and Unhiding sheets in Excel Web App
We've also heard the feedback that you want to enter data more easily into your spreadsheets. As such, we've introduced support for both Data Validation and Autocomplete with this update. 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!
Figure 5: Data Validation in Excel Web App.
Figure 6: Autocomplete in Excel Web App
And, last but not least, we added the ability to quickly clear any formatting or content applied to a cell or range. This can be a lifesaver when you're copying data from other places, and you want to get the data to look right in the context of your spreadsheet.
I think you'll agree that the improvements we've looked at so far are great ones for Excel Web App. But we're not done - not by a long shot. We've got a lot more in the pipeline, and in the coming months you'll see us release even more of the features that you've come to love in desktop Excel, as well as some you may not have even realized existed. We'll get started by letting you create freeze panes and data validation, but that's just a taste of what's coming - there's much more I haven't even mentioned that will make Excel Web App the place that you'll want to work on your spreadsheets online.
Don't forget to grab the sample workbook: June 2013 Web Excel Update Demo.xlsx, and as always, we love to hear what you think - let us know in the comments section, and have fun using the new release of Excel Web App!
--Dan Battagin, Program Manager, Excel Team
I can't tell you how much help this site is,
I'm not quite sure how to post a question?
I have a question relating to Excel 2010 and I have created a pivot chart from a pivot table. That shows all our products in a filter/selection box at the top, with period rows = periods and the sales rev p the columns (I have a secondary graph in there to which shows our MAT line for that product). I tried to add a snapshot/print screen (snag it) but I can't. I'd like to know how I can make the Model number selected model family selected in the top filter list to be displayed on the graph too, so it is visible at a quick glance which model that graph is for at any particular time. Is that possible please?
When I integrated an excel spreadsheet via Web App in the blog, I noticed that if you do not allow users to download the file it is still possible to download it if you:
1) click to open in full screen
2) click on the skydrive name folder in the left upper corner of the screen
3) voila! the file is available for download for any user
Please correct it or explain me how can I prohibit users from downloading the file that way.
Thank you very much for adding "Freeze panes". That was a huge one for me.
It looks it must be set in Desktop Excel and can't be accessed or controlled in the Web app. Is that right?
For Excel Surveys, would really like to be able to include "hidden" values in the output, such as a survey key or item key. That way I would be able to track a response and link it with an email invitation that I may have sent earlier. The company I work for currently uses SurveyMonkey because it has this ability.
If/When will you be providing support for smart-art and charts. I am currently using the share feature to allow our clients to use an excel spreadsheet to customize their product. We also use the organizational chart feature to organize their organization's departments.
However, we cannot send out a request for them to edit this spreadsheet without first taking a screenshot and pasting it into the spreadsheet which obviously does not allow them to edit the chart.
I would really like to know if the ability to edit these charts is on the horizon or not.