Working with Selected Cells

Because of the sheet's predefined precedence, as described in Precedence of Settings, cells can have information stored for them at four levels:

• For the cell itself
• For the cell's row (when you have set the Col property or Col parameter to –1)
• For the cell's column (when you have set the Row property or Row parameter to –1), and
• For the entire sheet

When you perform an action on a cell, such as moving the cell, only the information stored for the cell itself is acted on. For example, if you copy a cell, the background color defined for the cell is also copied; however, the background color defined for the cell's column, row, or the entire sheet is not copied.

Logically, when you set a characteristic for a column, a row, or the entire sheet, that setting is not stored for the cell, and therefore is not included in actions performed on the cell.