Shortcut menus

The only menus that remain in Excel 2007 are shortcut menus. These menus appear when you right-click after selecting one or more objects. The shortcut menus are contextsensitive. In other words, the menu that appears depends on the location of the mouse pointer when you right-click. You can right-click just about anything - a cell, a row or column border, a workbook title bar, a toolbar, and so on.

Right-clicking some objects displays a mini-toolbar above the shortcut menu. This toolbar provides quick access to commonly used formatting commands. Figure 2-10 shows the mini-toolbar when a cell is selected.

__A_ e

_ J_

1

i

5

t«Sfe<i -

It ■ ft y t ■ % • J

4

L

n

J f

EL - a» ■ A - -J & jJ

Ï

&

I__v*—

in

7

! *

»

t- -j

S

i

¡3

M

11

12

Lii.di

13

U

15

Pfcli

17

It

14

J

instfl dcaanwil

W

i

frfn.it LtJH.

::

»hj rrpm l-'ïf joap l«. .

ii

Ninx 1 fV'^r

¿6

I

[JlWli-fc.

17

ÏB

H

• 1 ilMll

' ■ ■

Figure 2-10: Right-clicking some objects displays a mini-toolbar.

Figure 2-10: Right-clicking some objects displays a mini-toolbar.

Although you cannot customize the Ribbon by using VBA, you can use VBA to customize any of the shortcut menus.

CROSS- Refer to Chapter 23 for more information about customizing shortcut menus.

REFERENCE

0 0

Post a comment