Page 356 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 339
Index 339
cell entries Chart Type dialog box, 176–177
creating, 15–20 Chart Wizard, 176, 182, 314
hiding, 34 Choose Columns dialog box, 218
cell range circular references, 104–105
defined, 14–15 clip art
entering data in the, 18–20 adding to a spreadsheet, 190–191
printing a, 44–45 button, 190
selecting a, 14–15 inserting, 189–191
selecting from different worksheets, 15 Close Side by Side button, 314–315
selecting for editing a, 56–57 Close Window button, 11
cell reference clustered column chart, 172, 174
absolute, 91 Code Window, 295, 302
converting to other types of references, 92–93 codes in a custom header/footer, 40
as a destination for a hyperlink, 273 col_index_num argument, 142, 151
cell selection moving and copying techniques, colon (:)
61–62 used in cell ranges, 15
cells used in formulas, 75
borders and, 27 color-coding
changing the definition of, 242 worksheet tabs, 310
conditional formatting of, 33–34 worksheets, 14
counting, 137–139 Column Width dialog box, 24, 25
deleting/inserting data, 60–61 columns
entering data in a single, 16–18 deleting/inserting, 60
formatting with the Format Cells dialog box, freezing headings, 312
27–31 hiding, 34–35
formatting with the Format Painter, 32–33 methods of resizing, 24–25
formatting with the formatting toolbar, 26–27 modifying width of in a spreadsheet, 24–25
formatting techniques of, 26–34 orientation of headings of, 30–31
hidden/unhidden format, 224 overriding default width of, 23
locked/unlocked format, 224 redisplaying hidden, 34
moving/copying in the spreadsheet, 61–64 resizing overview, 23
selecting, 13 selecting, 15
chart sorting in a data list, 209–211
changing the location of an existing, 174–176 turning on headings of, 43
clustered column, 172, 174 comma style button, 26
creating a new embedded, 176–179 comma (,) used in formulas, 75
creating a web page with an interactive, 268–269 commands
data series, 172 goal seeking, 240–241
default printing of a, 45 Insert Cells, 60
definition, 172 scenario, 238–240
editing, 182–183 Commands and Options dialog box, 265–266
elements of a, 172–173 comment
embedded, 173 attaching to a spreadsheet, 64–66
embedded cluster bar, 179 hiding a, 66
formatting a, 180–182 indicator, 65
menu, 175 versus text boxes, 197
printing a, 46 comparative formulas, 76
selecting a, 182 comparative operators
text, 173 precedence of, 82
understanding a, 171–176 search criteria and, 206
Chart Options dialog box, 176, 178 Compare Side by Side toolbar, 314–315
chart sheet, 173 CONCATENATE function, 164–167
Chart Source Data dialog box, 176, 178
Chart toolbar, 172, 180