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.
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.
1. Clear Multiple Adjacent and Non-Adjacent Cells in Excel
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 basic ideas to do the jobs.
- 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.
- Then a pop-up appears where we select Shift cells up to ensure the cleared rows will be filled up with the below rows.
- 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.
- Now, a pop-up appears where we select Shift cells up to ensure the cleared rows will be filled up with the below rows.
- The final data set will be like the image below where we have cleared the 15th and 16th Aug rows from the dataset.
Read More: How to Clear Cells in Excel VBA
1.2 Clearing Non-Adjacent Cells
To clear non-adjacent cells, execute the following 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.
- Now we will press the Delete button on the keyboard and the result will be the below-like image.
- Excel VBA: Clear Contents If Cell Contains Specific Values
- Difference Between Delete and Clear Contents in Excel
- How to Clear Recent Documents in Excel
- How to Clear Formatting in Excel
- How to Remove Formatting in Excel Without Removing Contents
2. Using Excel Find and Replace Command to Partially Clear Multiple Cells
We can also clear cells with the 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.
- 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.
- In the preview mode, we just have selected the fill color 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.
- 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.
Download Practice Workbook
You can download the practice workbook from the following download button.
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.
- How to Clear Contents Without Deleting Formulas Using VBA in Excel
- How to Clear Contents in Excel Without Deleting Formatting
- How to Clear Excel Temp Files
- Excel VBA to Clear Contents of Range
- Excel VBA to Clear Contents of Named Range
- How to Clear Contents of a Sheet with Excel VBA
- How to Clear Cell Contents Based on Condition in Excel