Sorting text and numbers separately in Excel is as easy as ABC or 123 :) But re-arranging values that have both letters and digits in them such as employee IDs, SKU's and the like may cause problems. If you want to have more control over how alphanumeric stings are sorted, read this tutorial. Continue reading
Microsoft Excel provides a number of ways to arrange text data alphabetically, dates chronologically, and numbers from smallest to largest. In addition to the traditional Sort functionality, Excel 365 introduces a brand-new way to sort data with formulas. Continue reading
The Sort functionality has been around for a long time. But with the introduction of dynamic arrays in Excel 365, there appeared an amazingly simple way to sort in Excel with formulas. The beauty of this method is that the results update automatically when the source data changes. Continue reading
Excel's built-in sort options are powerful and effective tools, but they do not always work correctly when it comes to sorting dates. This tutorial will teach you a few useful tricks to arrange Excel spreadsheets by date in a meaningful way without messing up your data. Continue reading
There is only one method to rearrange worksheets in Excel - drag them to the desired position on the sheet tab bar. When it comes to alphabetizing tabs in a large Excel file, this may be a long and erroneous way. This tutorial shows a couple of time-saving alternatives. Continue reading
Alphabetizing in Excel is as easy as ABC. Whether you are sorting an entire worksheet or selected range, vertically or horizontally, ascending or descending, in most cases the task can be accomplished with a button click. Continue reading
Flipping data in Excel sounds like a trivial one-click task, but surprisingly there is no such inbuilt option. In this tutorial, you will find a few quick ways to flip tables vertically and horizontally preserving the original formatting and formulas. Continue reading
From this short tip you will learn how to quickly sort cells by background and font color in Excel 2016, Excel 2013 and Excel 2010 worksheets. Continue reading
In this article I will show you how to sort Excel data by several columns, by column names and by values in any row. Also, you will learn how to sort data in non-standard ways, when sorting in alphabetical or numerical order does not work. Continue reading
