Excel Basics

How to Sort Rows by Column in Excel (4 Methods)

When you are dealing with a big amount of datasets, searching, organizing, keeping them in a specific cell, and tracking the specific data becomes ...

How to Create and Use Custom Sort in Excel

While working in Excel, sometimes we have to sort a data set in ascending order. Sometimes we have to sort them in descending order. These are ...

Generate Random Number from List in Excel (4 Ways)

Although there is no suitable or single function to extract a random number from a list in Excel, there are numerous ways to manually construct the ...

How to Sort Rows in Excel (2 Simple Methods)

Sorting is one of the most common tasks in Excel, every now and then one may need to sort data. Most of our daily activities require column sorting, ...

Sort Column by Value in Excel (5 Methods)

When you add more raw data to your worksheet, balancing, organizing, and searching the specific data becomes more difficult. To get rid of this ...

How to Sort Data by Color in Excel (4 Criteria)

In Microsoft Excel, there are numerous ways available to sort table data under different criteria. If the data table contains colors in cells, fonts, ...

Sorting Columns in Excel While Keeping Rows Together

Sorting is the best way to make the dataset more convenient and acceptable. This makes our work with datasets in various ways. MS Excel provides ...

How to Sort Alphabetically in Excel with Multiple Columns (4 Methods)

Sorting alphabetically in excel is very easy and at the same time very useful when you are working with a wide range of raw data. Sorting is one of ...

Shortcut to Copy Formula Down in Excel (7 Ways)

To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. In terms of copying formulas in MS Excel, there are ...

How to Autofill Numbers in Excel without Dragging (5 Quick Methods)

Microsoft Excel provides numerous ways to autofill numbers with or without dragging. Filling down the column is the most common method to complete a ...

How to Convert Columns to Rows in Excel (2 Methods)

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you ...

How to Sort by Last Name in Excel (4 Methods)

If you work with datasets in Excel, you will often need to sort these datasets by name. Sometimes. You may need to sort the dataset based on your ...

Auto Sort When Data is Entered in Excel (3 Methods)

Sorting data automatically in excel is really useful when you are handling a wide range of data. Excel has no definite tool to auto-sort your data. ...

Find Matches or Duplicate Values in Excel (8 Ways)

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How To Search Multiple Items in Excel Filter

One of the more common tasks in Excel is filtering data. Probably in every aspect of your Excel use you are using the filter, filtering can be done ...

ExcelDemy
Logo