U

Uncomment Block button, VB Editor, 648

Undo button, 619

Undo tool, Quick Access toolbar (QAT), 14

Union function, 677

unique random integers, generating, 436-437

unit conversions, 277-279

Up/Down Bars option, Chart Tools, 459

UPPER function, 125, 743

Use a Formula to Determine Which Cells to Format rule, 532, 544-546

Use Function option, Subtotal dialog box, 274

Use GetPivotData Function For PivotTable References option, 520

Use in Formula command, 58, 72

Use Row and Column Names check box, 75

UsedRange property, 677-678

Usenet internet service, 769

user interface

customized onscreen display, 18-19

data entry, 19

drag and drop, 17

keyboard shortcuts, 18

object and cell selecting, 19-21

Office Button menu, 14-15

Quick Access Toolbar (QAT), 16

Ribbon, 12-14

shortcut menus and the mini toolbar, 15-16

smart tags, 16-17

task pane, 17

user-defined functions, 113

user-defined functions (UDFs), 624

UserForms, 8