When you copy and paste formulas containing relative references, the references are adjusted. When you cut and paste formulas, relative references are not adjusted.
When a formula is copied or filled to other cells, the formula's cell references change to the new location. For example, ...
When you click Column on the Format menu and then click AutoFit Selection, the column width will be adjusted to fit the longest ...
When you click the Go To command on the Edit menu, a reference to the current selection is added to the dialog box so you ...
When you copy and paste between workbooks that use different date systems (1900 and 1904), converts the date system of the ...
When you copy and paste formulas containing relative references, the references are adjusted. When you cut and paste formulas, ...
When you create a formula that refers to other cells, it will have the same number format as the first cell it refers to. ...
When you drag over tabs at the bottom of the sheet, use the COMMAND key to stop cells from scrolling and to switch to another ...
When you drag the cell border while holding down CONTROL, a shortcut menu is displayed. From the shortcut menu, you can choose ...
When you enter formulas, type function names in lowercase letters. When you press RETURN, valid function names are converted ...