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 sheet.
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 ...
When you filter a column that contains dates, the Filter panel shows the dates grouped by year, month, and day. When this ...
When you record a macro, click Personal Macro Workbook in the Store Macro In box on the Record Macro dialog box. Your macro ...