Clear command

SQL*XL
home

Syntax:
CL[EAR] {BR[EAKS] | COL[UMNS] | SCR[EEN] | range_address };

Description:
CLEAR BREAKS Clears breaks defined using the break command.
CLEAR COLUMNS Clears formatting details configured through the Column command.
CLEAR SCREEN Clears the current worksheet.
range_address Clears any valid Excel range.

Examples:
Clear screen; --Clears the current worksheet
Clear A1;  --Clears cell A1
Clear D10:F20; --Clears the range D10 to F20

Clear A:C; --Clears columns A to Z
Clear Sheet2!F10:H30; --Clears F10 to H30 on sheet2.


See also: