Search

Clear Range

Last Updated: May 10, 2022

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 Range of cells (first cell and last cell) separated by : to clear the data

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?