Posts Tagged 'custom sort'

How to Auto Update the Sorted Range via VBA in Your Excel Worksheet

The custom sort in Excel is a very useful feature. In this article, we will talk about how to automatically update custom sort in a range by using the Excel VBA. When you use the custom sort, you will find that this is an amazing feature in Excel. However, if you use this feature frequently, you may also find a problem. You will sort in a range with certain data and information. When you add additional data and information into the range, the order in the range will not change...

Read more »

How to Sort Data by Rows Instead of Columns in Your Excel

Leave a Comment Data Recovery, Excel Solutions, File Recovery, Office Solutions July 30, 2016

Excel has many features that can help you finish many tiring tasks. And the feature of sort can help you quickly find certain values in a bunch of numbers. But today we will introduce how to sort data by rows instead of columns. The sort feature is a very useful feature in Excel. Thus, most of you have used this function to sort certain columns. However, the default setting of sort can only take effect in columns. Thus, if you want to sort values in rows, you need to set before you use this...

Read more »