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 newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags ExcelMicrosoftsoftware

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

Mark Hachman

PC World (US online)
Show Comments

Cool Tech

Toys for Boys

Family Friendly

Stocking Stuffer

SmartLens - Clip on Phone Camera Lens Set of 3

Learn more >

Christmas Gift Guide

Click for more ›

Brand Post

Bitdefender 2019

This Holiday Season, protect yourself and your loved ones with the best. Buy now for Holiday Savings!

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?