2 Control-Enter after finishing entering some data into a cell
3 sets the whole range of selected cells to that value.
5 On a selection: Enter, Shift-Enter, Tab, Shift-Tab navigate trought
8 Double clicking on a column division automatically adjusts the column
13 1. Selected background + white margin
17 If more than one sheet is selected changes take place on all sheets.
19 Dates are stored as numbers with the format for the date.
21 Today's date is inserted with Control-;
22 Current tiem is inserted as Control-Shift+;
24 The expression: ="5/12/94"-"3/5/98" yields 68
28 Date 1 is Jannuary 1, 1900
30 Texts can be used in a formula:
31 ="Total for "& 1985 displays "Totals for 1985"
33 Hard carriage returns are entered with alt-enter
35 Automatic completion of names is done per column (looked backwards)
37 Alt-down arrow pops up a list of available choices for the autofill
41 Operators, cell references, values, worsheet functions,
44 Arrays: SUM({1,2,3}*4) gets converted to:
52 % (percent, as in 20%)
60 & Concatenates values and returns a string value
62 *** Reference operator
64 Range (colon) Produces one reference to all the cells between
65 and includig the two references.
67 Union (comma) Produces one reference that includes the two
70 Intersection (space) Produces on reference to cells common
74 ="1"+"2" yields 3, Excel does the converion to integers
75 ="A"&TRUE, Excel convers TRUE to a string: ATRUE
79 Control-` Switches between computed formula display and
83 $ is the absolute cell reference
84 R[-2]C Two rows above, same column
85 R[2]C[2] two column down, two right
86 R2C2 Absolute reference to B2
87 R[-1] Entire row above the active cell
91 ='Miguel is a moron'!A1+2
94 They can take any number of arguments
97 The arguments are documented
98 A wizard can be popped up to help with it
101 Database and list management functions
102 Date and time functions
103 DDE and external functions
104 Engineering functions
108 Lookup and reference functions
109 Math and trigonometric functions
110 Statistical functions
116 Result too big to fit in scell