Microsoft Announces Status Bar Aggregates, Drag & Drop Cells And More For Excel Web App

0

Excel Web App Feature

Along with the announcement about real-time co-authoring in Office Web Apps, Microsoft also announced set of new features of Word Web App and Excel Web App. Read about new Word Web App features here. Excel Web App has got new features such as status bar aggregates, ability to reorder sheets, drag and drop cells and more. Read them below.

Real-time co-authoring and presence

Excel Web App has supported multiple users editing the same workbook for years, but with this release things have gotten a lot better in two ways: the data flows between editors much faster (nearly instantly in most cases) and now you can see what cells other users are editing so that you don’t accidentally edit the same cell at the same time. This area is also exciting because we’ve added the same functionality to Word and PowerPoint Web Apps–read more about it here.

Besides support for Freeze Panes (introduced in June), Sheet Protection has been one of our biggest requests. In the past, Excel Web App would not load workbooks that contained Sheet Protection, but now it does, which will prevent users from selecting or typing in protected cells. This allows for easy creation of forms and calculators that you can fill out without worrying about the rest of your workbook getting messed up. Pro tip: Use Data Validation and Sheet Protection together for an even slicker solution!

Status bar aggregates

Some of the little things in Excel are what make it such a nice application to use. Quickly selecting a group of cells and seeing the SUM, AVERAGE, and COUNT in the status bar qualifies for many of our users as one of the most convenient shortcuts. Now those aggregates are shown in Excel Web App as well, making life that much easier.

Reorder sheets

When creating a workbook with multiple sheets, it is common to want to move a sheet from one location in the workbook to another–maybe move a sheet to be the first sheet if it is the most important. In the past, this was something that users could not accomplish using only Excel Web App, but now there are two ways to perform this common operation: right-click the sheet you want to move and then choose Reorder, or just click and drag the sheet tab to the desired location, and you’ll see an arrow to indicate where the sheet will end up.

Drag and drop cells

Similar to the way that you can drag and drop sheets within a workbook, one of the easiest ways to move cell values from one place to another is to drag them. This is also similar to Cut/Paste, but can be more convenient since Excel will show you the group of cells that’s being moved, and what range will be replaced when you drop the cells in their new location.

Rename the workbook

A final piece of feedback we’ve heard users want is the ability to rename a workbook–without creating a copy of it–from within Excel Web App. In the past, renaming has been possible, but the user would have to close the file, navigate to the file in SkyDrive, and then use SkyDrive UI to rename the file. Now you can simply click the filename in the header and type in your new name. Simple and quick!

Source: Office Blog

About Author

Pradeep, a Computer Science & Engineering graduate.