Excel Plus
  • 👋Welcome
  • 🛠️Components
    • Analysis
      • ⚫Add Spark Bar
      • ⚫Add Spark Line
      • ⚫Conditional Bars
      • ⚫Conditional Between
      • ⚫Conditional Blank
      • ⚫Conditional Percent
      • ⚫Conditional Scale
      • ⚫Conditional Text
      • ⚫Conditional Top
      • ⚫Conditional Unique
      • ⚫Conditional Value
    • Cell
      • ⚫Cell Content
      • ⚫Cell Address
      • ⚫Cell Location
      • ⚫Generate Cells
    • Format
      • ⚫Border
      • ⚫Clear
      • ⚫Fill
      • ⚫Font
      • ⚫Size
    • Range
      • ⚫Construct Range
      • ⚫New Range
      • ⚫Populate Range
      • ⚫Deconstruct Range
      • ⚫Explode Range
      • ⚫Range Extents
      • ⚫Sub Ranges
      • ⚫Merge Ranges
    • Worksheet
      • ⚫Construct Worksheet
      • ⚫Deconstruct Worksheet
      • ⚫Worksheet Properties
      • ⚫Place Image
    • Workbook
      • ⚫Construct Workbook
      • ⚫Deconstruct Workbook
      • ⚫Workbook Properties
      • ⚫Open Workbook
      • ⚫Save Workbook
      • ⚫Read Workbook
      • ⚫Write Workbook
Powered by GitBook
On this page
  • Description
  • Usage
  1. Components
  2. Format

Clear

Clear the content or formatting for a Cell or all Cells in a Range or Worksheet

PreviousBorderNextFill

Last updated 1 year ago

Description

Clear the content or formatting for a Cell or all Cells in a Range or Worksheet

Name | Clear

Nickname | Clear

Tab | ExcelPlus

Panel | Format

Division | 1

Obj | Object (object) | Clear all values

V | Clear Values (bool) | A Cell, Range, Worksheet, or Workbook Object

F | Clear Formatting (bool) | A Cell, Range, Worksheet, or Workbook Obj

C | Clear Conditions (bool) | A Cell, Range, Worksheet, or Workbook Obj

Obj | Object (object) | A Cell, Range, Worksheet, or Workbook Object

none

Usage

🛠️
⚫