Smart Tags

A Smart Tag is a small icon that appears automatically in your worksheet. Clicking a Smart Tag reveals several clickable options. For example, if you copy and paste a range of cells, Excel generates a Smart Tag that appears below the pasted range (see Figure 2-3).

Excel features several other Smart Tags, and additional Smart Tags can be provided by third-party providers. Not everyone likes Smart Tags but fortunately, they can be turned off by using the Smart Tags tab in the AutoCorrect dialog box (choose Tools ^ AutoCorrect Options to display this dialog box).

|©Book1

TET

x]

A

B | C

D

E

F

G

1

(54.0

(108 01

2

(67.0

(134.0

3

(89.0

(178.0

4

(82.0

J64.0

5

(54.0

(108.0

6

(66.0

(132.0

7

(78.0

(156.pi

8

m

9

ED

10

Keep Solu te F 01 matting

11

0

Match Destination Formattinn

12

o

13

-

14

K.

Values .m l Number Formatting ^

15

o

Values ami Source Formattino

16

c

17

r\ee|i souice column jmouis

18

o

Eormatting Only

19

0

1 ink Tells

20

-

4

. .

» M \Sheet2 i Sheetl /

M

■_

Figure 2-3: This Smart Tag appears when you paste a copied range.

Figure 2-3: This Smart Tag appears when you paste a copied range.

0 0

Post a comment