How to Move Highlighted Cells in Excel (5 Ways)

While we work on a large Excel spreadsheet, we have to move highlighted cells to the top or bottom. Excel has amazing features to move its highlighted cells. If you are facing any problems doing it, this article might help you. In this article, we will demonstrate to you 5 possible approaches on how to move highlighted cells in Excel.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


5 Easy Methods to Move Highlighted Cells in Excel

For explaining the procedures, we are considering the data of 10 employees of a company. Their name and salary are in columns B and C, entitled as Name and Salary respectively. So, our dataset is in the range of cells B5:C14. First, we will be highlighted the entities that are in the Salary range between $3,000 and $4,000. Then, we will move them to the top or bottom of our dataset using the following methods.


1. Use of Sort Command to Move Highlighted Cells

In this process, we will use a built-in feature of Excel, called Sort to move highlighted cells of our dataset. Our dataset is in the range of cells B5:C14. We will be highlighted the entities that are in the Salary range between $3,000 and $4,000 The steps of this method are given below:

Steps:

  • First of all, select the entire range of cells B4:C14.
  • Now, in the Home tab, select Conditional Formatting. After that, click on  Highlight Cell Rules > Between.

Use of Built-in SORT Feature to Move Highlighted Cells

  • A small dialog box, called Between will appear.
  • Then, write down your desired lowest and highest salary amount like the image shown below. Here, we choose the salary range of $3,000 to $4,000.
  • After that, choose the cell highlight pattern, We kept the default one, Light Red Fill with Dark Red Text.

  • Click OK to close the dialog box.

Use of Built-in SORT Feature to Move Highlighted Cells

  • You will see the salaries within the range are highlighted.
  • Now, in the Data tab, select the Sort & Filter group. Click on Sort.

Use of Built-in SORT Feature to Move Highlighted Cells

  • A small dialog box, called Sort will appear.
  • In this dialog box, click on the drop-down arrow of the Column option and choose the Salary.
  • Then, change the Sort On option from Cell Values to Cell Color.
  • Click on the drop-down arrow of the Order option and choose the cell color.
  • Besides the Order column, there is another untitled column. Click on it and you will get 2 options. On Top/On Bottom. Choose anyone according to your desire. Here, we kept the On Top option. 
  • Finally, click OK.

Use of Built-in SORT Feature to Move Highlighted Cells

  • You will find all the highlighted rows move upward.

Use of Built-in SORT Feature to Move Highlighted Cells

In the end, we can say our method worked successfully and we are able to move the highlighted cells.

Things You Should Know

As our highlight pattern contains both the cell color and font color, you can also choose the Sort On option with Font Color. The result of both selections will be the same.

Read More: How to Move Rows in Excel (4 Simple & Quick Methods)


2. Drag Highlighted Cells to Move

In this approach, first, we highlighted the salaries within the range of $3,000 to $4,000. Then, we will drag the highlighted rows at the bottom of our dataset through our mouse. Our dataset is in the range of cells B4:C14. The process is given below:

Steps:

  • First, select the entire range of cells B4:C14.
  • Now, in the Home tab, select Conditional Formatting. After that, click on Highlight Cell Rules > Between.

Drag Highlighted Cells to Move

  • A small dialog box, called Between will appear.
  • In this dialog box, write down your desired lowest and highest salary amount like the image shown below. We choose the salary range of $3,000 to $4,000.
  • Then, choose the cell highlight pattern, We kept the default one, Light Red Fill with Dark Red Text.
  • Click OK to close the dialog box.

  • You will see the salaries within the range are highlighted.

  • After that, select any of those highlighted cells with your mouse.
  • As your mouse cursor will come near the bottom side of the cell, you will see a Move Pointer icon will appear.

Drag Highlighted Cells to Move

  • Now, select the Move Pointer icon and drag it to the bottom of the dataset with your mouse.
  • You will see the row allocates at the bottom of the dataset.

Drag Highlighted Cells to Move

  • Similarly, do the same tasks for all of the highlighted cells.
  • When you drag the rows through your mouse, an empty row will create at that position. Now, select all of those empty rows.

  • Next, in the Home tab, go to the Cells group and click Delete.

Drag Highlighted Cells to Move

  • Finally, you will get all the highlighted cells at the bottom of your dataset.

Drag Highlighted Cells to Move

Thus, we can say that our procedure worked perfectly and we are able to move the highlighted cells.

Read More: How to Shift Cells Up in Excel (5 Quick Ways)


Similar Readings


3. Move Highlighted Cells Using Insert Option

In this method, we will first highlight the salaries within the range of $3,000 to $4,000. Then, we move the highlighted rows at the top of our dataset using the Excel Insert option. Our dataset is in the range of cells B4:C14. The steps of this procedure are given as follows:

