Excel 2010: The Missing Manual
|
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]
Web discussions Web Page Preview command web publishing, worksheets ActiveX and creating interactive web pages direct save approach exported copy of worksheet HTML, converting to interactive web pages problems with publishing versus direct save putting pages on web round-trip feature saving simple web page with HTML data setting save location web queries [See web queries] when interactive web pages make sense web queries creating Edit Web Query window limitations of New Web Query window performing Research task web sites missingmanuals.com Solver WEEKDAY( ) function WEEKNUM( ) function wildcard searching Window menu Arrange command Freeze Panes command Hide command New Window command ’Compare Side by Side with “ command Split command Unhide command Windows 2003 and SharePoint Server Windows taskbar hiding Windows, sharing information in Wingdings font With block (programming) Word and Excel templates dragging charts into WordArt feature workbook sharing how often to be notified of changes multiple users without ’Conflicting changes between users “ setting simultaneous edits turning on understanding workbooks attaching toolbars defined emailing hidden in Visual Basic editor, Project window new opening new protecting [See Protect Workbook dialog box] referencing formulas in other routing to multiple people Send it to a specific reviewer Send it to everyone Send it to the next recipient in the list sending by email sending for review sharing [See workbook sharing] templates [See templates] worksheets [See worksheets] WORKDAY( ) function workgroup templates workgroup templates folder setting with macro Worksheet command worksheets adding and removing adding column titles adding information to data types [See data types] adding pictures blank collaboration [See collaboration] colorful tabs copies creating defined difference between databases and example of XML mapped formatting with outline styles grid grouped [See grouped worksheets] hiding hyperlinks hyperlinks for specific locations maximum moving between moving from one workbook to another moving to new workbook name conflicts naming and rearranging naming conventions navigating using keyboard new print preview versus worksheet view protection 2nd publishing to web [See web publishing, worksheets] referencing formulas in other saving scroll bars splitting [See splitting worksheets] using passwords to prevent unprotecting versus data forms warning about deleting workspaces, custom quirks ’Wrap text “ checkbox
|