Skip to main content
me selecting custom sort in microsoft excel

Excel : how to sort tabel on custom criterea [custom sort]

This will allow us to sort multiple collums of data. If we use the normal sorting function we will mix our data.
In this example we use a list of the largest companies in the world by revenue.

Step 1: Select the tabel you want to sort

Step 2: Select “Sort & filter” in the top right of your screen. Then select “Custom Sort…”.

step 3: Now in the dialog box select by wich value you want to sort the table. In this example I want to find out which company has grown the most.

step 4: Then we can choose to sort “largest to smallest” or “smallest to largest”.

 

 

 

 

 

Excel Data validation window with validation criterea

Excel: How to make a dropdown list

Step 1: Create a list of items in the same or in another worksheet.

Step 2: Select all the cells and give them a name. In this example we use the name “levels”. Choose a name that contains only one word and press enter. Do this by clicking the “Name Box”.

Step 3: Select the cells where u want the list to be.

Step 4: Press “Data” in the menu >> choose Data Validation >> List >> put an ” = ” sign in the source field followed by the list name. It’s also possible to select a range of cells.

Tip: You can also set the values without creating a list. Put the values between comma’s and do not use “=”.

Step 5: Your drop down menu is ready. We can select one of the values from our list.

Additional tip: Users will get an error when the try to type within these cells. You can turn this of in the data validation menu.

Error message: “This value doesn’t match the data validation restrictions defined for this cell.”

This will allow users type any value if they want to.

 

Microsoft Excel team will release co-authoring

Microsoft will soon release a similar feature as already used by google spreadsheets. Excel users will share a file from OneDrive or SharePoint Online. This will allow multiple users to work on a document the same time.

How to use this feature:

  1. Be an Office 365 subscriber and opted into the Fast level of the Office Insider program
  2. Have Version 8017.1000 or later installed
  3. Save your file to SharePoint Online, OneDrive or OneDrive for Business.
  4. Work with another user who is on a co-auth enabled platform
  5. Share your file with others.

The company announced this on their blog yesterday.
The feature is currently still in b├Ęta-testing phase. Apply here for early acces: office insiders.

There is currently no official release date. Read more on this topic here.