Book1 |
---|
|
---|
| A | B | C | D |
---|
1 | | $A$1 | Absolute reference of the upper-left cell in reference, as text in the current workspace reference style. | |
---|
2 | | 1 | Row number of the top cell in reference. | |
---|
3 | | 1 | Column number of the leftmost cell in reference. | |
---|
4 | | 1 | Same as TYPE(reference). | |
---|
5 | | 0 | Contents of reference. | |
---|
6 | | | Formula in reference, as text, in either A1 or R1C1 style depending on the workspace setting. | |
---|
7 | | General | Number format of the cell, as text (for example, "m/d/yy" or "General"). | |
---|
8 | | 1 | Number indicating the cell's horizontal alignment: | 1 = General |
---|
9 | | 0 | Number indicating the left-border style assigned to the cell: | 0 = No border |
---|
10 | | 0 | Number indicating the right-border style assigned to the cell. See type_num 9 for descriptions of the numbers returned. | |
---|
11 | | 0 | Number indicating the top-border style assigned to the cell. See type_num 9 for descriptions of the numbers returned. | |
---|
12 | | 2 | Number indicating the bottom-border style assigned to the cell. See type_num 9 for descriptions of the numbers returned. | |
---|
13 | | 1 | Number from 0 to 18, indicating the pattern of the selected cell as displayed in the Patterns tab of the Format Cells dialog box, which appears when you choose the Cells command from the Format menu. If no pattern is selected, returns 0. | |
---|
14 | | TRUE | If the cell is locked, returns TRUE; otherwise, returns FALSE. | |
---|
15 | | FALSE | If the cell's formula is hidden, returns TRUE; otherwise, returns FALSE. | |
---|
16 | | 8.43 | A two-item horizontal array containing the width of the active cell and a logical value indicating whether the cell's width is set to change as the standard width changes (TRUE) or is a custom width (FALSE). | |
---|
17 | | 13.5 | Row height of cell, in points. | |
---|
18 | | Arial | Name of font, as text. | |
---|
19 | | 10 | Size of font, in points. | |
---|
20 | | FALSE | If all the characters in the cell, or only the first character, are bold, returns TRUE; otherwise, returns FALSE. | |
---|
21 | | FALSE | If all the characters in the cell, or only the first character, are italic, returns TRUE; otherwise, returns FALSE. | |
---|
22 | | FALSE | If all the characters in the cell, or only the first character, are underlined, returns TRUE; otherwise, returns FALSE. | |
---|
23 | | FALSE | If all the characters in the cell, or only the first character, are struck through, returns TRUE; otherwise, returns FALSE. | |
---|
24 | | 0 | Font color of the first character in the cell, as a number in the range 1 to 56. If font color is automatic, returns 0. | |
---|
25 | | FALSE | If all the characters in the cell, or only the first character, are outlined, returns TRUE; otherwise, returns FALSE. Outline font format is not supported by Microsoft Excel for Windows. | |
---|
26 | | FALSE | If all the characters in the cell, or only the first character, are shadowed, returns TRUE; otherwise, returns FALSE. Shadow font format is not supported by Microsoft Excel for Windows. | |
---|
|
---|