Shortcut menus

Excel also provides "context-sensitive" shortcut menus. If you press the right mouse button (Windows) or press COMMAND+OPTION (Macintosh) while you select a worksheet element with the mouse pointer, a menu is displayed containing commands that apply to the selection. For example, if you select a column while holding down the right mouse button, a shortcut menu containing editing and formatting commands appropriate for a column appears. 

Excel Tip. To display a shortcut menu that lists all sheets in the workbook, right-click on any of the tab scroll buttons (Excel for Windows) or hold down the CONTROL key and click on any of the tab scroll buttons (Excel for the Macintosh). You can then select the desired sheet. 

You set the properties of a control by choosing Control... from the Format menu or Format Control... from the shortcut menu to display the Format Control dialog box for the specific control, then choose the Control tab. Some control properties function only when the control is u ed with a macro. You can set these control properties but they will have no effect on a control installed on a worksheet. 

Choose Customize... from the Tools menu, or choose Toolbars... from the View menu and choose Customize..., or right-click on any toolbar and choose Customize... from the shortcut menu. 

Right-click on the custom menu item to display the shortcut menu. Type the name of the new menu in the Name input box (the default text is " New menu"). 

Right-click on the custom menu item to display the shortcut menu and choose Assign Macro... 

To insert a separator bar above the new menu command, choose Begin a Group from the shortcut menu to remove a separator bar, uncheck Begin a Group from the shortcut menu. 

Right-click on the button to the left of which you want to insert or remove a separator bar, to display the shortcut menu. 

Now right-click on the custom button to display the shortcut menu, and choose Assign Macro..., In the Assign Macro dialog box (Figure 19-6), select the name of the macro to be assigned to the toolbutton. Click the OK button. 

CONTROL Make a non-adjacent selection Display a shortcut menu... 

CONTROL W When using AutoFill, copy a cell or range rather than create a series When using AutoFill, display the shortcut menu... 

ESC D Cancel and close the dialog box or shortcut menu Cancel and close the dialog box or shortcut menu... 

Right-click dm the custom buftonto display the shortcut menu. 3.. In the Name box, type the ToolTip text. ... 

Enter host name, userid, and password (or choose from the shortcut menu) ... 

NOTE The Size and Bytes columns can also be shown in the Workspace browser simply by modifying what to show in the browser via right clicking on any column heading (name) where a shortcut menu pops up and the selection can be made of what entries to show in the Workspace browser. 

---