Datasheet

388
Excel 2010 For Dummies
Table gallery (continued)
range indication, 105
redisplaying, 106
table format, 106–107
table formatting thumbnail, 105
text
accepted cell entry as, 54
angled, 133
color, 295
comment, 211, 213
copying throughout cell range, 75–76
date entered as, 59
effect, 295
footer, 193
header, 193
long entry, 132
orientation, 132–134
rotating, 132
spillover, 54–55
time entered as, 59
title, 295
vertical, 134
wrap, 130–132
text box
adding a, 300–301
adding arrow to, 301–302
deleting, 301
formatting, 300–301
moving, 301
rotating, 301
size, 301
uses for, 299
Text to Speech feature
Speak Cells button, 172–173
spotting error with, 172–173
translation feature, 171–172
theme, 314–315
tilde (~), 220
tiled window, 239–240
time
AM and PM designation, 60
built-in format, 60
entered as text, 59
entered as value, 59
Time number format, 121
title
chart, 291, 293–295
print, 182, 185–187
text, 295
Tools menu command, Excel 2003 and 2010
equivalent, 37–38
Top Align button, 42, 110, 129
Transpose option (Paste Special dialog
box), 167
Transpose (T) option (Paste Options
palette), 163
21st Century date, 61
two-variable data table, 259–261
• U •
Underline button, 109
underlined font, 126
Undo button (Quick Access toolbar), 18
Undo command (Customize Quick Access
Toolbar), 19
Undo feature, 152–153, 372
up sort order, 330
uploading workbook, 360–362
uppercase, 171
• V •
Validation option (Paste Special dialog
box), 166
value
accepted cell entry as, 56
date entered as, 59
function, 82
negative numeric value, 56
numeric, 56–57
pivot table, 270, 272–273
positive numeric value, 56
time entered as, 59
#VALUE! error value, 67
Values & Number Formatting (A) option
(Paste Options palette), 163
Values & Source Formatting (E) option
(Paste Options palette), 163
25_489536-bindex.indd 38825_489536-bindex.indd 388 3/23/10 7:56 PM3/23/10 7:56 PM