When you record a macro, click Personal Macro Workbook in the Store Macro In box on the Record Macro dialog box. Your macro will be available each time you start Microsoft Excel.
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. ...
With the Customize dialog box displayed, you can click any toolbar button (not in the dialog box) while holding down CONTROL ...