Abstract: Formats are extended automatically to cells in an electronic spreadsheet. Previously blank, newly edited cell(s) are determined to be an extension or within a list of cells based on having a consistent data type, and the like. Next, formatting of the list of cells is examined for consistency. If consistent formatting exists, it is applied to the previously blank, newly edited cell(s). List of cells may include rows, columns, and the like.

Abstract: Methods for automatically, without user instruction, extending a format and/or a formula to include a cell in an electronic spreadsheet. A previously blank newly edited cell may be determined to be an extension to or within a list of cells. A list of cells may be defined as a number of previous cells having a consistent data type. If a list of cells exists and the previously blank newly edited cell also includes the consistent data type, the previously blank newly edited cell is considered to be an extension of or within a list. The cells in the list are then examined for consistent formatting. If consistent formatting exists in the list, the consistent formatting is applied to the previously blank newly edited cell. Also, the cells in the list are examined for consistent formulas. The rows containing the cells in the list are each examined for a consistent formula having all supporting cells populated.

Abstract: Methods for automatically, without user instruction, extending a format and/or a formula to include a cell in an electronic spreadsheet. A previously blank newly edited cell may be determined to be an extension to or within a list of cells. A list of cells may be defined as a number of previous cells having a consistent data type. If a list of cells exists and the previously blank newly edited cell also includes the consistent data type, the previously blank newly edited cell is considered to be an extension of or within a list. The cells in the list are then examined for consistent formatting. If consistent formatting exists in the list, the consistent formatting is applied to the previously blank newly edited cell. Also, the cells in the list are examined for consistent formulas. The rows containing the cells in the list are each examined for a consistent formula having all supporting cells populated.