Office X for Macintosh: The Missing Manual

474 office x for macintosh: the missing manual

sult in the rightmost total row cell; if not, Excel counts the number of occupied rows

showing in your list and shows that result in the cell instead. (You can change this

function using the pop-up Function menu that becomes available when you click

the rightmost cell in the total row.)

But you’re not limited to placing a formula beneath the rightmost column. Using

the Function pop-up menu in each cell of the total row, you can summon a variety

of functions (see Figure 12-27). If you’d rather, you can choose Other and then

work in the Paste Function dialog box to concoct your own, even more complex

formula. (You can even enter any formula you like using the Formula bar, and that

formula needn’t have anything to do with the items in the list.)

Move or delete the whole list object

To move or delete a list object, you must first select it. To perform this surprisingly

delicate operation, click the list to make its frame appear. Then position the cursor

carefully over the upper-left corner of the frame until the cursor turns into a hand.

With the hand cursor, click the upper-left corner to select the entire list object. Now

you can:

• Delete the list by choosing Edit→Clear→All.

• Move the list by choosing Edit→Cut. Then click where you want the upper left

cell of the list to move to, and choose Edit→Paste. Excel moves the list to the new

location. (You can ...