Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] calculating investments or loans values before entering in worksheet calculations, dynamic Callouts (shape category) capitalization, changing names in all caps to initial caps CAPS (Status bar indicator) case-sensitive search CEILING( ) function 2nd cell appearance formatting 2nd borders and patterns Bottom Center 2nd Center Across Selection Distributed Distributed (Indent) Fill fonts and color General Justify 2nd Left (Indent) Right (Indent) Top cell ranges colon (:) comma (,) named [See named ranges] spaces as intersection operators cell references 2nd absolute cell formatting and data validation and defined in other worksheets/workbooks moving to new location named [See named ranges] partially fixed relative stored as text cell value formatting numbers Accounting format Currency format custom formats [See custom formats] dates and times Fraction format General format Number format Percentage format Scientific format Special format Text format steps to format CELL( ) function cells appearance [See cell appearance formatting] AutoSelect checking values inside disappearing edge cells editing specific by programming entering formulas entering text in current cell via programming fitting more text into cells formatting cell references [See cell references] formatting in grouped worksheet hidden hiding how changing location affects formulas inserting copied or cut locked maximum number merging modifying in grouped worksheets moving around moving from cell to cell moving to other via programming overlapping putting in edit mode relationship between formatting and values searching formatted selecting selecting continuous range of selecting non-contiguous selecting with Go To selecting with keyboard underlying values value formatting [See cell value formatting] Cells command Center (cell appearance formatting) 2nd Center Across Selection (cell appearance formatting) change tracking 2nd accepting/rejecting changes change log clearing changes from examining understanding creating change report difference between what is tracked and what is highlighted features that don't work with highlighting changes choices merging multiple revisions into one workbook turning on using what is ignored CHAR( ) function chart elements axis data point data points formatting data series adding labels formatting deleting formatting gridlines legend adding list of moving plot area resizing selecting titles adding Chart Location dialog box Chart menu 3-D View command Add Data command Add Trendline command Chart Location command Chart Options command Chart Type command Source Data command Chart Object submenu, Convert option Chart Options Data Labels tab Legend tab chart scale changing for value axis controlling settings Chart toolbar drop-down list Format button Plot Area Chart Type dialog box 2nd chart types area bar bubble column cone 2nd custom cylinder 2nd donut line pie pyramid 2nd radar scatter stock surface XY scatter Chart Wizard 2nd chart types charting non-contiguous data charts bar [See bar charts] category axis changing how Excel plots blank values Interpolated option Not plotted option Zero option changing options Chart Options option Chart Type option Chart Window option coloring background column [See column charts] combination controlling data on X-axis creating data lists [See data lists] data table data that uses date or time scale difference between column and line dragging into Word drawing graphic objects in elements [See chart elements] embedded [See embedded charts] exporting fancy fills [See Fill Effects dialog box] graphical goal seeking how Excel anchors line [See line charts] Location option modifying chart data moving multiple series data in different scales multiple series of numbers non-contiguous ranges organizational overview pivot [See pivot charts] printing embedded standalone refining resizing saving custom settings scientific data, adding error bars to Source Data option standalone trendlines extending Linear trend Polynomial trend Power and Exponential trends Check for Updates command Choose Data Source dialog box 2nd CHOOSE( ) function circular references CLEAN( ) function Clear command Clear Outline command Clear Print Area command clip art 2nd adding to collection graphic file types inserting "Search in" list searching by description Clip Art task Clip Organizer Clipboard one-object rule Clipboard task 2nd 3rd Clippy Close command 2nd clustered column charts CODE( ) function collaboration change tracking [See change tracking] comments [See comments] review chain [See review chain] user identity colon (:) in cell ranges color formatting color, fonts column charts 2nd 3rd 4th 100% stacked 3-D effect clustered gaps, widths, and overlays stacked true 3-D column with two series Column command COLUMN( ) function columns changing into rows deleting formatting in grouped worksheet freezing grouping hiding identification inserting maximum number titles adding types of data width standard width, adjusting 2nd 3rd [See also AutoFill] Columns command COLUMNS( ) function COM (Component Object Model) COMBIN( ) function 2nd combination charts combinations comma (,) in cell ranges Comma [0] style Comma style commands adding new to toolbar or menu special Comment command comments deleting fine-tuning formatting text in comment box hiding/showing inserting navigating printing resizing comment box using Comments command Compare and Merge Workbooks command ’Compare Side by Side with “ command compound documents super- sized compound interest 2nd compressing pictures CONCATENATE( ) function concatenation symbol (&) Conditional Formatting dialog box conditional formulas 2nd AND( ) function COUNTIF( ) function FALSE( ) function IF( ) function NOT( ) function OR( ) function SUMIF( ) function SUMPRODUCT( ) function function) [See SUMPRODUCT( ] TRUE( ) function conditional logic conditional validation rules cone charts 2nd Connectors (shape category) Consolidate dialog box 2nd consolidating data constants naming Contact Us command continuous range of cells, selecting Copy command copy-and-paste drag-and-drop grouped worksheets part of a cell Paste Special feature CORREL( ) function COS( ) function COSH( ) function Count (Status bar shortcut) Count Nums COUNT( ) function SUBTOTAL ( ) function codes and COUNTA( ) function SUBTOTAL ( ) function codes and COUNTBLANK( ) function COUNTIF( ) function 2nd COUPDAYBS( ) function COUPDAYS( ) function COUPDAYSNC( ) function COUPNCD( ) function COUPNUM( ) function COUPPCD( ) function COVAR( ) function crashes, recovering data Create List command 2nd dialog box Create Names tool Ctrl key and arrow keys CUMIPMT( ) function CUMPRINC( ) function cumulative interest Currency [0] style Currency format Currency style custom chart types custom charts saving settings Custom data type data validation custom formats codes that apply currency symbols, percent symbols, and colors creating format strings [See format strings] using custom functions Custom Lists tab custom views naming Custom Views dialog box 2nd custom workspaces quirks Customer Feedback Options command customization mode Customize dialog box 2nd 3rd Categories list Commands tab Toolbars tab customizing Excel 2nd [See also Customize dialog box] Cut command cut-and-paste drag-and-drop grouped worksheets part of a cell Paste Special feature cylinder charts 2nd |