How to Delete Data in a Range in Excel

Delete Data in a Range

 

 

Delete Data in a Range: If your worksheet has a range that contains data you no longer need, you can delete that data. This helps to reduce worksheet clutter and makes your worksheet easier to read. Note that the technique in this section, only applies to deleting the data that exists within each cell in a selected range. It does not apply to deleting the actual range.

Delete a Range: If your worksheet contains a range that you no longer need, you can delete that range. Note that when you delete a range, Excel deletes not just the data within the range, but the range cells themselves. Excel shifts the remaining worksheet data to replace the deleted range. Note that the technique in this section deletes the actual cells from the selected range.

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips