How To...

Sorting a Column in Excel Web App

Sorting a Column in Excel Web App

I divide my cloud spreadsheet time almost equally between Google Docs (aka Google Drive) and the Excel Web App in Microsoft’s SkyDrive. While I enjoy features of both, I found that merely sorting a spreadsheet in the Excel Web App seemed much clunkier than Google’s online spreadsheet. If you’re trying to figure out simple sorting, here’s how to do it.

Sponsored Links

Please take a look at the screen shots at the bottom of this article.

1. Select your data range. Simply place your cursor somewhere in the data range and Excel does a pretty good job of figuring out what range to sort.

2. On the toolbar at the top of the page, select “Format as Table” and from that drop-down, also select “Format as Table.”

3. You will then be asked if your data range has a header row or not.

4. Now that your data has been converted to a table, each column will contain a drop-down which you can choose to sort your data.

Obviously this is a much more involved process than merely selecting “sort” but what do you want for free? Aside from this and a few other glaringly obvious features, the Excel Web App is a decent spreadsheet.

Have you found a better way to sort data in the Excel Web App? Or is this article out of date? Let us know in the comments below!

View Comments (1)

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

How To...

More in How To...

  • 28 Natural Treatments for Enlarged Prostate (BPH)

    Have you been diagnosed with an enlarged prostate, also known as Benign prostatic hyperplasia, or BPH? Have you tried over-the-counter, and at-home treatments to alleviate the symptoms? Have you tried prescription medicine as well? Here is my list of 28 natural solutions to BPH. Sponsored links

  • How to Retrieve Your Old Photos in the New Myspace

    When the “New Myspace” launched in 2013, some users logged for the first time in years in hopes of seeing their old Myspace data – only to find their beloved (or ignored) profile had been wiped clean, with the exception of a single profile picture. Though it hasn’t yet been announced that...

  • Netgear Router Dropping Connection? Try this.

    This is how I fixed the same problem – 3 years apart – with two Netgear routers constantly disconnecting intermittently. It is a revised version of my original 2012 post to include updated info from 2015. Sponsored links

  • How to Hide a Facebook Friend Without Unfriending Them

    It is possible to hide a Facebook friend from your news feed without actually unfriending them. Today we look at a couple of ways of achieving this, and discuss additional concerns encountered by our readers. Sponsored Links

  • Ubuntu Sound Suddenly Stopped Working? Try This.

    Has your sound suddenly stopped working in Ubuntu? Here is a common solution to this problem. Sponsored links

  • How to Disable Fast Free Converter Ads

    Have you seen annoying ads at the bottom of your web browser from Fast Free Converter? Luckily these ads are rather easy to disable. Here’s how: Sponsored links

  • How to Hide Your Facebook Friend List

    Want to hide your list of Facebook friends from public view but can’t find this option in the Privacy Settings? This simple option isn’t found where you might think. Sponsored links

  • How to Add a Facebook Page to Your Favorites

    Adding a Facebook page that  you follow to your favorites is relatively easy, although it requires several steps to accomplish. Today we’ll take you through the steps. Sponsored Links

Celebrating the weird and fake since 2008.

Copyright © 2008-2016, Inc. Theme by MVP Themes, powered by Wordpress.