Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Commands

Buy now

Download now

SQL*XL online help
 

SQL*XL: Clear command

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:

SQL*XL ribbon in Excel