Steps:

  • In the beginning, select the entire range of cells B4:C14.
  • Now, in the Home tab, select Conditional Formatting. After that, click on Highlight Cell Rules > Between.

Move Highlighted Cells Using Insert Option

  • A small dialog box, called Between will appear.
  • Then, write down your desired lowest and highest salary amount like the image shown below. Here, we choose the salary range of $3,000 to $4,000.
  • Next, choose the cell highlight pattern, We kept the default one, Light Red Fill with Dark Red Text.
  • Click OK to close the dialog box.

  • You will see the salaries within the range are highlighted.
  • Now, select the range of cells B7:C8.
  • Press ‘Ctrl+X’ on your keyboard.

Move Highlighted Cells Using Insert Option

  • Select cell B6 and in the Home tab, select Insert from the Cells group.

Move Highlighted Cells Using Insert Option

  • You will see the range of cells will move upward.

  • Similarly, follow the same procedure for the rest range of cells B10:C10 and B14:C14.
  • Finally, you will get all the highlighted cells at the top of your dataset.

Move Highlighted Cells Using Insert Option

At last, we can say that our approach worked effectively and we are able to move the highlighted cells at the top of our dataset.

Read More: How to Shift Cells Right in Excel (4 Quick Ways)


4. Using ‘Shift’ Key to Move Cells

In this case, we have to first highlight the salaries within the range of $3,000 to $4,000. Then, we move the highlighted rows with the help of the ‘Shift’ key of our keyboard and our mouse. Our dataset is in the range of cells B4:C14. The method is described below step by step:

Steps:

  • At first, select the entire range of cells B4:C14.
  • Now, in the Home tab, select Conditional Formatting. After that, click on Highlight Cell Rules > Between.

Using ‘Shift’ Key to Move Cells

  • A small dialog box, called Between will appear.
  • After that, write down your desired lowest and highest salary amount like the image shown below. We choose the salary range of $3,000 to $4,000.
  • Choose the cell highlight pattern, We left the default one, Light Red Fill with Dark Red Text.
  • Then, click OK to close the dialog box.

  • You will see the salaries within the range are highlighted.
  • Now, select the range of cells B7:C8.
  • Then, press the ‘Shift’ key and drag the cells Move Pointer icon through your mouse.

Using ‘Shift’ Key to Move Cells

  • The range of cells will move upward.

Using ‘Shift’ Key to Move Cells

  • Similarly, follow the same procedure for the rest range of cells B10:C10 and B14:C14.
  • Finally, you will get all the highlighted cells at the top of your dataset.

Using ‘Shift’ Key to Move Cells

At last, we can say that our working method worked effectively and we are able to move the highlighted cells at the top of our dataset.

Read More: How to Move Cells without Replacing in Excel (3 Methods)


Similar Readings


5. Utilizing Context Menu

In this following method, first, we are going to highlight the salaries within the range of $3,000 to $4,000. Then, we will move the highlighted rows with the help of the Cut command of Excel’s Context Menu. Our dataset is in the range of cells B4:C14. The method is explained below:

Steps:

  • In the starting, select the entire range of cells B4:C14.
  • Now, in the Home tab, select Conditional Formatting. After that, click on Highlight Cell Rules > Between.

Utilizing Context Menu to Move Highlighted Cells in Excel

  • A small dialog box, called Between will appear.
  • Then, write down your desired lowest and highest salary amount like the image shown below. Here, we choose the salary range of $3,000 to $4,000.
  • After that, choose the cell highlight pattern, We kept the default one, Light Red Fill with Dark Red Text.
  • Lastly, click OK to close the dialog box.

  • You will see the salaries within the range are highlighted.
  • Now, select the range of cells B7:C8.
  • Press ‘Ctrl+X’ on your keyboard.

  • Select cell B6.
  • Right-click on your mouse and select the Inset Cut Cells option.

Utilizing Context Menu to Move Highlighted Cells in Excel

  • The range of cells will move upward.

Utilizing Context Menu to Move Highlighted Cells in Excel

  • Similarly, do the same job for the rest range of cells B10:C10 and B14:C14.
  • Finally, you will get all the highlighted cells at the top of your dataset.

Utilizing Context Menu to Move Highlighted Cells in Excel

lastly, we can say that our method worked perfectly and we are able to move the highlighted cells at the top of our dataset.

Read More: Excel Formula to Move Data from One Cell to Another

Things You Should Know

If you have only a limited amount of highlighted cells to move, like our dataset, you can follow the manual approaches. Otherwise, we recommend you follow our first method. It will save you time.


Conclusion

That’s the end of this article. I hope that this will be helpful for you and you will be able to move highlighted cells in an Excel worksheet. If you have any further queries or recommendations, please share them with us in the comments section below.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo