Search

Clear Range

Last Updated: Dec 1, 2020

Articles

Use this function to clear data in a specific range of cells.

Syntax

Clear Range (clear_range)

Parameters

Input Parameter Name Description
clear_range Two cell values (first cell and last cell) separated by ‘:’ to clear the data

':' is used as separator between the cells.

Sample

Clear Range (A1:A5)

  • Clears all the data present in the cell range A1:A5.

To view all the Excel functions, click here.

Did you find what you were looking for?