Picturemobileme

739739IndexSymbolsandNumericscharacter,wildcards,Word,240*character,wildcards,Word,240&(ampersand)charactercommandsdisplaying,151#####error,Excel,464#DIV/0error,Excel,464#NAMEerror,Excel,464#N/Aerror,Excel,464NA()function,470#NULL!
error,Excel,464#NUM!
error,Excel,464#REF!
error,Excel,464#VALUE!
error,Excel,464$(dollarsign),Excelabsolutecellreferences,454mixedcellreferences,4543-DFormatcategoryFormatdialog,Excel,4443-DRotationcategoryFormatdialog,Excel,444AAACaudioformatplayingaudiofilesfromAppleiTunes,603absolutecellreferences,Excel,454Acceptoptions,TrackChanges,Word,319,320Accountoption,ArrangeBymenuMessageList,Mail,662Accountingnumberformat,Excel,387Accountspane,OutlookPreferencesaddinge-mailaccounttoOutlook,651IMAP/POPaccounts,652changingaccountsettings,654accounts,Outlookchoosingaccounttosendmessagesfrom,668Actionspop-upbutton,Excel,378activecell,Excel,350moving,351–352whenpressReturnkey,354activetab,Ribbon,28addressbooksseealsoContactscreatingvCardfilesGoogleMail,698–699MacOSXAddressBook,697Yahoo!
AddressBook,698importingcontactsfrom,695Entourage,695,699–700GoogleMail,699MacOSXAddressBook,696–697MobileMe,696–697Yahoo!
Mail,698addressingmessages,Mail,668–670AdvanceSlidegroupTransitionstab,PowerPoint,609AdvancedFinddialog,PowerPoint,95,96AdvancedFindfeature,Outlook,96AdvancedLayoutdialogwrappingtext,129,130makingtextfitobject,131–132AdvancedpreferencespanePowerPointPreferencesdialog,177AdvancedtabFontdialog,Word,223ShareWorkbookdialog,Excel,417aligningtextdirectformatting,90Index740alignmentcells/cellcontents,Excel,389–390justifiedtext,Word,224keyboardshortcuts,91settingnewtabstop,Word,227textonslides,PowerPoint,576Alignmentgroup,Ribbon,Excel,384,385aligningcellcontents,389AlignmenttabFormatCellsdialog,Excel,389,390formattingwithstyles,402Allowpop-upmenuDataValidationdialog,Excel,398Alt+Fshortcutkey,151AlwaysAddClippingSelecteddialogaddingitemstoScrapbook,35Alwayssuggestcorrectionsoptionspellchecking,66animationsseeanimationsunderPowerPointannotationfeatures,PowerPoint,632Appearanimation,PowerPoint,610Applemenuopeningrecentlysaveditems,20applicationsseealsoOfficeapplicationsaddingtoDock,12closing,24CompatibilityReportpalette,36–38hiding,24launchingautomatically,13–14openingfromApplicationsfolder,13openingfromDock,12Toolbox,31–38Applicationspop-upmenuadjustingnumberofitemsin,20AppointmentSerieswindow,Outlook,718Appointmentwindow,Outlookonceonlyappointments,714–716repeatingappointments,717–718appointmentsseeappointmentsunderCalendarareachart,Excel,426Argumentspane,FormulaBuilder,Excel,474arguments,functions,Excel,469–470arithmeticcategory,functions,Excel473arithmeticoperators,Excel,456ArrangeAllcommand,windows,Word,204ArrangeBymenucontacts,Outlook,705MessageList,Mail,661–663Arrangepop-upmenu,windows,Excel,373Arrangesubmenuarranginggraphicalobjectsusing,140ArrangeWindowsdialog,Excel,372–373Arrangementtab,AppleSystemPreferencessettingupPowerPointpresentation,624,625artinsertingSmartArt,137–139artisticeffectsmodifyingpictures,133ascendingsortPivotTables,Excel,536,537asterisks(***)AutoFormatoptions,51attachmentbox,OutlooksendingattachmentstoMailmessages,677attachmentsseeattachmentsundermessages,MailAttachmentsoption,ArrangeBymenuMessageList,Mail,662AudioBrowserpane,MediaBrowser,PowerPointaddingsoundfrom,603audioicon,PowerPoint,605AudioNotestab,RibbonNotebookLayoutview,Word,202audioseesoundunderPowerPointpresentationsauthentication,OutlookaddingExchangeaccount,656addingIMAP/POPaccount,655Authorsicon,statusbar,Wordeditingdocumentssimultaneously,305Authorsoption,ShowMarkupmenucontrollingTrackChangesdisplayed,318Authorsreadout,PowerPointcoauthoringpresentations,565AutoCorrect,43–56AutoFormatAsYouTypeoptions,46–51Index741Automaticallyusesuggestionsfromspellingchecker,46AutoTextoptions,Word,51Capitalizefirstletterofsentences,45Capitalizefirstletteroftablecells,46Capitalizenamesofdays,46CorrectTWoINitialCApitals,45creatingentries,53–54creatingexceptions,54–55MathAutoCorrectoptions,51–53Replacetextasyoutype,46settingup,43ShowAutoCorrectOptionsButtons,45ShowAutoCorrectsmartbutton,45spellchecking,57,58,60standardoptions,45–46AutoCorrectExceptionsdialog,55AutoCorrectpreferencespane,43,185AutoCorrect,Excel,43,44,45resizingdatabasetables,487AutoCorrect,Outlook,43,45addingsignaturestomessages,683AutoCorrect,PowerPoint,43,44,45AutoCorrect,Word,43–44,45AutoTextoptions,51,185insertingboilerplatetext,182insertingspecialcharacters,86MathAutoCorrectoptions,51–53turningAutoCorrectoff,45AutoExpansion,Exceltables,487,488AutoFill,Excel,358creatingcustomlists,359–360enteringdataincellsusing,357–360enteringformulaswith,463AutoFilter,Excelfilteringdatabasetables,492–494AutoFit,Excelsettingcolumnwidth,381settingrowheight,380AutoFit,Wordconvertingtexttotable,250AutoFit,PowerPointbodytexttoplaceholderoption,50AutoFormatAsYouTypeoptions,46–51Excel,47Outlook,47,50–51PowerPoint,47,50Word,46–47,48–50Applyasyoutypearea,48Automaticallyasyoutypearea,49–50boldtext,49borders,48bulletedlists,48fractions,49headings,48hyphenswithemandendashes,49internetandnetworkpathswithhyperlinks,49italics,49listitemformat,50numberedlists,48ordinals(1st)withsuperscript,49quotationmarks,48Replaceasyoutypearea,48–49styles,49tables,48tabsandbackspacesettingleftindent,49automaticrecalculation,Excel,461Automaticallyusesuggestionsfromspellingchecker,46AutoRecoversettingfordocumentbackups,174–175AutoSum,Excelinsertingfunctionsusing,468,470–471AutoText,Word,51applyingdirectformattingontopofstyles,233AutoCorrectpreferences,185creatingAutoTextentry,183insertingprebuiltblocksoftext,182,183–186frommenubar,185printing,335AVERAGE()function,ExcelinsertingfunctionsusingAutoSum,470Axesdialog,Excelformattingsparklines,449,450axes,charts,Excel,425changingscale/numberingofaxes,435–438titlesforaxes,425addingaxistitlestochart,434–435Index742axislabelsaddingfromrangeseparatefromchartdata,439Axislabels,TickspaneFormatAxisdialog,Excel,438BBackgroundOnlyslidelayout,PowerPoint,574background,PowerPoint,547,548backspacesettingleftindentAutoFormatoptions,49backupscreating,Word,193–194settingAutoRecovertokeep,174–175Balloonsarea,TrackChanges,312BandedColumns/Rowscheckboxes,Excelcustomizingdatabasetable,484optionsforPivotTables,529barchart,Excel,426Bccbox,Outlookaddressingmessages,670optionsformessages,671Blankslidelayout,PowerPoint,574Blanksmenu,DesigngroupPivotTables,Excel,528BlockedSenders,Outlookaddingnamesto,685JunkE-mailProtectiondialog,687–688removingsendersfrom,687–688BMP(WindowsBitmap)formatsavingPowerPointpresentationaspictures,643BodyTextstyle,Word,209boilerplatetextcreatingAutoCorrectentries,53inserting,Word,182boldtextAutoFormatoptions,49,51directformatting,90keyboardshortcuts,91Bookmarkdialog,Word,264,265,266bookmarksseebookmarksunderWordBordertab,FormatCellsdialog,Excel,393,402bordersAutoFormatoptions,48formattingtables,105BordersandShadingdialog,Word,229Borderstab,229PageBordertab,230Shadingtab,230BordersandShadingOptionsdialog,230Borderstab,BordersandShadingdialog,229borders,Excel,392–393pastingallexceptborders,363borders,Word,229–230Brazilianrulesspellchecking,67brightnessmodifyingpictures,132BringForwardcommandarranginggraphicalobjects,140BringinFrontofTextcommand,140BringtoFrontcommand,140BroadcastSlideShowdialog,PowerPoint,639–641broadcastingslideshow,PowerPoint,638,639–642browseobjectsSelectBrowseObjectbutton,Word,189browsingcomments,324navigatingfootnotesandendnotes,283bubblechart,Excel,427built-inmenuaddingtotoolbar,152bulletedlistsAutoFormatoptions,48,50bulletedlists,PowerPoint,580–584addingcolor,582creating,580–581customizingbullets,582–584ensuringreadabilityof,581increasingsizerelativetotext,583usingdifferentbulletsymbol,583usingpictureasbullet,584bulletedparagraphs,PowerPointcreating,Outlinetab,561displayingoneatatime,animations,613–615bullets,Worddocumentsaddingtocustomstyle,228Index743applyingdirectformattingontopofstyles,234buttonssmartbuttons,55–56usingtoolbars,28buttons,toolbarschangingappearanceof,150–151changing,Outlook,162,163–164resettingtoolbartodefaultbuttons,159CcalculationsseecalculationsunderExcelworksheeetsCalendar,709–723appointments,713–718onceonlyappointments,713–716repeatingappointments,717–719stoppingrepeatingappointments,719customizingsettings,711–712Daybutton,711displayingdates,711events,713,714–716GotoTodaybutton,710Hoursslider,710interface,709–713keyboardshortcutforswitchingto,660meetings,713invitationsto,722–723scheduling,719–720settingup,719–720trackingstatusofinvitationssent,721Monthbutton,711NavigationPane,659,709Nextbutton,710Outlookinterface,658–667Previousbutton,710synchronizingwithothercalendars,713Timebar,710Weekbutton,711Workbutton,711capitalizationCorrectTWoINitialCApitals,45Capitalizefirstletterofsentences,45Capitalizefirstletteroftablecells,46Capitalizenamesofdays,46Cascadeoption,ArrangeWindowsdialog,Excel,373casematchingFindandReplacedialog,Word,239CasesensitivecheckboxSortOptionsdialog,Excel,490catalog,MailMerge,Wordselectingdocumenttype,288CategoriesdialogorganizingClipGallery,119–120CategorieslistboxCustomizeKeyboarddialog,165insertingfields,Word,266,267Categoriesoption,ArrangeBymenuMessageList,Mail,662Categoriestab,PropertiesdialogaddingpicturestoClipGallery,117categories,charts,Excel,425Categorizebutton,Taskscreatingonceonlytasks,728Categorizepop-upmenu,Outlookcreatingappointments/events,716categoryaxis,charts,Excel,425Ccbox,Outlookaddressingmessages,668CellStylespanel,Excel,403–404cells,ExcelseeExcelcellscells,Word/Powerpoint,103centeringtextdirectformatting,90keyboardshortcuts,91CertificatestabContactwindow,Outlook,693ChangePivotTableDataSourcedialog,Excel,536ChangeQuickStylesSettingsmenu,Word,217–218Changedlinespop-upmenu,TrackChanges,311Changesgroup,RibbonintegratingTrackChangesintodocuments,318chapternumbering,Wordincludingwithpagenumbers,259CharacterSpacingtabFormatTextdialog,PowerPoint,576characterstyle,Word,209Index744charactersinsertingspecialcharactersindocuments,86insertingsymbolsindocuments,82–86wildcardsforsearchinginWord,240chartarea,Excel,424ChartdatarangeboxSelectDataSourcedialog,Excel,431chartsheets,Excel,422movingembeddedchartto,429ChartTitleplaceholder,Exceladdingtitletocharts,434charttitle,Excel,425charttypes,Excel,426–427Chartstab,Ribbon,ExceladdingchartstoPowerPointslides,584creatingcharts,427–428charts,ExcelseeExcelchartscharts,PowerPointaddingExcelcharts,584,589–594animatingcharts,617Checkgrammarasyoutypeoption,67,68Checkgrammarwithspellingoption,67,68Checkspellingasyoutypeoption,65ChooseaFiledialog,PowerPoint,553ChooseaMoviedialog,PowerPoint,600ChooseaPicturedialoginsertingpicturesfromMacfilesystem,121,122linkingpicturestodocuments,123ChooseaPicturedialog,PowerPointaddingpictureasmovieposterframe,602addingpicturestoslides,597ChooseaSounddialog,PowerPoint,609ChooseAudiodialog,PowerPoint,603circularreferences,Excel,467–468clipartaddingpicturestoPowerPointslides,598downloadingmoreMicrosoftclipart,112,118–119inserting,112–115withClipArtBrowser,113–114withClipGallery,114–115managingwithClipGallery,115–120ClipArtBrowserinsertingclipartwith,113–114ClipArtBrowsericon,PowerPoint,112ClipArtGalleryaddingpicturestoPowerPointslides,584ClipGalleryapplicationaddingpicturesto,115–118downloadingclipartfromMicrosoft,118–119insertingclipartwith,113,114–115managingclipartwith,115–120organizingwithcategories,119–120ClipboardaddingitemstoScrapbook,34addingallitems,35clippingsaddingkeywordsto,35Closebutton,titlebar,9Closeoption,Toolbox,33,34closingapplications,24closingdocuments,19Cmd+keyboardshortcutsCmd+,(comma),167Cmd+,91Cmd++,91Cmd+=,91Cmd+8,248Cmd+B,91Cmd+C,91Cmd+Downarrow,Word,189Cmd+E,91Cmd+End,87,189Cmd+Home,87,189Cmd+I,91Cmd+K,106Cmd+L,91Cmd+N,16Cmd+O,22,164Cmd+Option+1,Word,220Cmd+Option+G,Word,245Cmd+Option+M,Word,223Cmd+Option+N,Word,195Cmd+Option+O,Word,195,273Cmd+Option+P,Word,195Cmd+P,164,331Cmd+PageDown,Excel,351Cmd+PageDown,Word,189Index745Cmd+PageUp,Excel,351Cmd+PageUp,Word,189Cmd+Q,9,24Cmd+R,91Cmd+S,16,19Cmd+Shift+E,Word,313Cmd+Shift+N,Word,220Cmd+Shift+P,Excel,345Cmd+U,91Cmd+Uparrow,Word,189Cmd+V,91Cmd+W,19,164Cmd+X,91coauthoringdocuments,Wordeditingsimultaneously,304–308creatingdocument,305editingdocument,306openingdocument,305resolvingconflicts,307,308updatingdocument,306viewingwhoiseditingdocument,305sharingonnetworks,308–309TrackChangesseeTrackChanges,Wordworkingwithcolleagues,303–304coauthoringpresentations,PowerPoint,563–569comparingcopiesofpresentation,568–569editingsimultaneouslywithcolleagues,564–568resolvingconflicts,566reviewingchanges,566CollapseDialogbutton,Excel,360,399,455datavalidation,398SelectDataSourcedialog,431Collapseoption,Toolbox,33,34Colorpop-upmenu,TrackChanges,311,312ColorScalespanelconditionalformatting,Excel,395colorschanging,PowerPoint,547modifyingpictures,133Colorspop-upmenucreatingdocumentsusingtemplates,15columnchart,Excel,426ColumnHeaderscheckbox,ExcelchoosingoptionsforPivotTables,529columnheadings,Excel,349columnidentification,worksheets,Excel,351ColumnLabelsbox,PivotTableBuilder,516addingfields,520changingPivotTable,523,524Columnpanel,charts,Excel,428columnsparkline,Excel,446ColumnWidthdialog,Excel,381,382columnwidths,Excelpasting,364Columnsdialog,Word,261columns,ExcelseecolumnsunderExcelworksheetscolumns,WordseecolumnsunderWordCombineDocumentsdialog,Word,327CommarequiredbeforelastlistitemoptionGrammarSettingsdialog,70CommandkeyshortcutsseeCmd+keyboardshortcutsCommandPropertiesdialog,150–151commandscreatingcustomtoolbars,157–158customkeyboardshortcuts,Word/Excel,164–167usingmenus,27usingRibbon,28–29,30usingtoolbars,28Commandslistbox,CustomizeKeyboarddialog,166Commandstab,CustomizeToolbarsandMenusdialog,148addingbuilt-inmenutotoolbar,152addingcommandtotoolbar,149addingitemstomenus,153creatingcustomtoolbars,157–158creatingnewmenu,154–155removingcommandfromtoolbar,150comma-separatedvaluesconvertingtabletotext,Word,251convertingtexttotable,Word,248,249comments,Excelpasting,363comments,WordseecommentsunderWordIndex746CompactLayout,DesigngroupPivotTables,Excel,526,527CompareChangespane,PowerPointcomparingtwocopiesofpresentation,569resolvingconflicts,566reviewingchangesbycoauthor,567,568CompareDocumentsdialog,Word,326,327Comparisonsettingsarea,328Labelchangeswithtextbox,327Originaldocumentpop-up,327Reviseddocumentpop-up,327Showchangesarea,328Comparefeature,PowerPointcollaboratingonpresentations,564comparingtwocopiesofpresentation,568–569comparingdocumentsseeDocumentCompare,Wordcomparisonoperators,Excel,457ComparisonsettingsareaCompareDocumentsdialog,Word,328Comparisonslidelayout,PowerPoint,573Comparisonscategory,CellStylespanel,Excel,403compatibilitycategory,functions,Excel474Compatibilitypreferencespane,Excel,173CompatibilityReportpalette,Toolbox,36–38compatibilitywithearlierversions,Word,340–341CompleteMergesection,Word,298compressingpictures,136–137concatenationoperator,Excel,457ConditionalFormattingpanel,Excel,394conditionalformatting,Excel,394–397NewFormattingRuledialog,396pasting,364presetconditionalformatting,394–397confidentialinformation,Wordremovingsensitiveinformation,335–337ConfirmPassworddialog,Word,338ConflictResolverdialog,Outlookmergingcontacts,697ConflictingchangesbetweenusersareaShareWorkbookdialog,Excel,418ConflictsResolvedbar,Wordeditingdocumentssimultaneously,307connectionssettingupPowerPointpresentation,624Contactwindow,Outlook,693Contacts,689–707addressingmessages,Mail,669arrangingcontacts,705communicatingwithcontacts,706–707creatingcontacts,689–694addingphoto,690assigningtocategory,694digitalcertificates,693enteringaddresses,692enteringe-mailaddress,691enteringnotes,693enteringorganizationinformation,693enteringpersonalinformation,692enteringphonenumbers,691quickmethod,692editingcontactinformation,706importingcontactsCSVfile,695,700–702Excelworksheets,703usingSyncServices,695,696–697importingcontactsfromaddressbooks,695Entourage,695,699–700GoogleMail,699MacOSX,696–697MobileMe,696–697Yahoo!
Mail,698importingcontactsfromvCardfiles,695,702GmailorGoogleMail,698–699MacOSXAddressBook,697Yahoo!
Mail,698keyboardshortcutforswitchingto,660NavigationPane,659Outlookinterface,658–667searchingforcontacts,706viewingcontacts,704–705ContactsSearchwindow,Mailaddressingmessages,669contentplaceholders,PowerPointaddinggraphicalcontenttoslides,584addingpicturestoslides,597addingSmartArtgraphicstoslides,589Index747ContentwithCaptionslidelayout,PowerPoint,573contextmenus,PowerPointcustomizingcontextmenus,146,156movingbetweenslides,630,631Continuoussectionbreak,Word,253contrastmodifyingpictures,132controlinterfaces,Officeapps,25controls,Ribbon,29Conversationsoption,ArrangeBymenuMessageList,Mail,662,663ConvertNotesdialog,Word,282,283ConvertTabletoTextdialog,Word,250–251ConvertTexttoTabledialog,Word,249–250CopyandPastecommands,91–92enteringtextindocuments,81copying,worksheets,Excel,368movingdatawithdraganddrop,365–366CorrectTWoINitialCApitals,45Correctionspanel,FormatPicture,132,133COS()function,Excel,473COUNT()function,Excel,469functionsinPivotTables,525insertingfunctionsusingAutoSum,470COUNTBLANK()function,Excel,484CreateDataSourcedialog,Word,290CreatePivotTabledialog,Excel,513–514Criteriabutton,Formdialog,Excelenteringdataintodatabasetables,487croppingpictures,134–136PowerPoint,598cross-references,Word,270–272insertingfields,268CSVfileimportingOutlookcontactsfrom,695,700–702Currencynumberformat,Excel,386,387cursormovinginsertionpointtolastfouredits,190CustomAnimationpane,PowerPointchangingorderofanimations,612–613Customcategory,CellStylespanel,Excel,403customdictionaries,71–75addingwordsto,73creating,72–73deleting,75editing,73,74grammarchecking,74removing,75removingwordsfrom,73savingdictionaryfile,74,75spellchecking,67,71,73,75turningoff,75CustomDictionariesdialog,71,72CustomListdialog,Excel,489CustomListsdialog,Excel,359–360Customnumberformat,Excel,388CustomShowsdialog,PowerPoint,620–622CustomizeKeyboarddialog,164CustomizeToolbarsandMenusdialogCommandstab,148addingbuilt-inmenutotoolbar,152addingcommandtotoolbar,149addingitemstomenus,153creatingcustomtoolbars,157–158creatingnewmenu,154–155removingcommandfromtoolbar,150findingcommandstoaddtotoolbars/menus,148–149preparingtocustomize,146–148ToolbarsandMenustab,147creatingcustomtoolbars,157customizingcontextmenus,PowerPoint,156deletingcustomtoolbars,158customizingmenubar,146,154–156changingorderofmenus,156creatingnewmenu,154–155preparingto,146–148removingexistingmenu,156customizingmenus,146,153–154addingitemstomenus,153changingappearanceofmenuitem,150–151contextmenu,PowerPoint,146findingcommandstoaddtomenus,148–149movingmenuitem,153preparingto,146–148Index748removingitemsfrommenus,154renamingmenuitem,154customizingRibbon,159–161customizingtoolbars,146,149–152addingbuilt-inmenutotoolbar,152addingcommandtotoolbar,149changingappearanceofbutton,50–151creatingcustomtoolbars,157–158deletingcustomtoolbars,158findingcommandstoaddtotoolbars,148–149Outlook,162–164preparingto,146–148removingcommandfromtoolbar,150repositioningitemsontoolbar,150Cutcommand,91–92DDataandModelcategory,CellStylespanel,Excel,403DataBarspanel,Excel,395DataFormdialog,Word,291,292datalabels,charts,Excel,426,439datamarkers,charts,Excel,425dataseries,charts,Excel,425,432–433datasource,charts,Excel,430–431datasource,MailMerge,Word,286creatingnewdatasource,289–293openingexistingdatasource,293usingcontactsfromFileMakerProdatabase,294MacOSXAddressBook,293OfficeAddressBook,293Datatab,PivotTableOptionsdialog,Excel,533–535datavalidationseedatavalidationunderExceldatabasecategory,functions,Excel473databasetablesseedatabasetablesunderExcelDateandTimecategoryfunctions,Excel473insertingfields,Word,266,267Datenumberformat,Excel,386,387Dateoptions,ArrangeBymenuMessageList,Mail,662Datevalue,DataValidationdialog,Excel,399datesdisplaying,Calendar,711howExcelstoresdates,388DatesandReminderdialog,Outlook,734Daybutton,Calendar,711Dayview,OutlookcustomizingCalendarsettings,712DEC2HEX()function,Excel,473Decimalvalue,DataValidationdialog,Excel,398defaultfolderssavingdocuments,Word,175–176savingpresentations,PowerPoint,177Defaultremindercheckbox,Calendar,712DefaultSignaturesdialog,Outlook,684DefineCustomShowdialog,PowerPoint,620–621,622DefineNamedialog,Excelreferringtonamedcells/ranges,455,456Deletedialog,Excel,379,380deletingitemsfromScrapbook,35Deletionsoption,ShowMarkupmenucontrollingTrackChangesdisplayed,318Deletionspop-upmenu,TrackChanges,311deliveringpresentationsseedeliveringpresentationsunderPowerPointpresentationsdepthaxis,charts,Excel,425descendingsort,PivotTables,Excel,536,537Descriptionarea,FormulaBuilder,474Descriptiontab,PropertiesdialogaddingpicturestoClipGallery,117Designgroup,Ribbon,ExcelPivotTables,526–528Detailstab,Contactwindow,Outlook,693dictionariesseealsocustomdictionariesReferenceToolspalette,36digitalcertificatescreatingcontacts,693Outlook,694Index749settingupforsigning/encryption,672–673digitaldistributioncreatingPDFdocuments,342digitalsignatureapplying,Mailmessages,672settingupdigitalcertificatesfor,672–673directformattingkeyboardshortcuts,90textandobjects,88–91directformatting,Word,208applyingontopofstyles,233–234FormatPainterfeature,208,234removingfromtext,234togglingguidesonandoff,215Disappearanimation,PowerPoint,610disasterrecovery,Word,194Displaytab,PivotTableOptionsdialog,Excel,529,530–531Displayspane,AppleSystemPreferencessettinguppresentation,624,625DIV/0error,Excel,464Dock,theaddingapplicationsto,12closingapplications,24openingapplicationsfrom,12openingrecentlysaveditems,23savingspaceon,9DocumentAutomationcategory,Word,267DocumentCombine,Worddifferentversionsofdocument,326sharingdocumentsonnetworks,309DocumentCompare,Worddifferentversionsofdocument,326–328workingondocumentswithcolleagues,304DocumentInformationcategory,Word,267documentlayerscontrollingvisibilityofgraphicalobjects,140–141DocumentMappane,Sidebar,Word,235documentproperties,Wordprinting,335Documenttab,InsertHyperlinkdialog,107Documentsfoldersavingdocuments,17Documentspop-upmenuadjustingnumberofitemsin,20documents,OfficeseeOfficeapplicationsdocuments,WordseeWorddocumentsdocxformat,Word,341dollarsign($),Excelabsolute/mixedcellreferences,454domainscreatinglistofsafedomainsfore-mail,686–687dotxformat,Word,341doughnutchart,Excel,427Downoption,FindandReplacedialog,239Draftview,Word,199–200iconrepresenting,194keyboardshortcuts,195viewingstylesusedbydocument,220,221drag-and-droppointer,Excelcopying/movingdata,365drawingtables,102Word,247Durationbox,PowerPointchangingdurationoftransitions,609controllingwhenanimationruns,612Durationpop-upmenu,Outlookcreatingappointments/events,715DynamicContenttransitions,PowerPoint,606dynamicreorderingarranginggraphicalobjects,141EEditHyperlinkdialog,109EditScheduledialog,Outlook,675Editingtab,ShareWorkbookdialog,Excel,417Editsbrowseobject,Word,190EffectOptionspanel,PowerPointaddinganimationtoobject,611animatingcharts,617animatingSmartArtgraphic,615choosingoptionsfortransitions,608displayingbulletedparagraphsindividually,613effectsmodifyingpictures,133Index750Effectspanelrefiningshapeswith,126,127ellipsis(.
.
.
)AutoFormatoptions,50extraarguments,functions,Excel,469emandendashesAutoFormatoptions,49,50e-mailseealsoMailbroadcastingPowerPointslideshow,641deliveringPowerPointpresentations,637e-mailingPDFversionofdocument,79messagesseemessages,Mailsendingdocumentsvia,38–39E-mailAddresstab,InsertHyperlinkdialog,107,108e-mailmessagescompletingmailmerge,Word,300–301embeddedcharts,Excel,422movingtochartsheet,429Emphasischaracterstyle,Word,209EmphasisEffectsanimations,PowerPoint,610encryptionapplying,Mailmessages,672settingupdigitalcertificatesfor,672–673endnotesseeendnotesunderWordengineeringcategory,functions,Excel473EnterMappingNamedialog,Outlook,702Entirerow/columnoptions,ExcelDeletedialog,380Insertdialog,379EntourageforMacimportingOutlookcontactsfrom,695,699–700EntranceEffectsanimations,PowerPoint,610,611envelopes,MailMerge,Wordselectingdocumenttype,288EquationsandFormulascategoryinsertingfields,Word,267equations,Wordaddingcross-references,271errors,ExcelseeerrorsunderExcelevennumberedpages,Worddocumentsaddingheadersandfooters,254,256,257addingsectionbreaks,253Evenpagesectionbreak,Word,253events,Calendar,713creatingevents,714–716Excel,5seealsoExcelworkbooks;OfficeapplicationsActionspop-upbutton,378Alignmentgroup,384,385ArrangeWindowsdialog,372–373AutoCorrect,43,44,45AutoFilloptions,358AutoFilterfeature,492–494AutoFormatoptions,47automaticrecalculation,461Axesdialog,449,450CellStylespanel,403–404cellsseeExcelcellsChangePivotTableDataSourcedialog,536chartsseeExcelchartscircularreferences,467–468CollapseDialogbutton,360,398,399,431,455columnheadings,349ColumnWidthdialog,381,382ConditionalFormattingpanel,394copying/movingdatawithdraganddrop,365–366CreatePivotTabledialog,513–514creatingAutoCorrectexceptions,54creatingcustomkeyboardshortcuts,164–167CustomListdialog,489datavalidation,397–401formattingworksheets,397–401pastingdataintoworksheets,397pastingdata-validationcriteria,363DataValidationdialog,397–401ErrorAlerttab,400–401Ignoreblankcheckbox,399InputMessagetab,398,399–400Settingstab,397–399databasetables,479–494checkingforduplicaterecords,490creating,480,481–482Index751customizingappearanceof,482–484enteringdatainto,485–487filtering,492–494flat-filedatabase,480relationaldatabase,480removingduplicaterecords,491–492renaming,482resizing,487–488searchingforrecords,492sorting,488–490DefineNamedialog,455,456Deletedialog,379,380directformatting,88errorscircularreferences,467–468DataValidationdialog,400–401errormessages,464seeingerrordetails,464–465tracingerrortosource,465fieldsaddingtoPivotTableframework,517–521creatingdatabasetables,480,481sortingdatabasetablesby,488–490Finddialog,95,492Fontgroup,384Footerdialog,408–409FormatAxisdialog,435–438FormatCellsdialog,385–394FormatWallsdialog,442–443Formattingtoolbar,383formulabar,349,356,459,460GoalSeek,495,505–507GoalSeekStatusdialog,506graphicalobjects,inserting,112Headerdialog,408–409Headerrow,483Header/Footertab,PageSetup,407–410HideRow/Columnoptions,382Hometab,Ribbon,384horizontalalignmentoftext,389howdates/timesarestored,388ImportCellStylesdialog,406indentingtext,390Insertbutton,Cellsgroup,Ribbon,378Insertdialog,378,379insertingsymbolsinworkbooks,82,83Markersdialog,448,449MergeScenariosdialog,503mergingcells,390ModifyCellStyledialog,405MoveChartdialog,429movinginsertionpoint,87NewCellStyledialog,404–405numberformats,387–388Numbergroup,384,385operators,456–461precedenceof,461–462PageSetupgroup,413PasteSpecialdialog,362–364PivotTableFielddialog,525–526PivotTableOptionsdialog,529–535Datatab,533–535Displaytab,529Displaytab,530–531Layouttab,532–533renamingPivotTables,530PivotTablesseePivotTables,Excelpreferences,167–177previewingdocument,79Printdialog,411,414printingdocuments,76referencearea,349Replacedialog,98replacingtext,98ResolveConflictsdialog,419–420Ribbon,11rotatingtext,390rowheadings,349RowHeightdialog,380,381SaveChartTemplatedialog,445savingdocuments,18choosingdefaultformatfor,173–174ScenarioManagerdialog,497–500ScenarioValuesdialog,499–500scenarios,495–505applyingprotectionto,501creating,498,500creatingreportsfrom,503–505creatingworksheetfor,495–497deleting,501editing,501examining,495merging,502–503Index752openingScenarioManagerdialog,497switchingbetween,501scrollbuttons,350Searchbox,Standardtoolbar,93,94SelectAllbutton,350SelectDataSourcedialog,430–431ShareWorkbookdialog,417–418shrinkingtexttofitcells,390smartbuttons,56Solver,507Sortdialog,489–490SortOptionsdialog,490sortingdata,490sparklines,446–450spellchecking,57–60,63splitboxes,350styles,88applying,404applyingtocharts,433CellStylespanel,403–404copyingbetweenworkbooks,406creatingcustomstyles,404,405customizingappearanceofdatabasetable,482deleting,407formattingworksheetswith,402,407Hyperlinkstyle,404ModifyCellStyledialog,405NewCellStyledialog,404,405PivotTables,528,529tables,99themes,388toolbars,10Toolbox,32trends(sparklines),446–450UnhideRow/Columnoptions,382verticalalignmentoftext,389viewbuttons,350views,369FullScreenview,369Normalview,369PageLayoutview,369windowsArrangepop-upmenu,373ArrangeWindowsdialog,372–373arrangingwindows,372–373changingwindow,372hidingwindows,373openingextrawindows,371splittingtoviewseparatepartsofworksheet,370–371zooming,373–374workbooksseeExcelworkbooksworksheetsseeExcelworksheetswrappingtext,390Zoomdialog,374Zoompop-upmenu,373ExcelCannotCalculateaFormuladialog,467Excelcellsactivecell,350aligningcontentof,389–390borders,392–393cellidentification,351cellreferencesabsolutereferences,454cellidentification,351informulasandfunctions,452–453mixedreferences,454referenceoperators,457referringtocellindifferentworkbook,453referringtonamedcells,455–456relativereferences,454worksheetnamecontainsspaces,453centeringtextacrossmultiplecells,389conditionalformatting,394copying/movingdatawithdraganddrop,365–366deleting,379editingdatain,355–356enteringdataintoworksheets,354PasteSpecialdialog,362–364pastingdataintoworksheet,361–364pastingpartofdataandformatting,362–364usingAutoFill,357–360fills,393fontformatting,391FormatCellsdialog,385–394Alignmenttab,389Bordertab,393Index753Filltab,393Fonttab,391Numbertab,386Protectiontab,393formatting,383–394horizontalalignmentoftext,389indentingtext,390inserting,377–379justifyingtext,389merging,390movingactivecell,351–352whenpressReturnkey,354numberformatting,386–388numberineachworksheet,351protecting,393rangesconditionalformatting,394datavalidation,397printingworksheets,411referenceoperators,457selectingmultiplecells,352–354toolsforformatting,383ranges,referringtoinformulasandfunctions,454namedranges,455–456ondifferentworksheet,454referencestoinformulasandfunctions,452–453indifferentworkbook,453namedcells,455–456whenworksheetnamecontainsspaces,453rotatingtext,390selecting,352–354adjacentcells,352allcells,354columnofcells,354multiple(rangeof)cells,352–354non-adjacentcells,353rowofcells,354shrinkingtexttofit,390spacingouttextacrosscell,389Stylespanel,403–404toolsforformatting,383–385verticalalignmentoftext,389viewingcellsusedbyformula,466wrappingtext,390Excelcharts,421–446addingaxislabelsfromseparatecells,439addingdatalabels,439addinglegend,438addingseparatedataseries,432–433addingtitle,434addingtoPowerPointslides,584,589–594copyingexistingExcelchart,592–594creatingchartforPowerPoint,590–592animatingPowerPointcharts,617applyingstyleto,433areachart,426axes,425addingaxistitlestochart,434–435changingscale/numberingofaxes,435–438titlesfor,425barchart,426bubblechart,427categories,425changingtype,430chartarea,424chartsheets,422choosinggridlinestodisplay,440–441choosinglayoutfor,432columnchart,426components,423–426copyingformatting,444–445creating,427–429datalabels,426datamarkers,425dataseries,425decoratingwalls/floors,441–443depthaxistitle,425doughnutchart,427embeddedcharts,422movingtochartsheet,429FormatWallsdialog,442–443formattingindividualelements,443–444gridlines,426horizontalaxistitle,425linechart,426MoveChartdialog,429piechart,426Index754plotarea,424radarchart,427repositioning,428resizing,429reusingcustomdesigns,445–446scatterchart,426sparklines,446–450columnsparkline,446formatting,448–450inserting,447–448linesparkline,446win/losssparkline,446stockchart,426surfacechart,426switchingdatasource,430–431switchingrowsandcolumns,430titleforchart,425addingtitletocharts,434types,426–427verticalaxistitle,425ExcelPreferencesdialog,168–169changingnumberofworksheetsinblankworkbook,366Compatibilitypreferencespane,173displaying,345formattingcells,383ExcelWorkbookGallerydialogcreatingworkbooks,345,346opening/notopeningonlaunch,345Excelworkbooksautomaticrecalculation,461changingnumberofworksheetsinblankworkbook,366cellsseeExcelcellschartsseeExcelchartscopyingstylesbetween,406creating,345–347basedonexistingworkbook,347blankworkbook,346onlinetemplate-basedworkbook,347template-basedworkbook,346deletingworksheets,367formats,173GoalSeek,505–507insertingworksheets,366–367navigating,348–354openingextrawindows,371printing,411–414protecting,415–416protectingworksheets,416–417rearrangingworksheets,367–368saving,16–19,347–348asearlierversions,348choosingdefaultformatfor,173–174settingAutoRecoverforbackups,174–175ShareWorkbookdialog,417–418sharedworkbooks,415–420editing,417–418resolvingconflictsin,419–420restrictionswhenworkingin,419worksheettabs,350worksheetsand,350ExcelworksheetsseealsoOfficeapplicationsactivecell,350addingheadersandfooters,407–411addingdirectlyonworksheet,410–411usingPageSetupdialog,407–410arrangingwindows,372–373calculationsabsolutecellreferences,454automaticrecalculation,461cellreferences,452–453formulas,456–468formulas/functionscompared,452functions,468–476mixedcellreferences,454operatorprecedence,461–462operators,456–461rangereferences,454referringtonamedcellsandranges,455–456relativecellreferences,454cellsseeExcelcellschangingnumberofworksheetsinblankworkbook,366changingwindow,372chartsseeExcelchartscircularreferences,467–468columnheadings,349Index755columnscolumnidentification,351creatingdatabasetables,480deleting,379freezingheadingrowsand,374–375hiding,382inserting,377–379numberineachworksheet,351selectingcolumnofcells,354settingcolumnwidth,381–382switchingrowsandcolumnsinchart,430comments,pasting,363copying,368copyingchartintoPowerPointfrom,590,592–594copying/movingdatawithdraganddrop,365–366creatingchartforPowerPointin,589,590–592deleting,367displaying,369–375views,369displayingallformulasin,465–466editingdata,355–356enteringdatainto,354PasteSpecialdialog,362–364pastingdata,361–364pastingpartofdataandformatting,362–364usingAutoFill,357–360formatting,377–411addingheadersandfooters,407–411alignmentofcellcontents,389–390applyingstyles,404borders,392–393cells,26,383–394conditionalformatting,394–397copyingchartformatting,444–445copyingstylesbetweenworkbooks,406creatingcustomstyles,404–405decoratingchartwalls/floors,441–443deletingrows/cells/columns,379deletingstyles,407directformatting,88–91fills,393fontformatting,391hidingrows/columns,382individualchartelements,443–444insertingrows/cells/columns,377–379NewFormattingRuledialog,396numberformatting,386–388pastingformatting,362–364PivotTables,528–529protectingcells,393settingcolumnwidth,381–382settingrowheight,380–381sparklines,448–450styles,402–407tableformatting,402text,88themes,388toolsfor,383–385validatingdata,397–401formulabar,349formulas,456–468absolutecellreferences,454cellreferencesin,452–453displayingall,465–466enteringwithAutoFill,463functionscompared,452mixedcellreferences,454operatorprecedence,461–462operators,456–461pasting,363,364rangereferencesin,454referringtonamedcellsandranges,455–456relativecellreferences,454ScenarioValuesdialog,500troubleshooting,468viewingcellsusedby,466freezingheadingrowsandcolumns,374–375functions,468–476absolutecellreferences,454accessingfullrangeof,484arguments,469–470cellreferencesin,452–453circularreferences,467–468formulascompared,452functionnames,469Index756insertingintoworksheet,468,476insertingusingAutoSum,470–471insertingusingFormulaBuilder,471–475insertingusingInsertpop-upmenu,475–476mixedcellreferences,454rangereferencesin,454referringtonamedcellsandranges,455–456relativecellreferences,454troubleshooting,468typingintoworksheet,476headersandfootersaddingdirectlyonworksheet,410–411addingtoworksheets,407–411addingusingPageSetupdialog,407–410GoalSeek,505–507importingOutlookcontactsfrom,703inserting,366–367keyboardshortcuts,357insertingsparklines,447–448movingtonext/previousworksheet,351navigating,348–354openingextrawindows,371operators,458–461PivotTablesseePivotTables,Excelprinting,76–79,411–414checkingpagelayout,412–414settingprintarea,411–412rearranging,367–368referencearea,349rowheadings,349rowscreatingdatabasetables,480deleting,379freezingheadingrows,374–375hiding,382inserting,377–379numberineachworksheet,351rowidentification,351selectingrowofcells,354settingrowheight,380–381switchingrowsandcolumnsinchart,430scrollbuttons,350SelectAllbutton,350sharedworkbooks,38–42,415–420editing,417–418protectingworkbook,415–416protectingworksheets,416–417resolvingconflicts,419–420restrictionswhenworkingin,419sparklines,adding,446–450splitboxes,350splittingwindowtoviewseparateparts,370–371tabbar,350,351tabs,350viewbuttons,350workbooksand,350zooming,373–374exceptionscreatingAutoCorrectexceptions,54–55Exchangeaccountaddinge-mailaccounttoOutlook,651,656–657Exchangeaccountinformationdialog,656Excitingtransitions,PowerPoint,606ExitEffectsanimations,PowerPoint,610,611Extendmode,Word,187ExtendSelectionfeatureWord,187–188FFadeoption,Toolbox,33,34FALSE()function,Excel,473FerrisWheeltransition,PowerPoint,606Fielddialog,Word,266–268FieldNamelistbox,PivotTableBuilder,516addingfields,517,518,520changingPivotTable,521,523,524FieldOptionsdialog,Word,268,269,270fields,ExcelseefieldsunderExcelfields,WordseefieldsunderWordfigures,Wordaddingcross-references,271fileconvertersforWindowscompatibilitywithearlierversions,340fileextensionshowingassavingdocuments,18Index757FileLocationspreferencespane,Word,175,176specifyinglocationforcustomtemplates,192Filemenuclosingapplications,24openingrecentlysaveditems,22filesizecompressingpictures,136filesysteminsertingpicturesfromMac,121–122Fillcategory,Formatdialog,Excel,444Fillpanelrefiningshapeswith,126,127Filltab,FormatCellsdialog,Excel,393formattingwithstyles,402fills,Excel,393Filteroption,AutoFilter,Excel,493FilterRecipientssectionMailMergeManagerpane,Word,296filteringdatabasetables,Excel,492–494AutoFilterfeature,492–494comparisons,494removingfiltering,494filteringrecipients,MailMerge,286,295–297QueryOptionsdialog,296filteringtasks,Outlook,732filtering,PivotTables,537–539Finaloption,TrackChanges,Wordviewingmarkup,316FinalShowingMarkupoption,316finalslide,PowerPointplanningslidesforpresentation,573financialcategory,functions,Excel473FindandReplacedialog,Word,94,95,237–245changingsearchUp/Downoptions,239expandingdialog,238Findallwordformsoption,240FindNextbutton,243Findtab,238Formatpop-upmenu,242NoFormattingbutton,243Specialpop-upmenu,241Findwholewordsonlyoption,239findingformatting,241–243Formatpop-upmenufindingformattingorstyles,242replacingformattingorstyles,245GoTotab,245–246Highlightingallitemsfoundinoption,238Matchcaseoption,239navigatingfootnotesandendnotes,283opening,238removingformattingcriteriafromsearch,243ReplaceAllbutton,244Replacebutton,244Replacetab,243replacingformattingorstyles,244–245replacingtext,97,243–244searchingforspecialcharacters,241searchingonlyatstart/endofwords,241searchingonlypartofdocument,239Soundslikeoption(words),240specialcharacters,238Usewildcardsoption,240wildcards,238Findbrowseobject,Word,190Finddialog,Excel,95Finddialog,Outlook,96Findoptions,Excel,492FinderaddingapplicationstotheDock,12addingpicturestoPowerPointslides,597insertingpicturesindocuments,122openingapplicationsfromApplicationsfolder,13openingdocuments,21findingtextAdvancedFinddialog,PowerPoint,95,96FindandReplacedialog,Word,237–243Officeapplications,93–97Searchbox,Standardtoolbar,93–94,236Searchpane,Sidebar,Word,237FirstColumncheckbox,Excel,484firstpage,Worddocumentsheadersandfooters,254,256Flagrepeatedwordsoptionspellchecking,66Index758FlagStatusoption,ArrangeBymenuMessageList,Mail,662flat-filedatabase,Excel,480FleschReadingEasestatistic,68Flesch-KincaidGradeLevelstatistic,68floatingtoolbarschangingsizeorshapeof,145CustomizeToolbarsandMenusdialog,147dockingandundocking,144–146flowchartinsertingSmartArt,137Folderoption,ArrangeBymenuMessageList,Mail,662folderscreatingmailfolders,Outlook,682creatingnewfolder,17JunkE-mailfolder,Outlook,685movingmessageto,Outlook,681–682navigatingtodifferentfolderforsave,18Fontcategory,Formatdialog,Excel,444Fontdialog,Word,222–223fontformatting,Excel,391fontformatting,Word,222–223applyingdirectformattingontopofstyles,233Fontgroup,Ribbon,89choosingfontformattingforstyle,222directformatting,Word,208Excel,384formattingtextonslides,PowerPoint,575,576FonttabFormatCellsdialog,Excel,391,402FormatTextdialog,PowerPoint,576fontschanging,PowerPoint,547directformatting,90formattingtables,105keyboardshortcuts,91Fontspanel,PowerPointchangingthemes,547Fontspop-upmenucreatingdocumentsusingtemplates,15fonts,Wordfindingformattingbasedon,242Footerdialog,Excel,408–409footersseeheadersandfootersunderWordFootnoteandEndnotedialog,Wordaddingfootnotesandendnotes,278convertingbetweenfootnotes/endnotes,282customizingfootnotesandendnotes,281–282Footnotebrowseobject,Word,190footnotesseefootnotesunderWordforecastingGoalSeek,Excel,505Formdialog,Excelenteringdataintodatabasetables,485–487resizingdatabasetables,487formletters,MailMerge,Wordselectingdocumenttype,288FormatAxisdialog,Excelchangingscale/numberingofaxes,435–438Scalepane,435–437Tickspane,437–438FormatCellsdialog,Excel,385–394Alignmenttab,389Bordertab,393Filltab,393Fonttab,391formattingwithstyles,402Numbertab,386Protectiontab,393Formatdialogpositioninggraphicalobjects,128wrappingtext,Word,129Formatdialog,Excel,442,443–444Formatmenu,Mail,670,671FormatMovietab,PowerPoint,600–602FormatPainterfeature,Word,208,234FormatPicturedialog,Wordwrappingtext,129FormatPicturetab,Ribbonapplyingstyletopictures,133compressingpictures,136croppingpictures,134modifyinglookofpictures,132Formatpop-upmenuFindandReplacedialog,Word,242,245SaveAsdialog,Excel,348Index759savingdocuments,18FormatShapedialog,Word,128,129FormatTextdialog,PowerPointBulletstab,582changingindentationoftext,577changinglinespacing,578CharacterSpacingtab,576customizingbullets,582Fonttab,576formattingtextonslides,576rotatingtext,578,579–580FormatWallsdialog,Excel,442–443formatsExcel,173PowerPoint,174Word,173formattedAutoCorrectentries,53formattingdocumentsseeformattingunderWorddocumentsFormattingoption,ShowMarkupmenucontrollingTrackChangesdisplayed,318Formattingpop-upmenu,TrackChanges,311Formattingtoolbarcustomizingtoolbars,146Excel,383Officeapplications,9undockinganddocking,144–146Word,88,89choosingfontformattingforstyle,222Stylespop-upmenu,210,212–213formattingworksheetsseeformattingunderExcelworksheetsforms,Excelenteringdataintodatabasetables,485–487formulabar,Excel,349editingcells,356usingcalculationoperators,459,460FormulaBuilder,ExcelArgumentspane,474Descriptionarea,474insertingfunctionsusing,468,471–475formulas,ExcelseeformulasunderExcelworksheetsformulas,Wordinsertingfields,267forwardingmessages,Mail,680Fractionnumberformat,Excel,387fractionsAutoFormatoptions,49FreezePanesoption,Excel,374Fromoption,ArrangeBymenuMessageList,Mail,662FullScreenview,Excel,369FullScreenview,Word,196–197creatingcolumns,260iconrepresenting,194Readingview,197usingTrackChangesin,320Writingview,197Zoompop-upmenu,197functionsseefunctionsunderExcelworksheetsGGallerydialogcreatingdocumentsusingtemplates,14displayingwhenapplicationopens,170openingdocuments,23openingrecentlysaveditems,22GarageBandrecordingaudioforslides,604Generalnumberformat,Excel,386,387GIF(GraphicsInterchangeFormat)filessavingPowerPointpresentationaspictures,643GlowandSoftEdgescategory,Formatdialog,Excel,444GmailcreatingvCardfiles,698–699GoTobrowseobject,Word,190GotoSlideoption,PowerPoint,631GoTotab,FindandReplace,Word,245–246GotoTodaybutton,Calendar,710GoalSeek,Excel,495,505–507GoogleMailcreatingvCardfiles,698–699importingcontactsfrom,699GradienttabFormatWallsdialog,Excel,443Index760grammarchoosingoptionsforWord,68–71grammarchecking,61–63,67–68Checkgrammarasyoutypeoption,67,68Checkgrammarwithspellingoption,67,68customdictionaries,74fivedegreesofchecking,69Hidegrammaticalerrorsindocumentoption,67identifyingproblem,62limitations,61messages,Mail,674ShowgrammaticalerrorsinNotebookLayoutViewoption,67Showreadabilitystatisticsoption,68wavygreenunderline,61,67,74WordandOutlook,71Writingstylepop-upmenu,68,70GrammarSettingsdialog,68,69Commarequiredbeforelastlistitemoption,70Punctuationrequiredwithquotesoption,70Spacesrequiredbetweensentences,71Graphicbrowseobject,Word,190graphicalobjectsaddingpicturestoPowerPoint,597–599addingtoPowerPointslides,584,589animatingSmartArtgraphic,PowerPoint,615–616applyingstyletopictures,133–134applyingstyletoshapes,126–127arranging,140–141compressingpictures,136–137controllingvisibilityof,140–141croppingpictures,134–136dynamicreordering,141inserting,112clipart,112–115picturesindocuments,120–123shapesindocuments,123–125SmartArt,137–139managingclipart,115–120modifyinglookofpictures,132–136positioning,111,128rotating,127wrappingtext,Word,129–132graphicsfilesaddingitemstoScrapbook,34gridlines,charts,Excel,426choosinggridlinestodisplay,440–441Groupgraphicpop-upmenu,PowerPointanimatingSmartArtgraphic,616groupsofcontrols,Ribbon,29HhandoutscreatingforPowerPointpresentation,634–636hangingindent(outdent)directformatting,Word,208Paragraphdialog,Word,224Headerdialog,Excel,408–409Headerrow,Excelcustomizingappearanceofdatabasetable,483Header/Footertab,PageSetupdialog,Excel,407–410headersandfooters,WordseeheadersandfootersunderWordHeadingbrowseobject,Word,190headingrows,Excelfreezing,374headings,ExcelCellStylespanel,404creatingdatabasetables,481headings,Wordaddingcross-references,271applyingstylesusingkeyboardshortcut,220AutoFormatoptions,48outlinelevels,273Outlineview,275–276creating/expanding/collapsingin,274promoting/demotingin,274HEX2OCT()function,Excel,473hiddencharacters,Wordsearchingforspecialcharacters,241Hiddenoption,protectingcells,Excel,393hiddenslides,PowerPoint,618–619Hidegrammaticalerrorsindocumentoption,67Index761HideRow/Columnoptions,Excel,382Hidespellingerrorsoption,66hidingapplications,24Hierarchypanel,InsertSmartArtGraphicbox,137HighlightallitemsfoundincheckboxFindandReplacedialog,Word,95,97HighlightCellsRulespanelconditionalformatting,Excel,395HighlightChangesdialogTrackChanges,Word,313HighlightUpdatesoption,ShowMarkupmenucontrollingTrackChangesdisplayed,318highlightingfindinghighlightedtext,242HighlightingallitemsfoundinoptionFindandReplacedialog,Word,238Hometab,Ribbon,11Honeycombtransition,PowerPoint,608horizontalalignmentoftext,Excel,389horizontalaxis,charts,Excel,425horizontalline,AutoFormatoptions,51Horizontaloption,ArrangeWindowsdialog,Excel,373horizontalsplitbox,Excel,370HorizontalTitleitem,Excel,435Hoursslider,Calendar,710Hyperlinkstyle,Excel,404hyperlinks,105–109addingtoslides,PowerPoint,594–595AutoFormatoptions,49,50,51editing,109inserting,106–109objecthyperlink,105,106ScreenTips,105,108texthyperlink,105,106hyphenationdon'thyphenateoption,Word,226hyphensAutoFormatoptions,49,50IIconSetspanelconditionalformatting,Excel,394,395IF()function,Excel,473Ignoreblankcheckbox,datavalidation,Excel,399IgnoreInternetandfileaddressesoption,66IgnorewordsinUPPERCASEoption,66Ignorewordsthatcontainnumbersoption,66IMAPe-mailaccount,652addingtoOutlook,651,652–655Importassistant,Outlook,657ImportCellStylesdialog,Excel,406ImportContactsdialog,Outlook,700–702ImportdialogaddingpicturestoClipGallery,115–116importingstyles,Excel,406Inbox,MailmarkingspammessagesasJunkMail,685receivingfileasattachment,677IncludeinpersonalviewareaShareWorkbookdialog,Excel,418indentation(left)AutoFormatoptions,49indentationoftextchanging,PowerPointslides,577indentingtext,Excel,390IndentsandSpacingtab,Paragraphdialog,Word,224–225IndexandTablescategory,Word,267informationReferenceToolspalette,35–36informationcategory,functions,Excel473Informationdialog,Excel,401InputMessagetab,datavalidation,Excel,398,399–400Insertdialog,Excel,378,379InsertFiledialog,Word,182,183InsertHyperlinkdialog,106addinghyperlinks,PowerPoint,594Documenttab,107E-mailAddresstab,107,108LinkTobox,106WebPagetab,107InsertMediaClipicon,PowerPoint,112InsertPicturefromFileicon,PowerPoint,112InsertPlaceholderssectionMailMergeManagerpane,Word,294Index762Insertpop-upmenu,Excelinsertingfunctionsusing,468,475–476InsertSmartArtGraphicbox,137Hierarchypanel,137InsertTabledialog,100–102addingtablestoslides,PowerPoint,585–586insertingslide,PowerPoint,26insertingtables,99–102Word,247insertionpointmovinginsertionpointtolastfouredits,190movingwithkeyboard,87Insertionsoption,ShowMarkupmenucontrollingTrackChangesdisplayed,318Insertionspop-upmenu,TrackChanges,311instantmessagecommunicatingwithcontacts,707internetaddressesAutoFormatoptions,49,50,51invitationstomeetings,Outlookdealingwith,722–723trackingstatusofinvitationssent,721iPhotoinsertingpicturesfrom,120–121italicsAutoFormatoptions,49,51keyboardshortcuts,91JJPEG(JointPhotographicExpertsGroup)filessavingPowerPointpresentationaspictures,642JunkE-mailfolder,OutlooksettingautomaticdeleteafterNdays,686JunkE-mailProtectiondialog,Outlook,686–688BlockedSenderstab,687–688Leveltab,686SafeDomainstab,686–687JunkE-mail,OutlookchangingJunke-mailprotectionsettings,685–686creatinglistofsafedomainsfore-mail,686–687markingspammessagesasJunkMail,685removingnonspammessagesfrom,685viewingfolderregularly,685justifyingtextalignment,224directformatting,90Kkeepoptions,Paragraphdialog,Word,226KerberosauthenticationaddingExchangeaccounttoOutlook,656keyassignments,Wordprinting,335keyboardnavigatingwith,87selectingtextwith,88keyboardshortcutsCut,Copy,andPastecommands,91directformatting,90movinginsertionpoint,87keyboardshortcuts,Excel,87creatingcustomshortcuts,164–167insertingnewworksheet,357movingactivecell,352numberformats,387–388keyboardshortcuts,Outlookcreatingmessages,667Notes,735,736switchingamongmainareas,660Tasks,726keyboardshortcuts,PowerPoint,633switchingviews,556keyboardshortcuts,Wordapplyingstylesusing,220creatingcustomshortcuts,164–167insertingspecialcharacters,86movingarounddocumentusing,189switchingbetweenviews,195keywordsaddingtoclippings,35Index763Keywordstab,PropertiesdialogaddingpicturestoClipGallery,118LLabelchangeswithtextboxCompareDocumentsdialog,Word,327labels,MailMerge,Wordselectingdocumenttype,288Languagedialog,231languageformatting,Wordaddingtocustomstyle,230–231languagescountryrulesforspellchecking,66,67creatingcustomdictionary,73LastColumncheckbox,Excelcustomizingdatabasetable,484LastViewedoption,PowerPointmovingbetweenslides,631launchingapplicationsautomatically,13–14layersseedocumentlayersLayoutcategory,Formatdialogwrappingtext,Word,129Layoutmenu,DesigngroupPivotTables,Excel,526Layouttab,PivotTableOptionsdialog,Excel,532–533leaderssettingnewtabstop,Word,227leftindentAutoFormatoptions,Word,49LEFT()function,Excel,473legends,charts,Excel,438letters,MailMerge,Wordselectingdocumenttype,288Leveltab,JunkE-mailProtectiondialog,686ligatures,223LineandPageBreakstab,Paragraphdialog,Word,225–226Linecategory,Formatdialog,Excel,444linechart,Excel,426Linepanelrefiningshapeswith,126,127linespacingchanging,PowerPointslides,578Paragraphdialog,Word,225linesparkline,Excel,446lines,pagination,Worddocumentskeeplinestogetheroption,226widow/orphancontrol,225LinkTobox,InsertHyperlinkdialog,106linkingpicturestodocuments,123linksseehyperlinksLinksandReferencescategoryinsertingfields,Word,268listitemformatAutoFormatoptions,Word,50liststyle,Word,209addingbulletsornumberingtostyle,228bestwaytoformatdocuments,209Listvalue,DataValidationdialog,Excel,399lists,PowerPointbulletedlists,580–584locatingtextseefindingtextLocationbox,Outlookcreatingappointments/events,715schedulingmeetings,720Lockedoption,protectingcells,Excel,393Logarithmicscaleoption,ScalepaneFormatAxisdialog,Excel,437logicalcategory,functions,Excel473loginlaunchingapplicationsautomatically,13–14lookupandreferencecategory,functions,Excel473MMacOSXAddressBookcreatingvCardfilesfrom,697importingcontactsfrom,696–697MacOSXapplicationsusingmenus,27Mail,667–688addinge-mailaccount,651–657communicatingwithcontacts,706creatinglistofsafedomains,686–687importingexistinge-mailaccount,657keyboardshortcutforswitchingto,660menubar,659MessageList,660–664changingsortorder,663Index764groupingitems,663sorting,661–663messagesseemessages,MailNavigationPane,659Outlookinterface,658–667ReadingPane,660,661,664–667removingsendersblockedbymistake,687–688Ribbon,659settingupdigitalcertificates,672–673signatures,682–685spam,685–688toolbar,659viewingconversations,663mailfolders,Mailcreating,682movingmessageto,681–682MailMergeManagerpane,WordCompleteMergesection,298FilterRecipientssection,296InsertPlaceholderssection,294PreviewResultssection,297restoringmaindocumenttonormal,301SelectDocumentTypesection,287SelectRecipientsListsection,288,289selectingdocumenttype,288MailMerge,Word,285–302completingmailmerge,287,298–301mergingtoe-mailmessages,300–301mergingtonewdocument,300printingdocuments,299datasource,286insertingfields,268maindocument,285,287–289creatingnewdocument,287openingexistingdocument,287restoringtonormaldocument,301–302placeholdersinsertinginmaindocument,286,294–295ViewAllPlaceholdersbutton,298previewingresults,286,297–298recipientslist,filtering,286,295–297QueryOptionsdialog,296recipientslist,selecting,286,289–294creatingnewdatasource,289–293openingexistingdatasource,289,293usingcontactsfromothersources,289,293,294selectingdocumenttype,286,287–288six-stepprocess,286MailRecipientdialog,Wordcompletingmailmerge,300maindocument,MailMerge,Word,285,287–289insertingplaceholdersin,294–295restoringtonormaldocument,301–302marginsPageSetupgroup,Excel,413MarkasRead,contextmenu,Outlookmarkingmessagesasread,676Markersdialog,Excelformattingsparklines,448,449markup,TrackChanges,WordMarkuparea,310MarkupAreaHighlightoption,318ShowMarkuppop-upmenu,317viewing,316markup,Wordprinting,333–334MasterDocumentview,Word,277Matchcaseoption,FindandReplacedialog,239mathandtrigonometrycategory,Excel473MathAutoCorrectoptions,Word,51–53MAX()function,ExcelinsertingfunctionsusingAutoSum,470MediaBrowseraddingpicturetosignatures,Outlook,684insertingclipart,113–114insertingpicturesfromiPhoto,121insertingshapesindocuments,123,124insertingsymbols,83MediaBrowser,PowerPointaddingmoviestoslides,599addingpicturestoslides,584addingsoundfromAudioBrowser,603MeetingNotespane,PowerPoint,627,628Meetingwindow,OutlookSchedulingAssistanttab,720,721schedulingmeetings,719–720Index765trackingstatusofinvitationssent,721,722meetingscommunicatingwithcontacts,707meetings,Calendar,713invitationsto,722–723scheduling,719–720settingup,719–720trackingstatusofinvitationssent,721menubar,25,26,27changingappearanceofmenuitem,150–151changingorderofmenus,156creatingnewmenu,154–155customizing,146,154–156preparingtocustomize,146–148removingexistingmenu,156switchingviews,PowerPoint,556menusaddingbuilt-inmenutotoolbar,152addingitemsto,153changingappearanceof,150–151changingorderof,156creating,154–155customizing,146–148,153–154findingcommandstoaddto,148–149movingmenuitem,153removing,156removingitemsfrom,154renamingmenuitem,154switchingviews,Word,195using,27MergeScenariosdialog,Excel,503mergingcellsintables,103mergingcells,Excel,390mergingdata,WordseeMailMerge,Wordmergingstyles,Excel,406MessageList,Mail,660–664ArrangeBymenu,661–663groupingitems,663markingmessagesasread,676movingmessagetomailfolder,681readingmessages,676receivingfileasMailattachment,678sorting,661–663changingsortorder,663viewingconversations,663messagessendingdocumentsviae-mail,38–39messages,Mailaddingbackgroundcolor/picture,671addingBccbox,671addingsubjectlineandcontents,670–671addressingmessages,668–670applyingdigitalsignature,672attachments,677–679opening,678previewing,678receivingfileas,677–678removingfrommessage,678saving,678sendingfileas,677checkingspellingandgrammar,674choosingaccounttosendfrom,668choosingoptionsfor,671–672communicatingwithcontacts,707controllingfrequencyofchecksfornewmail,674creating,667–668creatingmailfolders,682deleting,680encrypting,672formatting,670,671forwarding,680DoNotForwardrestriction,671markingasread,676markingspamasJunkMail,685movingtomailfolder,681–682Permissionspop-upmenu,671prioritizing,671reading,676receiving,674–676replyingto,679–680Securitypop-upmenu,672sending,667,674signatures,682–685addingtomessage,684spam,685–688storing,681–682metadatacreatingPDFofdocument,78MicrosoftDocumentConnectionapplication,3Index766MicrosoftExcelseeExcelMicrosoftMessenger,3MicrosoftOffice2011,3MicrosoftOfficeappsseeOfficeapplicationsMicrosoftOfficeHome&Business,3MicrosoftOfficeHome&Student,3MicrosoftOfficewebsitedownloadingclipartfrom,118–119MicrosoftOutlookseeOutlookMicrosoftPowerPointseePowerPointMicrosoftWordseeWordMIN()function,ExcelinsertingfunctionsusingAutoSum,470Minimizebutton,titlebar,9MirrorDisplayscheckboxsettingupPowerPointpresentation,625mixedcellreferences,Excel,454MobileMeimportingcontactsfrom,696–697ModifyCellStyledialog,Excelcreatingcustomstyles,405ModifyStyledialog,Word,216changingexistingstyle,232–233Monthbutton,Calendar,711Morebutton,FindandReplacedialog,Word,243MoreFunctionsitem,Excel,484MotionPathsanimations,PowerPoint,610,611mouseselectingmultipleitems,88selectingtextwith,87Word,187MoveChartdialog,Excel,429MoveorCopydialog,Excel,367–368Movedfrom/topop-upmenu,TrackChanges,312Movesarea,TrackChanges,312MovieBrowser,PowerPointaddingmoviestoslides,599MovieOptionsdialog,PowerPoint,644–645movies,PowerPointaddingfromfile,599–600addingfromMovieBrowser,599changingappearanceandplayback,600–602controllingplayback,602savingpresentationsas,638,643–645MyDaywindow,Outlook,733MyDocumentsfolder,SkyDrive,41MyThemes,PowerPoint,548NNA()function,Excel,470NAMEerror,Excel,464namedcellsandranges,Excelreferringto,455–456navigatingdocuments,Word,234–246FindandReplacedialog,237–245GoTotab,245–246replacingformattingorstyles,244–245replacingtext,243–244Searchbox,Standardtoolbar,236Searchpane,Sidebar,237Sidebarpane,234–236navigatingwithkeyboard,87navigatingworkbooks,Excel,348–354NavigationPane,Outlook,659–660Calendar,659,709hiding,709changingwidth,660Contacts,659creatingcontacts,689creatingmailfolders,682displayingiconsforareas,660hiding,660Mail,659movingmessagetomailfolder,681Notes,659settingup,660Tasks,659,725,726viewingcontacts,704Navigationpane,PowerPoint,550closing/reopening,551Outlinetab,550,560–561resizing,550Slidestab,550nestingformulas,Exceloperatorprecedence,462nestingtables,Word,251–252networkpathsAutoFormatoptions,49,50,51Index767networkssharingdocumentson,308–309NewCellStyledialog,Excel,404–405NewDictionarydialog,72NewFolderdialogsavingdocuments,17NewFormattingRuledialog,Excel,396Newpanel,Ribboninsertingtablesfrom,100NewSlidepanel,PowerPointaddingslides,552built-inslidelayouts,573NewStyledialog,Word,219,221NewWindowoption,Word,273NextbuttonCalendar,710movingbetweenslides,PowerPoint,630Worddocuments,189NextFindbutton,Word,189NextPagebutton,Word,189Nextpagesectionbreak,Word,253N/Aerror,Excel,464NoFormattingbutton,FindandReplacedialog,Word,243Nonetransition,PowerPoint,606Normalstyle,Wordapplyingusingkeyboardshortcut,220neverusingforformatting,211Normaltemplate,165creatingAutoCorrectentries,54savingchangesto,167styles,Word,208,210normaltext,Fontpop-upmenuinsertingsymbolsindocuments,84Normalview,Excel,369switchingbetweenPageLayoutand,350,369Normalview,PowerPoint,549creatingslidesin,556FitSlidetoCurrentWindowbutton,549Navigationpane,550Notespane,550,551organizingslidesintosections,561rearrangingslides,555Slidepane,549,550Normalview,WordseeDraftview,WordNotebookLayoutview,Word,200–202headersandfooters,254iconrepresenting,194showinggrammaticalerrorsin,67Notes,735–737copying/pastingcontents,737creating,736editing,737forwarding,737interface,735keyboardshortcutforswitchingto,660NavigationPane,659Outlookinterface,658–667sendingase-mailmessage,737using,737NotesPageview,PowerPoint,558–559Notespane,PowerPointNormalview,550,551Presenterview,627Notestab,Contactwindow,Outlook,693NOW()function,Excel,470NULL!
error,Excel,464NUM!
error,Excel,464numberformatting,Excel,386–388pasting,364Numbergroup,Excel,384,385,386Numbernumberformat,Excel,387Numbertab,FormatCellsdialog,Excel,386formattingwithstyles,402numberedlistsAutoFormatoptions,48,50Numberingcategory,Word,268numbering,Wordaddingcross-references,271addingtocustomstyle,228applyingdirectformattingontopofstyles,234footnotesandendnotes,280,281,282insertingfields,268suppresslinenumbersoption,226Oobjecthyperlinks,105,106objectsdirectformatting,88–91OCR(opticalcharacterrecognition)applications,181Index768enteringtextindocuments,82oddnumberedpages,Worddocumentsaddingheadersandfooters,254,256,257addingsectionbreaks,253Oddpagesectionbreak,Word,253Office2011,3Officeapplicationsseealsoapplications;Excel;Outlook;PowerPoint;WordaddingtotheDock,12addingcontenttotables,103–104AutoCorrect,43–56creatingentries,53–54creatingexceptions,54–55AutoFormatoptions,46–51AutoRecover,174–175changingnumberofdocumentstracked,20,171clipart,112–120closingapplications,9,24closingdocuments,9,19commonfeaturesof,8–11CompatibilityReportpalette,36confirmopeningfileinanotherapplication,170controlinterfaces,25creatingdocuments,14–16blankdocument,16PDFofdocument,78usingtemplates,14–16croppingpictures,134customdictionaries,71CustomDictionariesdialog,71customizingRibbon,159–161Cut,Copy,andPastecommands,91–92directformattingtext/objects,88–91displayingGallerydialogwhenopening,170documentbackups,174–175drawingtables,102e-mailingPDFversions,79enteringtextindocuments,81–86Finddialogs,94–97findingtext,93–97formattingcells,26formattingtables,104–105formattingtextandobjects,91Formattingtoolbar,9grammarchecking,61–63,67–68,71graphicalobjectsarranging,140–141controllingvisibilityof,140–141dynamicreordering,141inserting,112insertingclipart,112–115managingclipart,115–120positioning,111,128rotating,127hidingapplications,24Hometab,11hyperlinks,105–109insertingsymbolsindocuments,82–86insertingtables,99–102menubar,customizing,154–156menus,27customizing,153–154mergingcellsintables,103movinginsertionpoint,87openingapplicationsApplicationsfolder,13Dock,12launchingautomatically,13–14openingdocuments,20–23,26Applemenu,20Dock,23Filemenu,22,26Finder,21Gallerydialog,23Opendialog,22Standardtoolbar,26personalsettings,169picturesinsertingindocuments,120–123linkingtodocuments,123modifyinglookof,132–136preferences,167–177Preferencesdialog,opening,167–169previewingdocuments,79printingdocuments,76–79Quitcommand,9receivingsoundfeedback,170replacingtext,97–99restoringminimizedwindow,9Ribbon,11,28–31Index769customizing,159–161savingdocuments,16–19choosingdefaultformatfor,172–174toSharePoint,41–42toSkyDrive,40–41Scrapbookpalette,34selectingtext,87–88sendingdocumentsviae-mail,38–39shapesapplyingstyleto,126–127insertingindocuments,123–125sharingdocuments,38–42smartbuttons,55–56spellchecking,57–60,63–67whiletyping,57–58wholedocument,58–60splittingcellsintables,103Standardtoolbar,9Searchbox,93–94statusbar,11tables,99–105titlebar,9toolbars,9–10,28choosingwhichtodisplay,143–144customizing,149–152Toolbox,31–38UserInformationpane,169–170usingmenus,27workingwithtext,81–109Opendialog,22OpenRecentsubmenuchangingnumberofdocumentstracked,171openingdocuments,20–23,26confirmlaunchinginanotherapplication,170operators,Excel,456–461arithmeticoperators,456comparisonoperators,457concatenationoperators,457precedenceof,461–462referenceoperators,457opticalcharacterrecognitionseeOCRoptionalarguments,functions,Excel,469Optionstab,Mailmessages,671ordinals(1st)withsuperscriptAutoFormatoptions,Word,49organizationchartinsertingSmartArt,137Organizationtab,Contactwindow,Outlook,693orientationchanging,PowerPointslides,548PageSetupgroup,Excel,413rotatingtext,Excel,390Originaldocumentpop-up,CompareDocumentsdialog,Word,327Originaloption,TrackChanges,Wordviewingmarkup,317OriginalShowingMarkupoption,317orphans,225outdentseehangingindentOutlineLayout,DesigngroupPivotTables,Excel,526,527outlinelevel,Paragraphdialog,Word,224Outlinepane,Normalview,PowerPoint,555Outlinetab,Navigationpane,PowerPointcreatingbulletedparagraphinslide,561creatingoutlineofpresentation,560–561creatingslides,561displayingslidesinSlidepane,550expanding/collapsingslides,560movingparagraph/selectionup/down,561pastingintext,561OutlineToolsgroup,Word,273,274Outlineview,Word,199,272–277creatingheadingsin,274creatinglongdocumentswith,272–277expandingandcollapsingheadingsin,275–276iconrepresenting,194keyboardshortcuts,195movingparagraphsup/downdocument,276–277openingsecondwindow,273outlinelevels,273overviewofoutlines,272promotinganddemotingheadingsin,274switchingfrom,277switchingto,273–274viewingstylesusedbydocument,220,221Index770Outliningtoolbar,PowerPointundockinganddocking,145Outlook,7,658–667addinge-mailaccountto,651–657Exchangeaccount,656–657IMAPaccount,652–655POPaccount,652–655AdvancedFindfeature,96AutoCorrect,43,45AutoFormatoptions,47,50–51Calendar,709–723seealsoCalendarchoosinggrammarandstyleoptionsfor,68–71commonfeaturesofOfficeapps,8–11ConflictResolverdialog,697Contacts,689–707seealsoContactscontrollingfrequencyofchecksfornewmail,674creatingAutoCorrectexceptions,54creatingitems,14creatinglistofsafedomainsfore-mail,686–687creatingmailfolders,682customizingmenus,146customizingtoolbar,162–164DatesandReminderdialog,734DefaultSignaturesdialog,684digitalcertificates,694EditScheduledialog,675EnterMappingNamedialog,702Exchangeaccountinformationdialog,656Finddialog,96grammarchecking,61–63,71ImportContactsdialog,700–702importingexistinge-mailaccount,657interface,658–667JunkE-mailfolder,685JunkE-mailProtectiondialog,686–688keyboardshortcuts,660launching,650–651Mail,667–688seealsoMailmainapplicationsof,649MessageList,660–664groupingitems,663sorting,661–663messagesseemessages,MailNavigationPane,659–660Notes,735–737seealsoNotesopeningPreferenceswindow,167printingdocuments,76ReadingPane,660,664–667Recurrencedialogcreatingrepeatingappointments,717–718creatingrepeatingtasks,728–729Searchbox,toolbar,93sendingdocumentsviae-mail,38settingup,650–657settingupdigitalcertificates,672–673signatures,682–685sortingMessageList,663spam,685–688spellchecking,57–60,63switchingamongmainareas,660Tasks,725–734seealsoTaskstoolbars,10viewingconversations,663WelcometoOutlookforMacdialog,650OutlookPreferencesdialogAccountspane,651,652,654controllingfrequencyofchecksfornewmail,674customizingCalendarsettings,711Readingpane,665–667Schedulespane,674,675settingupdigitalcertificates,672–673PPageBordertab,Word,230pagebreakbeforeoption,Word,226pagebreaks,Excel,413Pagebrowseobject,Word,190PageLayoutview,Excel,369addingheadersandfooters,410checkingpagelayout,412,413switchingbetweenNormaland,350,369PageNumberFormatdialog,Word,259Index771PageNumbersdialog,Word,258pagenumbers,Word,258–260addingcross-references,271addingtoheadersorfooters,258formatting,259insertingtextwithAutoText,183removing,260PageRangeoption,Printdialog,Word,332,333PageSetupdialog,ExcelHeader/Footertab,407–410PageSetupdialog,PowerPoint,548–549PageSetupgroup,Excel,413pagination,Worddocuments,225,226palettes,ToolboxCompatibilityReportpalette,36–38displaying,33ReferenceToolspalette,35–36Scrapbookpalette,34–35Settingspalette,33papersizePageSetupgroup,Excel,413Paragraphdialog,Word,223–228IndentsandSpacingtab,224–225LineandPageBreakstab,225–226Tabsbutton,226paragraphformatting,Wordapplyingdirectformattingontopofstyles,233creatingcustomstyles,223–228Paragraphgroup,Ribbon,89,90directformatting,Word,208formattingtextonslides,PowerPoint,575,576paragraphstyle,Word,209paragraphs,WordseeparagraphsunderWordparenthesesoperatorprecedence,Excel,462PassiveSentencesstatistic,68Passworddialog,Word,337,338passwordsaddingIMAP/POPaccounttoOutlook,655protectingdocument,Word,337–339protectingworkbook,Excel,416Securitypane,Word,339Pastecommand,91–92enteringtextindocuments,81PasteLinkbutton,Excel,364PasteOptionsmenu,Excel,361,362Pastepop-upmenu,Excel,361,362PasteSpecialdialog,Excel,362–364copyingchartformatting,445copyingstylesbetweenworkbooks,406Skipblankscheckbox,364Transposecheckbox,364pastinginsertingitemsfromScrapbook,35usingsmartbuttons,92pastingdataintoworksheets,Excel,361–364datavalidation,397PasteSpecialdialog,362–364pastingtextintodocuments,Word,361–364addingcontenttotables,104Patterntab,FormatWallsdialog,Excel,443PDF(PortableDocumentFormat)filesaddingheadersandfootersinWord,254creatingfromWord,342creatingPDFofdocument,78e-mailingPDFversionofdocument,79Percentagenumberformat,Excel,387Permissionspop-upmenu,Mail,671personalsettings,UserInformationpane,169photosinsertingpicturesfromiPhoto,120–121fromMacfilesystem,121–122PhotosBrowserpane,MediaBrowseraddingpicturestoPowerPointslides,597insertingpicturesfromiPhoto,121PictureorTexturetab,FormatWallsdialog,Excel,443Pictureplaceholder,Outlookcreatingcontacts,690PictureQualitypop-upmenucompressingpictures,136PictureStylesgroup,QuickStylesbox,133PicturewithCaptionslidelayout,PowerPoint,573picturesseealsographicalobjectsaddingtoClipGallery,115–118Index772addingtoPowerPointslides,584,597–599applyingstyles,133–134compressing,136–137cropping,134–136andresizing,PowerPoint,598insertingfromiPhoto,120–121insertingfromMacfilesystem,121–122insertingindocuments,120–123linkingtodocuments,123modifyinglookof,132–136resetting,133savingpresentationas,638,642–643wrappingtext,Word,130piechart,Excel,426PivotTableBuilder,ExcelchangingPivotTable,521–525creatingPivotTableautomatically,512creatingPivotTablemanually,515–521PivotTableFielddialog,Excel,525–526PivotTableframework,Exceladdingfieldsto,517–521changingPivotTable,521–525creatingPivotTablemanually,514,516–521PivotTableOptionsdialog,Excel,529–535Datatab,533–535Displaytab,529,530–531Layouttab,532–533renamingPivotTables,530PivotTablereport,Excelcreatingreportsfromscenarios,503PivotTables,Excel,509–539ChangePivotTableDataSourcedialog,536changing,521–525changingdatasource,535–536changingfunctionusedtosummarizefield,525–526controllingdesignof,526–528creating,511–521automatically,511–513fromexternaldatasource,514manually,513–521downloadingsampleworkbook,511filtering,537–539formatting,528–529naming,529,530options,530–535captionsandfilters,530cellformatting,532centeringlabelsinmergedcells,532columnwidths,532connections,535data,533–535deleteditems,534disclosuretriangles,530display,530–531drillingdown,534emptycells,530errors,530filters,532indentingrowlabels,533layout,532–533OLAPdatasource,531printing,531refreshingdata,535reportfilter,533runningqueriesinbackground,535ScreenTips,530sorting,533sourcedata,534storingitemsfordatafields,534styles,528refreshingdatain,535renaming,530sorting,533,536–537styles,528–529applying,528optionsfor,528placeholders,MailMergeseeplaceholdersunderMailMerge,Wordplaceholders,PowerPointseeplaceholdersunderPowerPointpresentationsplanningGoalSeek,Excel,505PlaybackOptionspop-upmenu,PowerPoint,602plotarea,Excelcharts,424PNG(PortableNetworkGraphics)filessavingPowerPointpresentationaspictures,642PointerOptionsmenu,PowerPointannotatingslides,632Index773pointssizeofpoint,225POISSON.
DIST()function,Excel,474POPe-mailaccount,652addingtoOutlook,651,652–655portsaddingIMAP/POPaccounttoOutlook,653,654positioninggraphicalobjects,128PowerPoint,6seealsoPowerPointpresentations;OfficeapplicationsAdvancedFinddialog,95,96animationsaddingtoobject,610–612addingtoslides,609–618animatingcharts,617animatingSmartArtgraphic,615–616animatingtables,618Appearanimation,610changingeffectoptions,613changingorderof,612–613controllingtimingof,611,613Disappearanimation,610displayingbulletedparagraphsoneatatime,613–615EmphasisEffectsanimations,610EntranceEffectsanimations,610,611ExitEffectsanimations,610,611expand/collapsecontainer'slistof,613goingoverthetopwith,610MotionPathsanimations,610,611playing,613previewing,612Pulseanimation,610revealinghiddenpartoftable,618runningautomatically,618Shrink&Turnanimation,610Spinanimation,610Swivelanimation,610AutoCorrect,43,44,45creatingexceptions,54AutoFormatoptions,47,50BroadcastSlideShowdialog,639–641bulletedlists,580–584bulletedparagraphs,561,613–615chartsaddingExcelcharts,584,589–594animatingcharts,617ChooseaFiledialog,553ChooseaMoviedialog,600ChooseaPicturedialog,597,602ChooseaSounddialog,609ChooseAudiodialog,603choosingoptionsfortransitions,608ClipArtBrowsericon,112CompareChangespane,566,567,568,569Comparefeature,PowerPointcollaboratingonpresentations,564comparingtwocopiesofpresentation,568–569contextmenus,146,156movingbetweenslides,630,631ComparePresentationsdialog,568contextmenus,146,156CustomShowsdialog,620–622DefineCustomShowdialog,620–621directformatting,88–91EffectOptionspanel,608,611FormatMovietab,600–602FormatTextdialogBulletstab,582changingindentationoftext,577changinglinespacing,578customizingbullets,582formattingtextonslides,576rotatingtext,578rotatingtext,579–580formattingtables,104–105graphicalobjects,inserting,112Hometab,11InsertHyperlinkdialog,594InsertMediaClipicon,112InsertPicturefromFileicon,112InsertTabledialog,100–102,585–586linespacing,changing,578MovieOptionsdialog,644–645moviesaddingfromfile,599–600addingfromMovieBrowser,599addingpictureasmovieposterframe,602Index774changingappearanceandplayback,600–602controllingplayback,602savingpresentationsas,638,643–645navigatingPowerPointwindow,549–551Navigationpane,550notespages,creating,558–559Notespane,550Outlinetab,560–561PageSetupdialog,548,549picturescroppingandresizing,598repositioning,598resizingtofitinplaceholder,598,599savingpresentationas,638,642–643preferences,167–177presentationformats,174PresentationGallerydialog,544–546previewingdocuments,79Printdialog,77printingdocuments,76–79RecordSounddialog,604–605RenameSectiondialog,562Replacedialog,98savingdocuments,18choosingdefaultformatfor,172,174Searchbox,Standardtoolbar,93SelectPlaceinDocumentdialog,594,595SetHyperlinkScreenTipdialog,595SlideFinderdialog,554Slidepane,549,550smartbuttons,55SmartArtgraphics,adding,589spellchecking,57–60,63–67spellcheckingwholedocument,58symbols,inserting,82,83tables,99–105addingcontentto,103–104addingtoslides,584,585–589animating,618creatingtable,585–587creatingfromExceldata,588–589drawing,102importingfromWord,587–588inserting,99–102mergingcells,103resizingtable,586revealinghiddenpartoftable,618splittingcells,103tabs,11templates,using,545,546textseealsotextaddingplaceholderfor,551AutoFitbodytexttoplaceholder,50bulletedlists,580–584changingalignment,576changingfont,576changingfontsize,575changingindentation,577changinglinespacing,578formattingtextonslides,575–584keepingtextclearforaudience,577planningslidesforpresentation,571replacing,98rotatingtext,578–580themes,changing,547–548Toolbox,32views,556–560Normalview,549,556NotesPageview,558–559openingextrawindows,560Presenterview,556,626–628SlideShowview,559SlideSorterview,556–558switchingviews,556windows,opening,560PowerPointBroadcastService,639,640PowerPointpresentationsseealsoOfficeapplicationsaddingExcelchartstoslides,589–594copyingexistingExcelchart,592–594creatingchartforPowerPoint,590–592coauthoringpresentations,563–569comparingtwocopiesofpresentation,568–569contentplaceholders,584,589,597creating,544–546blankpresentation,544usingexistingpresentation,546Index775usingMyThemes,545usingOnlineTemplates,546usingtemplates,545usingthemes,545deliveringpresentationscreatinghandout,634–636recordingnarration,636–637savingasmovie,638,643–645savingaspictures,638,642–643deliveringpresentationsinperson,623–636annotatingslides,632changingresolution,625displayingwhiteorblackscreen,634keyboardshortcutscontrolling,633movingbetweenslides,630–631practicingpresentation,628presentationtoliveaudience,630–634Presenterview,626–628rehearsingtimingsforslides,629–630settingup,624–625startingpresentation,630deliveringpresentationsviaInternet,637–642broadcastingslideshow,638,639–642e-mail,637SharePoint,638SkyDrive,638editingsimultaneouslywithcolleagues,564–568formats,174formattingtextonslides,575–584changingalignment,576changingfont,576changingfontsize,575handout,creating,634–636navigatingPowerPointwindow,549–551openingextrawindows,560placeholdersaddingcontenttoslides,551addinggraphicstoslides,584addingpicturestoslides,597addingSmartArttoslides,589formattingtextin,575moving,552resettingtodefault,551resizing,551resizingpicturestofitin,598,599planningslides,571–573avoidingclutteredslides,572concisetext,571finalslide,573illustratingpoints,572visualinterest,572Welcomeslide,572Presenterview,626,627running,559saving,16–19asmovie,638,643–645aspictures,638,642–643choosingdefaultformat,174settingAutoRecoverforbackups,174–175settingdefaultfoldersfor,177sectionsexpanding/collapsing,562movingsectionsup/down,562organizingslidesinto,561–563removingsectionandslides,563removingsectionbutleavingslides,563sharingdocuments,38–42slidelayouts,573–574slideshowsBroadcastSlideShowdialog,639–641broadcastingpresentations,638,639–642creating,619–622deleting,622editing,622ending,628openingCustomShowsdialog,620playing,622slidesadding,552–555addinganimationto,609–618addingcontentto,551–552addingExcelchartsto,589–594addinghyperlinksto,594–595addingpicturesto,597–599addingSmartArtgraphicsto,589Index776addingsoundto,603addingtablesto,584,585–589addingtransitionsto,606–609advancingtonextslide,609annotating,632applyingtransitiontoall,609changingsize/orientationof,548–549copying,553,554copyingfromanotherpresentation,553–554creatinginNormalview,556creating,Outlinetab,561deleting,555duplicating,553expanding/collapsing,560formattingtexton,575–584hiddenslides,618–619indicatinghiddenslide,631inserting,26insertingfromoutline,555movingbetween,630–631organizingintosections,561–563planning,571–573rearranging,555,556–558rehearsingtimingsfor,629–630removingsection,563rotatingtexton,578–580transitionsbetween,606–609soundaddingtoslides,603addingtotransitions,608,609playingaudiofilesfromAppleiTunes,603positioningsoundandsettingvolume,605recordingaudioforslides,604–605recordingnarration,636–637transitions,606–609PowerPointPreferencesdialogAdvancedpreferencespane,177Savepreferencespane,174precedence,Exceloperators,461–462preferencescustomizingCalendarsettings,711Officeapplications,167–177Ribbonpreferencespane,159UserInformationpane,169–170Preferencesdialog,167Excel,168–169formattingcells,383movingactivecellwhenpressReturnkey,354PowerPoint,169Word,168–169wrappingtext,200preferencespane,AutoCorrect,43Preferenceswindow,Outlook,167,169PresentationGallerydialog,PowerPointcreatingpresentations,544–546blankpresentation,544MyThemes,545OnlineTemplates,546templates,545themes,545presentationsoftwareseePowerPointpresentationsseePowerPointpresentationsPresenterview,PowerPoint,556,626–628endingslideshow,628MeetingNotespane,627,628movingbetweenslides,627,628,631Notespane,627slidesvisiblein,626,627turningon,626presetconditionalformatting,Excel,394–397presetsprintingdocuments,78Presetspop-upmenu,Printdialog,Word,333,334PreviewResultssection,MailMergeManager,297previewingdocuments,79previewingresultsMailMerge,Word,286,297–298Previousbutton/optionsCalendar,710PowerPoint,630Word,189Printdialog,76choosingpresets,78choosingprinter,77Excel,411,414PowerPoint,77creatinghandout,635Index777previewingdocument,79settingdefaultprinter,78Word,77completingmailmerge,299Presetspop-upmenu,333,334PrintWhatpop-upmenu,333,334printingcustomrangeofpages,331,332printingmarkupanddocumentproperties,333PrintLayoutview,Word,195–196addingfootnotes,278addingheadersandfooters,254,255,256creatingcolumns,260iconrepresenting,194keyboardshortcuts,195viewingstylesusedbydocument,220PrintWhatpop-upmenu,Printdialog,Word,333,334printingdocuments,76–79changingnumberofcopies,78choosingpresets,78choosingprinter,77creatingPDFofdocument,78defaultprinter,78ExcelseealsounderExcelworksheetspreviewingdocument,79WordseealsounderWorddocumentsPriorityoption,ArrangeBymenuMessageList,Mail,662Priorityoptions,Taskscreatingonceonlytasks,728Privacyoptions,Securitypane,Word,336Privatebutton,Outlookcreatingappointments/events,716programsseeOfficeapplicationsprojectorssettingupPowerPointpresentation,624Proofingpanespellcheckingwholedocument,60PropertiesdialogaddingpicturestoClipGallery,116–118ProtectDocumentdialog,WordCommentsoption,321ensuringuseofTrackChanges,313,314protectingcells,Excel,393protectingworkbooks,Excel,415–416protectingworksheets,Excel,416–417applyingprotectiontoscenarios,501Protectionarea,ScenarioManagerdialog,Excel,499Protectiontab,FormatCellsdialog,Excel,393formattingwithstyles,402Publicfolder,SkyDrivesavingdocumentstoSkyDrive,41PublishingLayoutview,Word,202–204headersandfooters,254iconrepresenting,194Pulseanimation,PowerPoint,610PunctuationrequiredwithquotesoptionGrammarSettingsdialog,70QQueryOptionsdialog,Wordfilteringrecipients,MailMerge,296QuickLayoutpanel,Excelchoosinglayoutforchart,432QuickStyleGallery,Wordaddingexistingstyle,219changingstylesin,218–220creatingnewstyle,219customizing,218openingModifyStyledialog,232removingstyles,218updatingstylewithnewformatting,233QuickStylesapplyingPivotTablestyles,528applyingstylestoWorddocument,210–211changingsettings,Word,217–218formattingtables,104insertingSmartArt,139PictureStylesgroup,133QuickTime(MOV)formatsavingPowerPointpresentationasmovie,643Quitcommandclosingapplications,24Officeapplications,9quotationmarksAutoFormatoptions,48,50Index778Rradarchart,Excel,427rangesseerangesunderExcelcellsreadabilitystatistics,68Readingpane,Outlook,660,664–667controlling,664,665hiding,664Markitemsasreadoptions,666markingmessagesasread,676Notes,735positioning,664,665preferences,665–667readingmessages,676receivingfileasMailattachment,677,678Tasks,726viewingcontacts,704ReadingviewFullScreenview,Word,197usingTrackChangesin,320Read-Onlyoption,Wordmarkingdocumentas,339–340sharingdocumentsonnetworks,309recalculation,automatic,Excel,461recentdocumentschangingnumbertracked,171recentlysaveditemsincreasinglistofrecentdocuments,20openingfromApplemenu,20openingfromFilemenu,22openingrecentlysaveddocuments,20recipientslist,MailMerge,WordcreatingnewdatasourceinWord,289–293filtering,286,295–297openingexistingdatasource,293selecting,286,289–294usingcontactsfromFileMakerProdatabase,294fromMacOSXAddressBook,293fromOfficeAddressBook,293RecordSounddialog,PowerPointrecordingaudioforslides,604–605records,databasetables,Excelcheckingforduplicaterecords,490creatingdatabasetables,480,481–482removingduplicaterecords,491–492searchingforrecords,492records,Wordcompletingmailmerge,298editinginDataFormdialog,292previewingresultsofMailMerge,297recoveringworkfromdisaster,Word,194Recurrencebutton,Outlookcreatingappointments/events,716creatingrepeatingappointments,717Recurrencedialog,Outlookcreatingrepeatingappointments,717–718creatingrepeatingtasks,728–729Recurrenceline,Outlookcreatingrepeatingappointments,718Recurrencepop-upmenu,Outlookcreatingrepeatingtasks,728stoppingrepeatingappointments,719stoppingrepeatingtasks,730ReduceFileSizedialogcompressingpictures,136REF!
error,Excel,464referencearea,Excel,349referenceoperators,Excel,457ReferenceToolspalette,Toolbox,34,35–36Referencetypepop-upmenu,Wordaddingcross-references,271referringtocellsseereferencestounderExcelcellsRehearseTimingsfeature,PowerPoint,629Rejectoptions,WordintegratingTrackChanges,319,320relationaldatabase,Excel,480relativecellreferences,Excel,454remindercheckboxcustomizingCalendarsettings,712Remindercontrol,Taskscreatingonceonlytasks,727Reminderpop-upmenu,Outlookcreatingappointments/events,716RemoteDesktopConnectionapplicationOffice2011,3RemoveArrowscommand,Excel,467RemoveDuplicatesfeature,Excel,490RenameSectiondialog,PowerPoint,562reordering,dynamicarranginggraphicalobjects,141Index779Repeatspop-upmenu,Outlookcreatingrepeatingappointments,718Replacedialog,Excel/PowerPoint,98Replacetab,FindandReplacedialog,Word,243Replacetextasyoutype,AutoCorrect,46,53–54Replace/ReplaceAllbuttons,Word,244replacingformattingorstylesFindandReplacedialog,Word,244–245replacingtext,97–99FindandReplacedialog,Word,243–244Searchpane,Sidebar,Word,237replyingtomessages,Mail,679–680ReportFilterbox,PivotTableBuilder,516addingfields,517,521changingPivotTable,524reports,Excelcreatingfromscenarios,503–505requiredarguments,functions,Excel,469resettingtoolbartodefaultbuttons,159resolution,projectorsettingupPowerPointpresentation,625ResolveConflictsbutton,Word,307ResolveConflictsdialog,Excel,419–420restoringminimizedwindow,9Returnkeymovingactivecellwhenpressed,Excel,354Reviewersoption,ShowMarkupmenucontrollingTrackChanges,318ReviewingpaneWordaddingcommentstodocuments,322,323deletingcomments,325integratingTrackChanges,318navigatingdocuments,236reviewingcomments,323,324Reviseddocumentpop-up,CompareDocumentsdialog,Word,327revisionmarkingseeTrackChanges,WordRibbon,11,26controls,29customizing,159–161drawingtables,102Fontgroup,89formattingtables,105givingcommandsfrom,30groupsofcontrols,29insertingtablesfrom,100Mail,659minimizing,30minimizing,11Officeapplications,11Paragraphgroup,89,90restoringdisplayof,31ShapeStylesgroup,126tabs,28using,28–29Wordheadersandfooters,255QuickStylesbox,210–211Ribbonpreferencespane,159–161choosingtabs/groupstodisplay,161closing,161expandingRibbonwhendocumentopens,161opening,159showing/hidinggrouptitles,161turningRibbonoff,160richtextformat,Word,173,341RotatedTitleitem,Excel,435rotatinggraphicalobjects,127rotatingtext,Excel,390rotatingtext,PowerPoint,578–580rowheadings,Excel,349choosingoptionsforPivotTables,528RowHeightdialog,Excel,380,381rowidentification,worksheets,Excel,351RowLabelsbox,PivotTableBuilder,516addingfields,517,519changingPivotTable,521,522,523,524rows,ExcelseerowsunderExcelworksheetsrtfformat,Word,341SSafeDomainstabJunkE-mailProtectiondialog,686–687SaveAscommandchoosingdefaultformatforsavingdocuments,172SaveAsdialogsavingdocuments,16,17,18Index780settingdefaultfolders,175toSharePoint,42toSkyDrive,41showingfileextension,18SaveAsdialog,Excel,347savingasearlierversions,348settingdefaultfolders,175SaveAsdialog,Wordcompatibilitywithearlierversions,340,341SaveChartTemplatedialog,Excel,445SaveDataSourcedialog,Word,291SavepreferencespanePowerPoint,174Word,172creatingbackupdocuments,193savingdocuments,Word,16–19choosingdefaultformatfor,172–173settingAutoRecoverforbackups,174–175settingdefaultfolder,175–176savingpresentations,PowerPoint,16–19choosingdefaultformatfor,174settingAutoRecoverforbackups,174–175settingdefaultfolders,177savingworkbooks,Excel,16–19,347–348choosingdefaultformatfor,173–174settingAutoRecoverforbackups,174–175Scalepane,FormatAxisdialog,Excel,435–437scanning,Wordenteringtextindocuments,181scatterchart,Excel,426ScenarioManagerdialog,Excelcreatingreportsfromscenarios,503creatingscenarios,498–500mergingscenarios,502–503opening,497Protectionarea,499switchingamongscenarios,502ScenarioValuesdialog,Excel,499–500typingformulasinto,500scenarios,ExcelseescenariosunderExcelSchedulespane,Outlook,674,675SchedulingAssistanttab,Meetingwindow,Outlookschedulingmeetings,720trackingstatusofinvitationssent,721Scientificnumberformat,Excel,387Scrapbookpalette,Toolbox,34–35addingitemsto,34deletingitemsfrom,35insertingitemsfrom,35ScreenTipsdisplaying,TrackChanges,Word,316hyperlinks,105,108insertingprebuiltblocksoftextwithAutoText,184reviewingcomments,Word,324seeingerrordetails,Excel,464SetHyperlinkScreenTipdialog,PowerPoint,595usingtoolbars,28viewingendnotes/footnotes,Word,283,284scrollbuttons,Excel,350Searchbox,Standardtoolbar,93–94,236Searchpane,Sidebar,Word,236,237searchUp/Downoptions,Word,239searchingfortextseefindingtextsearching,Contacts,706SectionHeaderslidelayout,PowerPoint,573Sectionreadout,statusbar,Word,253sections,PowerPointseesectionsunderPowerPointpresentationssections,WordseesectionsunderWorddocumentssecuringdocumentsseesecuringunderWorddocumentssecuritychangingJunkE-mailprotectionsettings,685–686protectingworkbooks,Excel,415–417settingupdigitalcertificates,672–673Securitypane,WordPreferences,335,336,339Privacyoptionsarea,336Securitypop-upmenu,messages,Mail,672SelectAllbutton,Excel,350SelectBrowseObjectbutton,Word,189,191,245browsingcomments,324navigatingfootnotes/endnotes,283Index781SelectBrowseObjectpanel,Word,190–191SelectDataSourcedialog,Exceladdingseparatedataseriestocharts,432–433switchingdatasourceforcharts,430–431SelectDocumentTypesection,MailMergeManager,287SelectPlaceinDocumentdialog,PowerPointaddinghyperlinkstoslides,594,595SelectRecipientsListsection,MailMergeManager,288,289selectingtext/objects,87–88selectingtext,Word,187–188selectingmultipleitemsatonce,88,188Sendcommandsarranginggraphicalobjects,140sensitiveinformation,Wordremoving,335–337separatorcharacters,Wordconvertingtabletotext,251convertingtexttotable,249sequentialnumberscolumn,Excelsortingdatabasetables,488serversaddingIMAP/POPaccounttoOutlook,653Serverspop-upmenuadjustingnumberofitemsin,20SetHyperlinkScreenTipdialog,PowerPoint,595SetPrintAreacommand,Excel,412SettingforTwoDisplaysgroupturningonPresenterview,PowerPoint,626Settingsdialog,OutlookaddingIMAP/POPaccount,655Settingspalette,Toolbox,33ReferenceToolspalette,34Settingstab,DataValidationdialog,Excel,397–399shadingformattingtables,105Worddocuments,229–230Shadowcategory,Formatdialog,Excel,444ShapeStylesgroup,Ribbon,126shapesseealsographicalobjectsapplyingstyleto,126–127insertingintodocuments,123–125refiningwithFill/Line/Effectspanels,126,127ShapesBrowserpane,MediaBrowser,123,124ShareWorkbookdialog,Excel,417–418SharePointcollaboratingonpresentations,563,564,566deliveringpresentations,638editingdocumentssimultaneously,303,305MicrosoftDocumentConnectionapplication,3savingdocumentsto,41–42sendingdocumentsviae-mail,39workingondocumentswithcolleagues,304sharingdocuments,Officeapps,38–42savingdocumentstoSharePoint,41–42savingdocumentstoSkyDrive,40–41sendingdocumentsviae-mail,38–39sharingdocuments,Wordcompatibilitywithearlierversions,340–341creatingPDFdocuments,342sharingworkbooks,Excel,415–420editingsharedworkbooks,417–418protectingworkbook,415–416protectingworksheets,416–417resolvingconflictsinsharedworkbook,419–420restrictionswhenworkinginsharedworkbook,419sharpnessmodifyingpictures,132Shiftcellsleft/upoptionsDeletedialog,Excel,379,380Shiftcellsright/downoptionsInsertdialog,Excel,379shortcutsseekeyboardshortcutsShowchangesarea,CompareDocumentsdialog,Word,328ShowFormulasmenuitem,Excel,465ShowMarkuppop-upmenucontrollingTrackChanges,317Index782Showreadabilitystatisticsoption,68Shrink&Turnanimation,PowerPoint,610shrinkingtexttofitcells,Excel,390Sidebarpane,Wordnavigatingdocuments,234–236DocumentMappane,235Reviewingpane,236Searchpane,236,237Thumbnailpane,235opening,236signatures,Outlook,682–685addingpictureto,684addingtoMailmessages,684controllingdefaultsignature,684creatingmultiplesignatures,684editing,683settingup,683Sizeoption,ArrangeBymenuMessageList,Mail,662Skipblankscheckbox,PasteSpecialdialog,Excel,364SkyDrivecollaboratingonpresentations,563,564,566deliveringpresentations,638editingdocumentssimultaneously,303,305MicrosoftDocumentConnectionapplication,3savingdocumentsto,40–41sendingdocumentsviae-mail,39SlideFinderdialog,PowerPointcopyingslidesfromanotherpresentation,554slidelayouts,PowerPointBackgroundOnlylayout,574Blanklayout,574built-inslidelayouts,573–574changingslidelayout,574Comparisonlayout,573ContentwithCaptionlayout,573customslidelayouts,574PicturewithCaptionlayout,573SectionHeaderlayout,573TitleandContentlayout,573TitleandVerticalTextlayout,573TitleOnlylayout,574TitleSlidelayout,573Title,ContentandTextlayout,574TwoContentlayout,573VerticalTextandTitlelayout,574Slidepane,Normalview,PowerPoint,549,550deletingslides,555rearrangingslides,555resizing,550,551SlideShowtab,PowerPointturningonPresenterview,626SlideShowview,PowerPointrunningpresentationin,559slideshowsseeslideshowsunderPowerPointpresentationsSlidesizepop-upmenucreatingdocumentsusingtemplates,16SlideSorterview,PowerPointdeletingslides,555duplicatingslides,553rearrangingslides,555rearrangingslidesin,556–558slidesseeslidesunderPowerPointpresentationsSlidestab,Navigationpane,PowerPoint,550smartbuttonShowAutoCorrectsmartbutton,45smartbuttons,55–56pastingtext,92SmartArtgraphicsaddingtoPowerPointslides,589animating,PowerPoint,615–616inserting,137–139SmartArttab,RibboninsertingSmartArt,137,138Solidtab,FormatWallsdialog,Excel,443Solver,Excel,507Sortdialog,Excelsortingdatabasetablesbymultiplefields,489–490Sortoption,AutoFilter,Excel,493SortOptionsdialog,Excel,490sortingdata,Excel,490PivotTables,533,536–537sortingdatabasetables,488–490soundreceivingsoundfeedback,170Index783sound,PowerPointseesoundunderPowerPointpresentationsSoundslikeoption(words)FindandReplacedialog,Word,240Sourcetheme,Excelpasting,363SPA(securepasswordauthentication)addingIMAP/POPaccounttoOutlook,655SpacesrequiredbetweensentencesGrammarSettingsdialog,71spacing(beforeandafterparagraphs)Paragraphdialog,Word,224spam,Outlook,685–688JunkE-mailfolder,685markingmessagesasJunkMail,685removingnonspammessagesfromJunkE-mailfolder,685removingsendersblockedbymistake,687–688sparklinesseesparklinesunderExcelchartsspeakericon,PowerPointpositioningsoundandsettingvolume,605specialcharacters,WordFindandReplacedialog,238,241inserting,86Specialnumberformat,Excel,388Specialpop-upmenu,FindandReplacedialog,Word,241speech-recognitionsoftwareenteringtextindocuments,82spellchecking,57–61,63–67Alwayssuggestcorrectionsoption,66Automaticallyusesuggestionsfromspellingchecker,46Checkgrammarwithspellingoption,67Checkspellingasyoutypeoption,65checkingspellingofqueriedword,57checkingwhiletyping,57–58checkingwholedocument,58–60customdictionaries,71,73,75Customdictionaryoption,67Flagrepeatedwordsoption,66Hidespellingerrors,66IgnoreInternetandfileaddressesoption,66IgnorewordsinUPPERCASEoption,66Ignorewordsthatcontainnumbersoption,66languagerules,66,67messages,Mail,674Suggestfrommaindictionaryoption,66wavyredunderline,57,65Spinanimation,PowerPoint,610splitboxes,Excel,350SplitCellsdialog,103splittingcellsintables,103splittingwindows,Excelviewingseparatepartsofworksheet,370–371splittingwindows,Wordviewingdocumentintotwopanes,205–206spreadsheetsseeExcelSQRT()function,Excel,473SSL(SecureSocketsLayer)connectionsaddingIMAP/POPaccounttoOutlook,653,654Standardtoolbarcustomizingtoolbars,146Cut,Copy,andPastecommands,91iconswithtextoriconsonly,144Officeapplications,9Searchbox,93–94,236startofwordssearchingonlyat,241startuplaunchingapplicationsautomatically,13–14statisticalcategory,functions,Excel473statisticsreadabilitystatistics,68statusbarOfficeapplications,11switchingviews,PowerPoint,556switchingviews,Word,194Statusoption,ArrangeBymenuMessageList,Mail,662Statuspop-upmenu,Outlookcreatingappointments/events,716stockchart,Excel,426Stopdialog,datavalidation,Excel,401Structurecheckboxprotectingworkbook,Excel,415Index784Styledialog,Wordapplyingstylestodocument,210,216–217openingModifyStyledialog,233styleoptionschoosingforWord,68–71stylesapplyingpicturestyle,133–134applyingstyletoshapes,126–127AutoFormatoptions,Word,49formattingtables,104–105formattingtext,Word/Excel,88wrappingtext,Word,129Stylesgroup,Word,210Stylespanel,Excel,403–404Stylespanel,Word,210applyingstylestodocument,210,213–216openingModifyStyledialog,232updatingstylewithnewformatting,233Stylespop-upmenu,Wordapplyingstylestodocument,210,212–213viewingstylesusedbydocument,220styles,ExcelseestylesunderExcelstyles,WordseestylesunderWordSubjectbox,Mailaddingsubjectlinetomessages,670Subjectbox,Outlookcreatingappointments/events,715schedulingmeetings,720subjectlineaddingtomessages,Mail,670,671Subjectoption,ArrangeBymenuMessageList,Mail,663subscriptkeyboardshortcuts,91Subtletransitions,PowerPoint,606Subtotalsmenu,DesigngroupPivotTables,Excel,526Suggestfrommaindictionaryoptionspellchecking,66Suggestionsboxcheckinggrammar,63spellcheckingwholedocument,60SUM()function,Excel,469functionsinPivotTables,525insertingfunctionsusingAutoSum,470SummarizeBylistbox,PivotTableFielddialog,525summaryreport,Excelcreatingreportsfromscenarios,503superscriptcreating,Word,223keyboardshortcuts,91surfacechart,Excel,426SwitchPlot,Ribbon,Excelswitchingrows/columnsinchart,430Swivelanimation,PowerPoint,610SymbolBrowserpanefontsubstitution,83insertingsymbolsusing,82,83–84Symboldialog,Wordinsertingspecialcharactersusing,86insertingsymbolsusing,84–86symbolavailabilityinfont,83symbolsinsertingindocuments,82–86usingMathsymbolsinWord,51SyncServicesimportingcontactsusing,695,696–697TtabsettingleftindentAutoFormatoptions,Word,49TableAutoExpansion,Excelresizingdatabasetables,487,488Tablecellhighlightingarea,TrackChanges,312tableformatting,Excel,402TableOptionsgroup,Ribbon,Excelcustomizingappearanceofdatabasetable,483tablestyle,Wordformattingdocuments,209TableStylespanel,Ribbon,Excelcustomizingappearanceofdatabasetable,482,483tables,ExcelseedatabasetablesunderExceltables,PowerpointseetablesunderPowerpointtables,WordseetablesunderWordIndex785Tabsbutton,Paragraphdialog,Word,226Tabsdialog,Word,226–228opening,226settingcustomtabstops,227tabs,Ribbon,28activetab,28Hometab,11PowerPoint,11tabs,WordseetabsunderWordTabularLayout,DesigngroupPivotTables,Excel,526,527TaskList,Outlook,726choosingcolumnstodisplayin,730–731filteringtasksin,732rearrangingcolumnsin,731–732Tasks,725–734choosingcolumnstodisplayinTaskList,730–731creatingonceonlytasks,726creatingrepeatingtasks,728–730editingtasks,733filteringtasks,732importing/syncingtasks,725interface,725–726keyboardshortcutforswitchingto,660managingtasks,733–734markingtasksascomplete,734markingtasksforfollow-up,733–734NavigationPane,659Outlookinterface,658–667rearrangingcolumnsinTaskList,731–732stoppingrepeatingtasks,730viewingtasks,730–732MyDaywindow,733templatescreatingdocuments,14–16Normaltemplate,165templates,ExcelSaveChartTemplatedialog,445templates,WordseetemplatesunderWordtextaddingcontenttotables,103–104addingitemstoScrapbook,34CopyandPastecommands,81,91–92Cutcommand,91–92directformattingtext,88–91enteringindocuments,81–86scanningandopticalcharacterrecognition,82speech-recognitionsoftware,82finding,93–97formattingtables,104–105hyperlinks,105–109insertingsymbolsindocuments,82–86movinginsertionpointwithkeyboard,87Pastecommand,91–92PowerPointseealsounderPowerPointReplacetextasyoutype,46replacing,97–99selecting,87–88tables,99–105WordseealsounderWordworkingwith,81textcategory,functions,Excel473TextDirectionpanel,PowerPointrotatingtext,578texthyperlinks,105,106TextLayoutgroup,Word,29TextlengthvalueDataValidationdialog,Excel,399Textnumberformat,Excel,388textoperators,Excel,457textplaceholder,PowerPointslidesaddingcontenttoslides,551TextWrappingtab,AdvancedLayoutdialog,129,130ThemedCellStylescategory,Excel,404Themespanel,PowerPoint,547themes,Excel,388themes,PowerPoint,547–548thesaurusReferenceToolspalette,35ThisFileIsLockedforEditingdialog,Word,308,309Thumbnailpane,Sidebar,Wordnavigatingdocuments,235Tickspane,FormatAxisdialog,Excel,437–438TIFF(TaggedImageFileFormat)filessavingPowerPointpresentationaspictures,643Tiledoption,ArrangeWindowsdialog,Excel,373Index786timehowExcelstorestimes,388insertingfields,Word,267Timebar,Calendar,710Timenumberformat,Excel,387Timevalue,datavalidation,Excel,399timezonechangingforrepeatingappointment,716customizingCalendarsettings,712TimeZonesbutton,Outlookcreatingappointments/events,716TitleandContentslidelayout,PowerPoint,573TitleandVerticalTextslidelayout,PowerPoint,573titlebar,Officeapplications,9Close/Minimize/Zoombuttons,9TitleOnlyslidelayout,PowerPoint,574titleplaceholder,PowerPointslidesaddingcontenttoslides,551TitleSlidelayout,PowerPoint,573title,chart,Excel,425addingtitletocharts,434Title,ContentandTextslidelayout,PowerPoint,574TitlesandHeadingscategory,CellStyles,Excel,404Tobox,Outlookaddressingmessages,668schedulingmeetings,720Tooption,ArrangeBymenuMessageList,Mail,663TODAY()function,Excel,469,470,473ToggleFieldCodesoption,Word,270toolbar,Mail,659toolbars,9–10,25,26AddaToolbardialog,157addingbuilt-inmenuto,152addingcommandto,149changingappearanceofbutton,150–151choosingwhichtodisplay,143–144creatingcustomtoolbars,157–158customizing,146–152Outlook,162–164Cut,Copy,andPastecommands,91deletingcustomtoolbars,158displaying/hidingtoolbars,10findingcommandstoaddto,148–149Formattingtoolbar,9iconswithtextoriconsonly,144Officeapplications,9–10removingcommandfrom,150repositioningitemson,150resettingtodefaultbuttons,159Standardtoolbar,9undockinganddocking,144–146using,28ToolbarsandMenustab,147creatingcustomtoolbars,157customizingcontextmenus,PowerPoint,156deletingcustomtoolbars,158Toolbox,31–38Closeoption,33,34Collapseoption,33,34CompatibilityReportpalette,36–38displayingpalettes,33Excel,32Fadeoption,33,34hidingToolbox,33PowerPoint,32ReferenceToolspalette,34,35–36Scrapbookpalette,34–35Settingspalette,33Stylespane,Word,210,213–216Word,31Top/BottomRulespanelconditionalformatting,Excel,395Totalrow,Excelcustomizingappearanceofdatabasetable,483,484Totalsmenu,DesigngroupPivotTables,Excel,526TraceDependentscommand,Excelviewingcellsusedbyformula,466–467TraceErrorcommand,Excel,465TracePrecedentscommand,Excelviewingcellsusedbyformula,466,467Trackchangesarea,ShareWorkbookdialog,418TrackChangespane,WordPreferences,310–313Index787TrackChanges,Word,309–320choosingchangestotrack,310–313combiningdifferentversionsofsamedocument,326controllingchangesdisplayed,317–318displayingScreenTips,316ensuringuseof,313–314HighlightChangesdialog,313integratingchangesintodocuments,318–320switchingsettingsformarkupballoons,315turningcommentballoonsoff,324turningon/off,313usinginFullScreenview,320viewingdocumentchangesandmarkup,316–317viewsof,314–316workingondocumentswithcolleagues,304workingwithTrackChangeson,314–316Trackmovescheckbox,TrackChanges,312trackingdocumentschangingnumberofrecentdocumentstracked,171Trackinggroup,Reviewtab,RibboncontrollingTrackChangesdisplayed,317viewingmarkup,TrackChanges,Word,316Transitionspanel,PowerPointapplyingtransitions,607,608Transitionstab,PowerPointaddingtransitionstoslides,606AdvanceSlidegroup,609applyingtransitions,607transitions,PowerPointaddingsoundto,608addingtoslides,606–609applyingtoallslides,609applyingtransitions,607–609categoriesof,606–607changingdurationof,609choosinghowtoadvancetonextslide,609choosingoptionsfor,608DynamicContenttransitions,606Excitingtransitions,606FerrisWheeltransition,606Honeycombtransition,608Nonetransition,606previewing,608Subtletransitions,606Vortextransition,608translationsReferenceToolspalette,36Transposecheckbox,PasteSpecialdialog,Excel,364trendsseesparklinesunderExcelchartsTRIM()function,Excel,473TRUE()function,Excel,473TwoContentslidelayout,PowerPoint,573typingspellcheckingwhile,57–58Uunderscores(___)AutoFormatoptions,Outlook,51UnhideRow/Columnoptions,Excel,382underlinekeyboardshortcuts,91Upoption,FindandReplacedialog,239Updatechangesarea,ShareWorkbookdialog,418UploadFailedbar,Wordeditingdocumentssimultaneously,307Usewildcardsoption,FindandReplacedialog,Word,240UserInformationcategoryinsertingfields,Word,268UserInformationpane,169–170Usertemplatesfolder,Word,192UsertemplatespathFileLocationspreferencespane,192VvalidatingdataseedatavalidationunderExcelVALUE!
error,Excel,464Valuesbox,PivotTableBuilder,516addingfields,519,520Index788changingPivotTable,521values,Excelpasting,363,364vCardfilescreatingfromGmailorGoogleMail,698–699creatingfromMacOSXAddressBook,697creatingfromYahoo!
Mail,698importingOutlookcontactsfrom,695,702VenndiagraminsertingSmartArt,137versionsCompatibilityReportpalette,36–38versions,Wordcomparingversionsofsamedocument,326–328compatibilitywithearlierversionsofWord,340–341verticalalignmentoftext,Excel,389verticalaxis,charts,Excel,425Verticaloption,ArrangeWindowsdialog,Excel,373verticalsplitbox,Excel,370VerticalTextandTitleslidelayout,PowerPoint,574VerticalTitleitem,Excel,435viewbuttons,Excel,350viewbuttons,Word,194ViewFootnotesdialog,Word,284Viewpop-upmenuoptions,CommandPropertiesdialog,151ViewShortcutsgroup,PowerPoint,556views,ExcelseeviewsunderExcelviews,WordseeviewsunderWordVortextransition,PowerPoint,608WWarningdialog,datavalidation,Excel,401WebLayoutview,Word,198WebPagetab,InsertHyperlinkdialog,107websearchesReferenceToolspalette,36Weekbutton,Calendar,711customizingCalendarsettings,712WEEKDAY()function,Excel,473Welcomeslide,PowerPointplanningslidesforpresentation,572WelcometoOutlookforMacdialog,650addinge-mailaccounttoOutlook,651importingexistinge-mailaccount,657Wholenumbervalue,datavalidation,Excel,398widow/orphancontrol,Paragraphdialog,Word,225widows,225wildcards,Word,238,240Windowscheckboxprotectingworkbook,Excel,416WindowsLiveaccount,40WindowsLiveIDbroadcastingPowerPointslideshow,639,640WindowsLiveSkyDriveseeSkyDrivewindows,ExcelseewindowsunderExcelwindows,PowerPointopeningextrawindows,560windows,WordseewindowsunderWordwin/losssparkline,Excel,446Word,4seealsoWorddocuments;OfficeapplicationsAutoCorrect,43–44,45AutoFormatoptions,46–47,48–50creatingentries,53–54creatingexceptions,54insertingboilerplatetext,182MathAutoCorrectoptions,51–53turningAutoCorrectoff,45AutoFormatAsYouTypeoptions,46–47,48–50Applyasyoutypearea,48Automaticallyasyoutypearea,49–50boldtext,49borders,48bulletedlists,48fractions,49headings,48hyphenswithemandendashes,49internetandnetworkpathswithhyperlinks,49italics,49listitemformat,50Index789numberedlists,48ordinals(1st)withsuperscript,49quotationmarks,48Replaceasyoutypearea,48–49styles,49tables,48tabsandbackspacesettingleftindent,49AutoTextoptions,51insertingprebuiltblocksoftext,182,183–186backupdocuments,creating,193–194Bookmarkdialog,264,265,266bookmarks,263–266addingcross-references,271deleting,266displaying,265–266inserting,264navigatingbetween,265single-pointbookmark,263withcontents,263borders,229–230bullets,228,234coauthoringdocuments,304–308columns,260–263columnbreaks,262creating,260–262creatingdocumentswithsections,252removing,263Columnsdialog,261CombineDocumentsdialog,327comments,321–325addingtodocuments,321–323browsingcomments,324deleting,325movingamongobjectsindocument,190protectingdocumentforcomments,321reviewing,323–324TrackChanges,312,317turningcommentbaloonsoff,324workingondocumentswithcolleagues,304CompareDocumentsdialog,326,327,328ConfirmPassworddialog,338ConvertNotesdialog,282,283ConvertTabletoTextdialog,250–251ConvertTexttoTabledialog,249–250Cross-referencedialog,272cross-referencesadding,270–272insertingfields,268CustomDictionariesdialog,72DataFormdialog,291editingrecordsin,292directformatting,88documentformats,173docx/dotxformats,341endnotes,277adding,279–280addingcross-references,271convertingto/fromfootnotes,277,282–283customizing,280–282movingamongobjectsindocument,190navigatingbetween,283,284ScreenTips,283viewing,283,284Extendmode,187Fielddialog,266–268FieldOptionsdialog,268,269,270fields,266–270creatingnewdatasourceinWord,290inserting,266–269MailMerge,Word,286movingamongobjectsindocument,190ToggleFieldCodesoption,270updating,269–270FindandReplacedialog,94,95,237–245Highlightallitemsfoundincheckbox,95,97replacingtext,97folders,17,18Fontdialog,222–223footnotes,277adding,277–279addingcross-references,271convertingto/fromendnotes,277,282–283Index790customizing,280–282navigatingbetween,283,284ScreenTips,283viewing,283,284format,341FormatPainterfeature,208formattingseeformattingunderWorddocumentsFormattingtoolbar,88,89GoTotab,FindandReplace,245–246grammarchecking,61–63,67–68,71grammaroptions,choosing,68–71graphicalobjects,inserting,112headersandfooters,254–257addingpagenumbersto,258addingtodocuments,254–256deleting,257multipleheadersandfooters,256–257headingsaddingcross-references,271keyboardshortcuts,220AutoFormatoptions,48outlinelevels,273Outlineview,274,275–276InsertTabledialog,100–102keyboardshortcutscreatingcustom,164–167navigatingdocumentusing,189styles,220MailMergeseeMailMerge,WordMailRecipientdialog,300MathAutoCorrectoptions,51–53Mathsymbols,using,51menubar,customizing,154–156menus,customizing,153–154numberingaddingcross-references,271addingtocustomstyle,228applyingdirectformattingontopofstyles,234chapternumbering,259footnotesandendnotes,280,281,282insertingfields,268suppresslinenumbersoption,226PageNumberFormatdialog,259pagenumbers,258–260addingcross-references,271addingtoheadersorfooters,258formatting,259insertingtextwithAutoText,183removing,260PageNumbersdialog,258Paragraphdialog,223,228paragraphsaddingcross-references,271convertingtabletotext,251convertingtexttotable,248,249findingformattingbasedon,242keepwithnextoption,pagination,226movingup/downdocument,276–277selectingusingmouse,187Passworddialog,337,338preferences,167,177Printdialog,77completingmailmerge,299printingseeprintingunderWorddocumentsProtectDocumentdialog,313,314recoveringworkfromdisaster,194Ribbon,customizing,159–161rtfformat,341SaveDataSourcedialog,291scanningtextintodocuments,181Searchbox,Standardtoolbar,93SelectBrowseObjectbutton,189SelectBrowseObjectpanel,190–191selectingmultipleitems,88selectingtext,187–188selectingmultipleitemsatonce,188usingExtendSelectionfeature,187–188usingmouse,187smartbuttons,55specialcharactersinsertingintodocuments,86usingMathsymbols,51spellchecking,57–60,63–67wholedocument,58Styledialog,216–217styles,88,208–209Index791seealsoformattingunderWorddocuments;stylesaddingbordersorshading,229–230addingbulletsornumbering,228addinglanguageformatting,230–231applyinganotherstyle,214applyingdirectformattingontopof,233–234applyingpicturestyle,133–134applyingtodocuments,210–221applyingtoshapes,126–127changing,217,220,232–233changinginQuickStyleGallery,218–220changingQuickStylessettings,217–218characterstyle,209checkingcurrentstyle,214choosingfontformatting,222–223choosinggrammarandstyleoptions,68–71choosingparagraphformatting,223–228choosingstylestoshowinlist,214creating,214,217,221–232deleting,216findingformattingbasedon,242FormatPainter,234keyboardshortcuts,220liststyle,209ModifyStyledialog,216modifying,209,217neverusingNormalasformattingforbody,211Normaltemplate,165,208pagebreakbeforeoption,pagination,226paragraphstyle,209printing,335QuickStylesbox,Ribbon,210–211replacingonestylewithanother,209selectingallinstancesof,214,215settingtabsfor,226,228storing,210tablestyle,209replacingformattingor,244–245togglingstylesguidesonandoff,214updatingstyletomatchselection,216updatingstylewithnewformatting,233viewingstylesusedbydocument,220–221wrappingtext,129Stylespane,213–216Stylespop-upmenu,212–213symbols,insertingintodocuments,82SymbolBrowserpane,83–84Symboldialog,84–86tables,99–105,247–252addingcontentto,104addingcross-references,271AutoFormatoptions,48Capitalizefirstletteroftablecells,46convertingtabletotext,250–251convertingtexttotable,248–250creating,247–248drawing,102,247formatting,104–105inserting,99–102,247insertingfields,267mergingcellsin,103movingamongobjectsindocument,190nesting,251–252splittingcellsin,103tabsbartab,227centertab,227changingdefaultspacing,226convertingtabletotext,251convertingtexttotable,248,249decimaltab,227Defaulttabstopstextbox,226deletingexistingtabstop,227findingformattingbasedon,242lefttab,227moving/changingtabstop,227righttab,227settingnewtabstop,227settingtabsforstyles,226–228Tabsdialog,226–228templates,14–16addingnewstylesto,220Index792dotxformat,341headersandfooters,254PublishingLayoutview,202specifyinglocationforcustomtemplates,191–193styles,storing,210textseealsotextconvertingtabletotext,250–251convertingtexttotable,248–250enteringtextintodocuments,181–186insertingboilerplatetextusingAutoCorrect,182insertingfromfileintodocument,181,182–183insertingprebuiltblockswithAutoText,182,183–186insertingspecialcharacters,86pastingintodocuments,181removingdirectformattingfrom,234replacing,97scanningintodocuments,181selecting,187–188wrapping,129–132,200ThisFileIsLockedforEditingdialog,308,309toolbars,customizing,149–152Toolbox,31TrackChangesseeTrackChanges,WordViewFootnotesdialog,284views,194–204addingcomments,321,322,323addingendnotes,279,280addingfootnotes,278Draftview,199–200FullScreenview,196–197MasterDocumentview,277NotebookLayoutview,200–202openingextrawindows,204–205Outlineview,199PrintLayoutview,195–196PublishingLayoutview,202–204selectingmostsuitableview,194–204splittingdocumentwindowintotwopanes,205–206switchingbetween,194–195WebLayoutview,198workingwithTrackChangeson,314–316windowsarrangingmultiplewindows,204openingextrawindows,204–205,273splittingintotwopanes,205–206,273switchingbetween,204workinginOutlineview,273WordCountdialogreadabilitystatistics,68WordDocumentGalleryspecifyinglocationforcustomtemplates,191WordDocumentGallerydialogPublishingLayoutview,Word,202WorddocumentsseealsoOfficeapplicationsautomation,267combiningdifferentversionsof,326comparingdifferentversionsof,326–328compatibilitywithearlierversions,340–341creatingbackupdocuments,193–194documentswithsections,252–253longdocuments,Outlineview,272–277PDFdocuments,342cross-references,adding,270–272editingsimultaneouslywithcolleagues,304–308creatingdocument,305editingdocument,306openingdocument,305resolvingconflicts,307,308updatingdocument,306viewingwhoiseditingdocument,305FindandReplacedialog,237–245formats,173formatting,207–210seealsostylesunderWordapplyingdirectformattingontopofstyles,233–234Index793AutoFormatoptions,49bestwaytoformatdocuments,209directformatting,88–91,208documentformats,173findingformattingbasedonstyles,242findingusingFindandReplace,241–243neverusingNormalstyleforbody,211paragraphformatting,223–228,233removingformattingcriteriafromsearch,243replacingformattingorstyles,244–245tables,104–105text,88togglingdirectformattingguideson/off,215updatingstylewithnewformatting,233GoTotab,FindandReplace,245–246headersandfooters,254–257insertinginformationabout,267MailMergeseeMailMerge,Wordnavigating,234–246FindandReplacedialog,237–245GoTotab,FindandReplace,245–246Searchbox,Standardtoolbar,236Searchpane,Sidebar,237Sidebarpane,234–236usingkeyboardshortcuts,189pagenumbers,258–260previewing,79printing,76–79,331–335completingmailmerge,299customrangeofpages,331–333markupanddocumentproperties,333–335specifyingcustomrange,333saving,16–19choosingdefaultformatfor,172–173settingAutoRecoverforbackups,174–175settingdefaultfoldersfor,175–176searchingpartof,239sectionsContinuoussectionbreak,253creatingcolumns,260creatingdocumentswith,252,253displayingsectionbreaks,253Evenpagesectionbreak,253insertingsectionbreak,253movingamongobjectsindocument,190Nextpagesectionbreak,253Oddpagesectionbreak,253printing,333usingdifferentheadersandfooters,257securing,335–340encryptingdocumentwithpassword,338markingdocumentasread-only,339–340protectingdocumentwithpassword,337–339removingsensitiveinformation,335–337restrictingaccess,335SelectBrowseObjectbutton,189SelectBrowseObjectpanel,190–191selectingwholedocument,187sharingdocuments,38–42compatibilitywithearlierversions,340–341creatingPDFdocuments,342onnetworks,308–309savingdocumentstoSharePoint,41–42savingdocumentstoSkyDrive,40–41sendingdocumentsviae-mail,38–39TrackChangesseeTrackChanges,Wordworkingasifloose-leafbinder,200workingonbodytextof,199workingondocumentswithcolleagues,303–304workingonmaximizedviewof,196workingonprintviewof,195workingonpublishingviewof,202workingonstructureof,199workingonwebviewof,198Index794WordPreferencesdialog,168–169AuthoringandProofingToolssection,200AutoCorrectpreferencespane,185AutoTexttab,185FileLocationspreferencespane,175,176,192Savepreferencespane,172Securitypane,335,336,339TrackChangespane,310–313displayingchanges,318turningcommentbaloonsoff,324UserInformationicon,169wordprocessingapplicationseeWordwordscustomdictionary,73–75Findallwordformsoption,240Findwholewordsonlyoption,239searchingonlyatstart/endof,241Soundslikeoption,240Workbutton,Calendar,711workhours,Calendarsettings,712Workview,Calendarsettings,712Workweekbar,Calendarsettings,712workbooks,ExcelseeExcelworkbooksWorkgrouptemplatesfolder,Word,192WorkgrouptemplatespathFileLocationspreferencespane,193workingtogetherondocuments/presentationsseecoauthoringworksheettabbar,Excel,350,351worksheettabs,Excel,350worksheets,ExcelseeExcelworksheetsworkspacemenu,NotebookLayoutview,Word,201wrapboundarymakingtextfitobject,Word,131Wrappingstylearea,Word,129wrappingtext,Excel,390wrappingtext,Word,129–132,200AdvancedLayoutdialog,129,130makingtextfitobject,131–132Formatdialog,129pictures,130Writingstylepop-upmenu,68,70WritingviewFullScreenview,Word,197usingTrackChangesin,320Xx-axis,charts,Excel,425XPSfilesaddingheaders/footers,Word,254YYahoo!
Exportscreen,698Yahoo!
MailcreatingvCardfilesfrom,698importingcontactsfrom,698y-axis,charts,Excel,425Zz-axis,charts,Excel,425addingaxistitlestochart,435Zoombutton,titlebar,9Zoomdialog,Excel,374Zoompop-upmenu,Excel,373Zoompop-upmenu,Word,197zooming,Excel,373–374