Wiley 978-0-471-78346-6 Datenblatt

Stöbern Sie online oder laden Sie Datenblatt nach Software-Handbücher Wiley 978-0-471-78346-6 herunter. Wiley Excel 2003 Visual Encyclopedia Benutzerhandbuch

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 10
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 0
402
Index
A
absolute references, formulas, 212, 393
Accept Changes dialog box, 67
active cells, 13
add
3-D effect, objects, 252
borders to cells, 114–115
cells, 118–119
columns, 17, 140
comments, worksheets, 19
decimals, 25
footers, 282–283
headers, 282–283
misspellings, 102
rows, 304
shadows, 252
subtotals, 170–171
Watch Window, 354–355
worksheets, 374
add-ins
about, 2
Analysis ToolPak, 90
Data Analysis tools, 92–93
find, 91
install, 2, 90–91
load, 90–91
remove, 91
Solver, 90, 94–95
uninstall, 91
Add-Ins dialog box, 2, 90
advanced search, 319
Align Left command, 3
align objects, 253
alignment
about, 3
buttons, 3
cell data, 96–97
commands, 3
Horizontal alignment, 3
Analysis ToolPak add-in, 90, 92–93
Applications tab, 379
apply
cell formatting, 200–203
conditional formatting, 204–205
templates, 334–335
area charts, 389
arrange windows, workbooks, 364–365
arrow style, 210
arrows
Drawing toolbar, 27
formatting, 208–211
ASCII characters, 76
assign
file properties, 294–295
workbook passwords, 296–299
assistant shape, charts, 54
attachments, e-mail, 28
attributes, copy, 266–267
audit
about, 4
error checking, 98–101
AutoCalculate sum cells, 113
AutoCorrect
about, 5, 72
add misspelling, 102
customize, 103
delete words, 103
spelling, 102–103, 327
AutoCorrect dictionary, 5
AutoFill
about, 6
customize, 105
data series, 104
number series, 105
AutoFill handle, 105
AutoFilter
about, 7
Custom View, 22
filter database data, 106–107
AutoFormat
about, 8
customize, 109
preset formatting, 108–109
AutoFormat dialog box, 8
AutoShapes
about, 9
customize, 111
drawing, 110–111
AutoShapes palette, 9
AutoSum
about, 10
total data, 112–113
AutoSum function, 75
AVERAGE function, 39
axes titles, charts, 122
B
balloons, comment, 19
bar charts, 14, 389
Basic File Search task pane, 318–319
bold
about, 11
formatting, 206–207
Bold button, 11
borders
about, 12
add to cell, 114–115
Custom Borders, 115
draw on worksheets, 116–117
erase border lines, 117
Quick Borders, 114
Borders button, 12
bubble charts, 389
build functions, 220–223
C
canvas, 26, 54
CDs, install add-ins, 2
53_783463 bindex.qxd 4/12/06 7:37 PM Page 402
COPYRIGHTED MATERIAL
Seitenansicht 0
1 2 3 4 5 6 7 8 9 10

Inhaltsverzeichnis

Seite 1

402IndexAabsolute references, formulas, 212, 393Accept Changes dialog box, 67active cells, 13add3-D effect, objects, 252borders to cells, 114–115cells

Seite 2

411create, 367delete, 368delete sheet, 378open, 369open automatically, 370open folder automatically, 371print, 290save, 310–311sharing, 347, 372–373wo

Seite 3

Cells, 13cellsadd, 118–119addresses, 13data alignment, 96–97delete contents, 184–185delete formatting, 184–185freeze, 218–219insert comments, 144–145N

Seite 4

404IndexCustom tab, 64Custom View, 22Custom View dialog box, 22custom views, 352–353Custom Views dialog box, 353Customize, 23customizeAutoCorrect, 103

Seite 5

405Ee-mailabout, 28attachments, 28worksheets, 192–193editdatabase records, 176–177functions, 223hyperlinks, 231Edit menuCopy, 20Cut command, 24paste,

Seite 6

406IndexFormat Picture dialog box, 134format styles, 8Formatting toolbar, 50Formula Auditing toolbar, 4, 37, 84Formula bar, 65formulasabout, 392absolu

Seite 7

407Llanguages, spelling, 327layer objects, 259Legend button, 14line charts, 389line colorDrawing toolbar, 27formatting, 208set, 236–237Line Color butt

Seite 8

408IndexPPage Break Preview, 55page breaksabout, 55views, 351page margins, set, 246–247Page Setup dialog box, 42, 56Page tab, 56panesfreeze, 218unfree

Seite 9

409resizecolumns, 143objects, 261rows, 307restore files, 387review changes, tracking, 343–344Reviewing toolbar, 67rotatedata, 164–165objects, 262ROUND

Seite 10

410IndexTTask Managerabout, 378force-quit application, 379Shut Down menu, 379view system, 378Task Pane, 77task panesclose, 33display panes, 332reopen,

Kommentare zu diesen Handbüchern

Keine Kommentare