You have a mega spreadsheet. Loads and loads of data. It has taken you ages to compile it for your client. As you finish, panic sets in. Adding the data was easy. What if the client asks you to provide it sorted in a particular way?Sort Excel

What is the fastest way to sort your Excel data?

When I teach this in the classroom, I always ask the question – how do you sort your data? I usually get a few different answers.

  1. Select the whole spreadsheet then click the Data Ribbon and the big Sort Button
  2. Select the column to sort by and click Click A/Z or Z/A sort on the Data Ribbon
  3. Click the Sort and Filter button on the Home Ribbon

Then I get someone say, but it never sorts everything. My data is all over the show.

So let’s debunk some sorting myths.

The absolutely fastest and most accurate way to sort a whole spreadsheet by the values in one column is to:

  1. Click into the column
  2. Click on the A/Z sort icon (it is on the Data Ribbon the right click or the drop down on the Home Ribbon)

Sort Exce

Hey Presto! Your whole worksheet is sorted and it keeps everything together.

So to recap:

  1. Click into the column to sort by
  2. Click on the sort icon you like to use.

Did this help? Have you learned something new? How will you use it? Leave a comment below.

Shelley

P.S – have you joined my Facebook Group yet? Join in and ask questions, get answers and generally interact. See you there

I really like Shelley’s courses. She has a clear and easy to follow teaching style. In ‘How to Create Fillable Forms’ I’ve learned about the functions of the Developer ribbon which will mean I’ll be able to create a bespoke Returns Form for a client who has an online shop

Freya Henderson – Virtual Office Orkney

Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.

Sarah Clements – Inuous

Absolutely superb course, easy to follow and to refer back whilst putting it all into practice! I was unaware of the extent you can customise a presentation and it’s just made me want to know more – what’s next Shelley?

Denise Williams

I thought I had a pretty good grasp of Outlook until I did this course! In her videos, Shelley is clear and concise, and the language she uses is straightforward and jargon-free. Each module is broken down into manageable chunks, which helps keep your attention and means the course is easy to fit in around other commitments. I’ve created email templates and implemented rules that are already saving me time, and as all the other things I’ve learnt start to become second nature, the positive impact on my efficiency is fast becoming clear. This course has been incredibly beneficial and I would highly recommend it to anyone looking to strengthen their skills and boost productivity.

Pip Doleman VA

I thought I knew Powerpoint really well, but I wanted to specifically learn how to use Powerpoint to create better infographics, easily and quickly. Shelley explains everything in a very logical and clear way, so I understood everything the first time I heard it. The most useful thing I learnt was that Powerpoint can do so much more than I thought it could. By also using the short cuts that Shelley showed me I am much quicker than I have ever been and I thought I was already quick!

Susan Marot

Shelley Fishel of Tomorrow’s VA has a wealth of experience in Microsoft Office. I met her in person 2 years ago at the PA Show in London. I also saw her in action in a fab workshop and knew she was the whizz that everyone had told me she was. I have since bought a lifetime access to her HUB and all the courses in there are a MUST if you are a VA on a mission. The courses will give you confidence in all the Office 365 components and will catapult you to dizzy heights

Alex Hughes