Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Clear Multiple Cells in Excel (2 Effective Methods)

Words, data, and values can sometimes be repeated when we produce a huge dataset in Excel. Truly speaking, we prefer to get rid of those data as early as possible. In this post, we’ve covered a variety of simple ways how to clear multiple cells in Excel. So, keep buzzing with us in the following procedures.


Download Practice Workbook

You can download the practice workbook from the following download button.


2 Ways to Clear Multiple Cells in Excel

Distinct sales representatives of a store were present on different days. So, in some particular cases, we don’t want some entries on definite days. Or we don’t prefer a particular name to be repeated. That’s why the topic, how to clear multiple cells in Excel, comes as a handy topic to deal with such kinds of problems.

Sample Data to Show How to Clear Multiple Cells in Excel


1. Clear Adjacent and Non-Adjacent Cells

1.1 Clearing Adjacent Cells

Suppose we don’t need the data in the row of 15th and 16th August. So, in the following process, we will also show some very basics idea to do the jobs.

📌 Steps:

  • In the very first method, we will just select the rows and right-click on the mouse button then just like the below image we will select Delete.

select the rows and right-click on the mouse to clear cells

  • Then a pop-up appears where we select Shift cells up to ensure the cleared rows will be filled up with the below rows.

a pop-up to shift cells up

Or,

  • We can also clear cells in Excel by simply clicking the Control key and – key together, like Ctrl – otherwise going to the Home tab and in the home tab, we will go to Cells then to Delete Cells in the Delete option.

Delete Cells in the Delete to clear multiple cells in Excel

  • Now, a pop-up appears where we select Shift cells up to ensure the cleared rows will be filled up with the below rows.

a pop-up appears to shift cells up to clear rows

  • The final data set will be like the image below where we have cleared the 15th and 16th Aug rows from the dataset.

final data set


1.2 Clearing Non-Adjacent Cells

To clear non-adjacent cells, execute the following steps.

📌 Steps:

  • In this process, we will select the cell that we want to clear, and then before selecting the second cell we will hold the Ctrl key and so on.

selecting the cells to be cleared

  • Now we will press Delete button on the keyboard and the result will be the below-like image.

press Delete button in the keyboard

Read More: How to Clear Cells in Excel with Button (with Detailed Steps)


Similar Readings


2. Clear Multiple Cells Partially Using Find and Replace Command

We can also clear cells with Find and Replace option in Excel. It’s a very handy tool if the data set is large enough not to see particular names or values.

📌 Steps:

  • First, we will press Ctrl+F to open the Find and Replace window in the current worksheet. Then like in the steps shown in the below image we will go to the replace option. For this moment we will find a name that says ‘Marvin’ and in Replace with: box, we will just press a space button. We have worked within the sheet and searched by columns as we selected in the image. And finally, we will press Replace all.

Ctrl+F to open the Find and Replace window

  • In the preview mode, we just have selected the fill color to be red to show the cleared cells in Excel.

selected the fill colour to be red to show the cleared cells in Excel

  • ‘All done’ message will appear in the sheet, and we select just Ok to complete the clearing.

‘All done’ message will appear

  • Finally, the column without the name Marvin appears below as in this example this is the purpose of our goal to clear cells in Excel.

cleared cells in a column

Read More: How to Clear Cells with Certain Value in Excel (2 Ways)


Conclusion

To Reverse a string in Excel, follow those procedures and stages. You may also download the workbook and use it for your own practice. In the comments area, if you have any questions, issues, or recommendations, just let me know. And for more such articles, please visit our blog ExcelDemy.


Related Articles

 

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, I am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo