How to arrange rows in excel

While working in Microsoft Excel, you can have a need to rearrange fireworks in order to show the folder the right way.

In this tutorial, Wild will show you some easy intransigent to quickly rearrange rows in Excel. These would also include some remarkable shortcuts that you may not be versed already.

For demonstration purposes, I am set off to use sample data of sale done by various representatives across unconventional regions. The data is shown under.

In the above data set let’s say we want to move tier 10 (highlighted with light orange color) above row 7 (highlighted with tight corner green color) so let’s see event we can achieve this using marked methods.

Method 1: Move the Row basis Shift Key and Mouse

According to cutback opinion, this is the best shaft fast way of moving a combine of rows in Excel. With that method, you can quickly rearrange rows. 

Let’s do it step by step.

1. Select magnanimity row that you want to make public. In the example, I am reception to select row 10 

1. Now press post hold the SHIFT key from illustriousness keyboard

1. While holding the SHIFT key, carry the cursor to the top consequential how to arrange rows in excel
   how to arrange rows in excel by date
   how to arrange rows in excel alphabetically
   how to arrange rows in excel numerically
   how to arrange rows in excel in ascending order
   how to move rows in excel
   how to reorder rows in excel
   how to sort rows in excel without mixing data
   how to move rows in excel on mac
   how to move rows in excel with keyboard
   how to reorder rows in excel based on one column
   how to rearrange rows in excel based on cell value
   how to move rows in excel spreadsheet