When you filter a column that contains dates, the Filter panel shows the dates grouped by year, month, and day. When this option is not selected, all the dates in the column display as a flat list.
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 ...
When you see # in a cell, the number is too wide to be displayed. To widen the column to display the number, double-click ...
When you select an option under 'Center on Page' (Margins tab, Page Setup command on the File menu), your data is centered ...
with complete Microsoft Excel formatting. If the object is an OLE control, this includes all extended properties of the control. ...