Sort or Select Cells/Rows/Columns Randomly in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstosortorselectc, kutools
Published: 2020-10-13 11:59:47

---
title: Sort or Select Cells/Rows/Columns Randomly in Excel Office 365!!
published: true
date: 2020-10-13 10:43:51 UTC
tags: KutoolsExcelTutorial,Stepstosortorselectc,Kutools
canonical_url: https://geekexcel.com/sort-or-select-cells-rows-columns-randomly-in-excel-office-365/
---

In this post, we will describe the steps to **Sort or Select Cells/Rows/Columns Randomly in Excel Office 365** using **Kutools.** Let’s jump into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Sort or Re-arrange Cells, Rows/Columns Randomly in a Range:

To sort or re-arrange cells, rows, or columns randomly in a range, follow the below steps.

- **Select** the **input range** that you need to apply to this feature.
- On the **Kutools Tab, select** the **Range** option, **choose** the **Sort/Select Range Randomly** option from the menu.

![Select the Range option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Range-option.png)<figcaption id="caption-attachment-15665">Select the Range option</figcaption>

- It will open the **Sort/Select Range Randomly Dialog box.**
- You need to **click** the **Sort** tab and **select** the **operation** that you need to apply, under the **Sort Type** section.
- **Entire rows –** This will randomly sort the entire row order.
- **Entire columns –** It will randomly sort the entire column order.
- **Cells in each row –** It will sort the cell values randomly based on each row.
- **Cells in each column –** This option will sort the cell values randomly based on each column.
- **All cells in the range –** It can sort or re-arrange cell values in a range.

![Sort/Select Range Randomly Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Sort-or-Select-Range-Randomly-Dialog-box.png)<figcaption id="caption-attachment-15666">Sort/Select Range Randomly Dialog box</figcaption>

- Now, you need to **click** the **OK** or **Apply** button to get the result.

### All Cells in the Range:

![sort All Cells in a range randomly](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/100.png)<figcaption id="caption-attachment-15667">sort All Cells in a range randomly</figcaption>

### **Cells in each row:**

![Sort cells in each row randomly](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/second.png)<figcaption id="caption-attachment-15668">Sort cells in each row randomly</figcaption>

### **Cells in each column:**

![Sort cells in each column](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Third.png)<figcaption id="caption-attachment-15669">Sort cells in each column</figcaption>

### **Entire rows:**

![Sort entire rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Fourth.png)<figcaption id="caption-attachment-15670">Sort entire rows</figcaption>

### **Entire columns:**

![Sort entire columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/final.png)<figcaption id="caption-attachment-15671">Sort entire columns</figcaption>

## Select Cells, Rows/Columns in a Range:

To select cells, rows/columns in a range in Excel, do the below steps.

- First, you need to select the range.
- On the **Kutools Tab, select** the **Range** option, **choose** the **Sort/Select Range Randomly** option from the menu.

![Select the Range option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Range-option.png)<figcaption id="caption-attachment-15665">Select the Range option</figcaption>

- It will open the **Sort/Select Range Randomly Dialog box.**
- In that dialog box, you need to **click** the **Select** tab and **choose any one** of the options under the **Select type** section.
- **Select random cells –** It will randomly select cells in the range.
- If you choose the **Select random rows** option, it will help you to select the rows in a range randomly.
- **Select random columns –** It will randomly select columns in the range.

![Sort/Select Range Randomly Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/11111.png)<figcaption id="caption-attachment-15672">Sort/Select Range Randomly Dialog box</figcaption>

- Then, **click** the **OK** button or **Apply** button to see the result.
- For example, we have chosen the “ **select random rows** ” option and it will select only random rows from the range.
- Refer to the below screenshot.

![Select random row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/orange.png)<figcaption id="caption-attachment-15673">Select random row</figcaption>

## A Short Synopsis:

In this post, you can clearly understand the steps to **Sort or Select Cells/Rows/Columns Randomly in Excel Office 365** using **Kutools.** Give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Save and Export Charts, Graphs, as JPEG Image Files in Excel](https://geekexcel.com/save-and-export-charts-graphs-as-jpeg-image-files-in-excel-365/)
- [Convert Cell Formulas to Text Strings in Excel ](https://geekexcel.com/how-to-convert-cell-formulas-to-text-strings-in-excel-office-365/)