Page 357 - Excel Workbook for Dummies
P. 357
43_798452 bindex.qxp 3/13/06 7:42 PM Page 340
340 Excel Workbook For Dummies
concatenation operator (&) Ctrl key. See also key combinations
precedence of, 82 Fill handle and the, 19
as a text operator, 138 moving graphic objects with the, 186
use of in formulas, 74 moving between ranges of data with the, 13
conditional formatting selecting cell ranges with the, 15
of cells, 33–34 Ctrl+~ (tilde) keys, 78
using to flag all error-trapping formulas, 312 Ctrl+arrow keys, 13
Conditional Sum Wizard Ctrl+Enter keys, 18
dialog box, 134 Ctrl+Home keys
using the, 133–134 entering data with the, 16
constraints, 242 moving between cells with the, 13
Context optional argument (InputBox), 297–298 Ctrl+Page commands, 14
conventions used in this book, 1–2 Ctrl+Tab keys, 11
copy-and-paste, 315 Ctrl+Y redo button, 34
copying Ctrl+Z
data with AutoFill, 19 for editing, 57
data and cells, 61–64 for removing table formatting, 33
data between open workbooks, 315 currency
Excel Workbook folder from the CD, 5 button, 26
formatting to multiple cells with Format as a number format, 28
Painter, 32 cursor. See cell cursor
a formula with AutoFill, 20 Custom AutoFilter dialog box, 213–214
formulas with absolute cell references, 91–92 Custom AutoFilter operators, 214
formulas with mixed cell references, 92–96 custom button deletion, 281
formulas with relative cell references, 90–91 custom function. See also user-defined function
formulas using the Fill handle, 19–20 building spreadsheet formulas with a, 302–303
techniques for cell selection, 61–62 creating in the Visual Basic Editor, 301–302
cost saving as an Excel add-in, 303–305
issues. See depreciation custom menu. See also menu
used to calculate depreciation, 121 assigning hyperlinks to a, 279–281
COUNT function assigning macros to a, 290–291
building formulas with the, 138–139 deleting an item from a, 281
counting cells with the, 137 custom spreadsheet function. See user-defined
subtotaling in data lists with the, 211–212 functions
versus AVERAGE function, 135 Custom Views dialog box, 55, 312
COUNT NUMS function, 253 custom views and editing worksheets, 54–55, 312
COUNTA function customer care for CD, 328
building formulas with the, 138–139 Customize dialog box, 27, 280, 281, 290–291
counting cells with the, 137 customizing headers/footers, 40–41
COUNTBLANK function cut-and-paste, 61–62
building formulas with the, 138–139
counting cells with the, 137
COUNTIF function • D •
building formulas with the, 138–139
counting cells with the, 138–139 data
criteria argument of the, 139 deleting/inserting, 60–61
counting cells and functions, 137–139 moving/copying, 61–64
Create Names dialog box, 311 moving/copying between open workbooks, 315
criteria button, 206 Data Analysis dialog box, 140
Crystal Xcelsius Professional (Business Objects), data entries
4, 326. See also installing CD files building simple text formulas that join, 162–164
editing, 57–58
into a cell range, 18–20
into a single cell, 16–18
