Excel Online gets paid-level upgrades to filtering and in-document hyperlinks

Microsoft's March updates to Excel Online should prove handy, whether you're editing a document for work or just planning the household budget.

Microsoft’s Office Online is a free, Web-based alternative to subscription-based Office 365. Fortunately, the formatting and feature updates it continually adds bring it closer to the paid experience, such as the new additions Microsoft added to Excel Online Tuesday.

To take advantage of them, all you need is a Microsoft account, which can be as trivial as an old Hotmail email address. All of the updates should already available; if they’re not, they should appear in Excel Online before the end of the month.

Two updates stand out as more advanced features that push the Online version closer to paid Excel: in-document hyperlinks, and better PivotTable summaries. If those are beyond your needs, Microsoft also added richer table formatting options as well as an easier way to access different currencies.

Why this matters: Office Online doesn’t offer all of the features that the paid versions do, but as Microsoft continually pushes toward ever more intelligent paid apps, the bar has been raised for its free versions as well. Note that you can only view and edit documents if you don’t already have an Office 365 subscription, but there’s nothing really stopping you from creating a document on a work computer (as well as a few blank “spares”) and using those spares as “new” documents.

Tweaked features for advanced users

We've all embedded hyperlinks, but fewer people have likely used hyperlinks as in-document navigation, such as a table of contents. You can now hyperlink a cell to another cell, so that you can create a summary table, for example, that links back to more detailed findings. Naturally, you can still connect your spreadsheet to an outside webpage.

excel online hyperlink

Hyperlinking is simple, but handy.

PivotTables and PivotCharts are ways Excel spreadsheets can be used to “query” data, essentially asking the data basic questions whose answers you can act upon. Microsoft sells the more advanced versions of Excel as a medium for “business intelligence,” with more sophisticated tools to, say, track quarterly sales figures against a geographical map. Online, the tools are a bit more rudimentary.

Still, Microsoft tweaked the PivotTable > Value > Value Field Settings control to add two tabs: Summarize Value By, and Show Value As. As the names suggest, you can change the summarized value type as well as the type of calculation in the PivotTable value fields. Microsoft also added a handy search function so if you’re not exactly sure what you named a particular value, you can search against it in a filter list.

excel online currency

A dropdown menu provides more currency options.

Some basic, useful updates as well

Office Online users often don’t need thousands of cells to create a spreadsheet, so some of Microsoft’s more basic updates my actually prove to be more useful. For example, Microsoft added additional number formats; all you need to do is click Number Format > More number formats or simply right-click a cell to open the Format option. If you click the dollar-sign currency option, you’ll be able to select quickly from a list of popular currencies.

Microsoft also promised you’ll be able to rejoin the same worksheet you were on in the PC version of the Excel app when you open the same document in Excel Online.

Join the PC World newsletter!

Error: Please check your email address.

Tags ExcelMicrosoftsoftware

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Mark Hachman

PC World (US online)
Show Comments

Essentials

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?