Search

Delete Range

Last Updated: Dec 1, 2020

Articles

Use this function to delete a specific range of cells in the excel sheet. The remaining data in the sheet shifts up.

Syntax

Delete Range (delete_range)

Parameters

Input Parameter Name Description
delete_range Two cell values (first cell and last cell) separated by ‘:’ to delete

':' is used as separator between the cells.

Sample

Delete Range (C4:D5)

  • Deletes the range from ‘C4’ to ‘D5’ in the excel sheet.

To view all the Excel functions, click here.

Did you find what you were looking for?