:Base XLMAIN8.HLP>REF :Title Microsoft Excel :Index Microsoft Excel=XLNEW8.HLP :Index Microsoft Excel=XLMAIN8.HLP :Link XL9701.HLP :Link XL9702.HLP :Link XL9703.HLP :Link XL9704.HLP :Link XL9705.HLP :Link OF9701.HLP :Link OF9702.HLP :Link OF9703.HLP :Link OF9704.HLP :Link OF9705.HLP 0 Microsoft Excel Microsoft Excel Microsoft Excel 97=xldecWhatsNewInMicrosoftExcel97@xlnew8.hlp Microsoft Excel 97=xlrefWhatsNewInMicrosoftExcel97ForDevelopers@xlnew8.hlp Microsoft Excel 97=xlrefWhatDoINeedToKnowAboutUpgradingConvertingFilesToMicrosoftExcel97@xlnew8.hlp Microsoft Excel 97=xlrefHowDoIGetStartedWithMicrosoftExcel@xlnew8.hlp Microsoft Excel=xldecWhatsInstalledWithMicrosoftExcel@xlnew8.hlp Microsoft Excel 97=xlrefHowDoIGetStartedWithMicrosoftExcel@xlnew8.hlp Microsoft Excel 97=xldecWhatsNewInMicrosoftExcel97@xlnew8.hlp Microsoft Excel 97=xlrefHowDoIGetStartedWithMicrosoftExcel@xlnew8.hlp Lotus 1-2-3=xldecIfYouAreSwitchingFromLotus123@xlnew8.hlp Quattro Pro=xldecIfYouAreSwitchingFromQuattroPro@xlnew8.hlp =oflrgWaysToGetAssistanceWhileYouWork@xlmain8.hlp>LgCard =ofhowChangeFontDisplayedInHelp@xlmain8.hlp>HowTo =ofhowPrintHelpTopic@xlmain8.hlp>HowTo Web- Microsoft Microsoft Excel=ofrefTheMicrosoftCorporationHomePage@xlmain8.hlp>HowTo Microsoft=ofdecConnectToMicrosoft@xlmain8.hlp>Ref =ofhowGetInformationAboutMyComputer@xlmain8.hlp>HowTo Visual Basic Microsoft Excel=rehowGetOnlineHelpForVisualBasic@xlmain8.hlp>HowTo Microsoft Office 97 Resource Kit=rerefObtainingTheMicrosoftOffice97ResourceKit@xlmain8.hlp>Ref Microsoft Office 97/Visual Basic Programmer's Guide=rerefObtainMicrosoftOffice97VisualBasicProgrammersGuide@xlmain8.hlp>Ref Microsoft =retbsICantUseCommandsOnMicrosoftOnTheWebSubmenuHelpMenu@xlmain8.hlp>Ref =ofdccMSWish@xlmain8.hlp>HowTo Microsoft Excel=!EF("XLREAD8.TXT","",5):Exit() =!EF("PSS8.HLP","",5):Exit() Office =ofdecGetHelpTipsUsingOfficeAssistant@xlmain8.hlp>Ref =IDH_ofdefShowOfficeAssistant@xlmain8.hlp>HowTo Microsoft Excel=ofhowShowTipOfDayWhenprogramStarts@xlmain8.hlp>HowTo =ofdccChangeSizeOfOfficeAssistant@xlmain8.hlp>HowTo =ofhowChangeOfficeAssistant@xlmain8.hlp>HowTo =ofhowMoveOfficeAssistant@xlmain8.hlp>HowTo =ofdccTurnOfficeAssistantSoundOnOrOff@xlmain8.hlp>HowTo =oftbcGetHelpWithoutShowingOfficeAssistant@xlmain8.hlp>HowTo =ofrefKeysForWorkingWithOfficeAssistant =ofhowTroubleshootOfficeAssistant@xlmain8.hlp>Ref Microsoft Office =ofhowViewOnlineGettingResultsBook@xlmain8.hlp>HowTo Microsoft Excel =xlidxAboutCreatingOpeningWorkbooks =xlidxAnalyzeDataFromExperiment =xlidxAnswersToQuestionsAboutFileCompatibility =xlidxAutomateRepetitiveTasks =xlidxConsolidateBudgetInput =xlidxCreateBusinessContactList =xlidxCreateBusinessReport =xlidxCreateChartFromWorksheetData =xlidxCreateDetailedSalesReport =xlidxCreateFormForOnlineCustomerQuotes =xlidxCreateMailing =xlidxCreateSalesForecast =xlidxCreateSalesSummary =xlidxCreateYourFirstWorkbook Microsoft Excel=xlidxCustomizeMicrosoftExcel =xlidxCustomizeLookOfChart =xlidxDevelopBudgetingAlternatives =xlidxDisplayDataOnMap =xlidxDisplayScientificDataInChart =xlidxDistributeDocumentsElectronically =xlidxGetAssistanceWhileYouWork =xlidxGetSalesInformationFromDatabase =xlidxGetYourPointAcrossWithGraphics Microsoft Excel=xlidxInstallStartMicrosoftExcel =xlidxMakeYourWorksheetLookGreat 5 Web Microsoft Excel=xlidxMicrosoftExcelWeb =xlidxPrepareCustomerQuote Web=xlidxCreateWebPageWithMicrosoftExcel =xlidxShareWorkbookWithCoworker =xlidxUseMicrosoftExcelWithOtherApplications Microsoft Excel=xlidxWhatsNewInMicrosoftExcel97 Microsoft Office =xlidxGettingResultsAboutCreatingOpeningDocumentsDatabases Office=xlidxGettingResultsCustomizeOffice Office=xlidxGettingResultsInstallStartMicrosoftOffice 5 Web Office=xlidxGettingResultsOfficeWeb Microsoft Office=oflistindexTakeAShortcutToWork Office=xlidxGettingResultsUsingOfficeApplicationsTogether Office 97=xlidxGettingResultsWhatsNewInOffice97 Microsoft Excel Microsoft Office Microsoft Excel=wohowInstallorremoveindividualcomponentsofWord@xlmain8.hlp>HowTo Microsoft Excel=xlrefAddinProgramsIncludedWithMicrosoftExcel =wohowAddNewFontToYourComputer>HowTo Microsoft Office Microsoft Excel=oftbsRegisterMicrosoftOfficeOrprogram@xlmain8.hlp>HowTo Office=oftbcImReceivingErrorMessageThatProgramCannotBeLocated@xlmain8.hlp>Ref =ofconCreateNewDocument@xlmain8.hlp>HowTo =xldecCreateForm =oflrgSetWorkingFolderToUseWhenIOpenOrSaveDocuments Microsoft Excel=xldecImportTextDataIntoMicrosoftExcel =ofdecOpenDocument =ofhowSelectMultipleFiles@xlmain8.hlp>HowTo =ofhowOpenDocumentReadOnly@xlmain8.hlp>HowTo Microsoft Excel=xlhowOpenworkbookswhenMicrosoftExcelstarts@xlmain8.hlp>HowTo =xlhowOpenabackupcopyofadocument@xlmain8.hlp>HowTo =ofhowViewAllFilesFileNameExtensions@xlmain8.hlp>HowTo =coconTheFavoritesFolderAndMyDocumentsFolder@xlmain8.hlp>HowTo =ofhowPrintSelectedFiles@xlmain8.hlp>HowTo Excel=ofhowShareFolderWithAnotherPerson>HowTo =cohowDisplayOrHideRecentlyUsedDocumentsOnTheFileMenu>HowTo =cotbsTroubleshootingProblemsFindingDocuments =codecViewAndEditDocumentProperties =cohowChangeTheUserNameThatAppearsInTheAuthorBox@xlmain8.hlp>HowTo =cohowViewFileContentsAndOtherFileInformation@xlmain8.hlp>HowTo =xlhowSetPropertiesToMakeFileReadonlyHiddenOrArchivable@xlmain8.hlp>HowTo Microsoft Outlook =ofhowCreateviewsofdocumentsbasedonproperties@xlmain8.hlp>HowTo =ofdecUseSavedSearchCriteriaToFindFiles@xlmain8.hlp>Ref =codecViewAndEditDocumentProperties@xlmain8.hlp>Ref =cohowSortAListOfFilesFound@xlmain8.hlp>HowTo =cohowDeleteASavedSearch@xlmain8.hlp>HowTo =ofhowGroupFilesByFolder>HowTo Find Fast=coconSpeedingUpFileSearches@xlmain8.hlp>Ref =cotbsTroubleshootingProblemsFindingDocuments@xlmain8.hlp>Ref =xlhowChangeTheDefaultFormatsUsedForNewWorkbooksAndSheets@xlmain8.hlp>HowTo =xldccModifyAnExistingTemplate@xlmain8.hlp>Ref Microsoft Excel=xlconTemplatesIncludedWithMicrosoftExcel@xlmain8.hlp>HowTo =xlhowInsertANewSheetBasedOnATemplateISelect>HowTo =xlhowCreateATemplateToExportWorksheetDataToADatabase>HowTo =xlconWhereShouldIStoreMyTemplates@xlmain8.hlp>Ref =xlconWhatSettingsCanISaveInATemplate@xlmain8.hlp>Ref =xltbsTroubleshootTemplates@xlmain8.hlp>Ref Office Binder=ofconOfficeBinder =xlconNamingDocumentsExcel@xlmain8.hlp>Ref =ofdecAboutOpenSaveDialogBoxes@xlmain8.hlp>Ref =xltbsTroubleshootProblemsWithSavingAndClosingDocuments Web- =xlhowCreateWebPageFromWorksheetData>HowTo =cohowCloseADocument@xlmain8.hlp>HowTo =xlhowCreateAndSaveAWorkspaceFile>HowTo =xldccSetDefaultFileFormatForSavingDocuments@xlmain8.hlp>HowTo =xltbsTroubleshootProblemsWithSavingAndClosingDocuments@xlmain8.hlp>Ref =ofhowCopyFile@xlmain8.hlp>HowTo =ofhowDeleteFile@xlmain8.hlp>HowTo =ofhowMoveFile@xlmain8.hlp>HowTo =ofhowRenameFile@xlmain8.hlp>HowTo Microsoft Excel Microsoft Excel=xldecImportTextDataIntoMicrosoftExcel Microsoft Excel 97 Microsoft Excel =xlconUsingFilesCreatedWithPreviousVersionsOfMicrosoftExcel Web- =xlhowCreateWebPageFromWorksheetData@xlmain8.hlp>HowTo Microsoft Excel=xlmscFileFormatsSuppliedWithMicrosoftExcel =xldecFormattingFeaturesNotTransferredInFileConversions Windows Macintosh=cohowMoveFilesBetweenWindowsAndTheMacintosh>HowTo =xldecTroubleshootConvertingFileFormats Microsoft Excel=xlconWorkbooksAndWorksheets@xlmain8.hlp>Ref Microsoft Excel=xlrefUsingshortcutkeys =xltbsTroubleshootWorkingWithWorkbooksWorksheets@xlmain8.hlp>Ref =xlhowMoveAndScrollWithinAWorksheet =xlhowSwitchToAnotherSheetInAWorkbook>HowTo =xlhowSelectSheetsInAWorkbook =xlhowDisplayMoreOrFewerSheetTabs>HowTo Microsoft Excel Microsoft IntelliMouse=xlhowScrollZoomThroughYourWorksheetByUsingIntelliMouse@xlmain8.hlp>Ref =xlnschowAddAWorksheet@xlmain8.hlp>HowTo =xlhowInsertANewSheetBasedOnATemplateISelect@xlmain8.hlp>HowTo =xlhowMoveOrCopySheets@xlmain8.hlp>HowTo =xlhowDeleteSheetsFromAWorkbook@xlmain8.hlp>HowTo =xlhowRenameASheet@xlmain8.hlp>HowTo =xlhowDisplayMoreOrFewerSheetTabs@xlmain8.hlp>HowTo =xldecHideAndUnhideWorkbooksAndSheets@xlmain8.hlp>Ref =xlhowDisplayHiddenWorkbook@xlmain8.hlp>HowTo =xlnschowDisplayAHiddenSheet@xlmain8.hlp>HowTo =xnsclhowDisplayHiddenRowsOrColumns@xlmain8.hlp>HowTo =xlhowChangeDefaultNumberOfWorksheetsInNewWorkbook@xlmain8.hlp>HowTo =xlhowChangeTheDefaultTemplateUsedForNewSheetsInAWorkbook@xlmain8.hlp>HowTo =xlhowRestoreOriginalSettingsNewWorkbooksWorksheets@xlmain8.hlp>HowTo =xlhowMagnifyOrReduceDisplay@xlmain8.hlp>HowTo =conschowDisplayTheFullScreen@xlmain8.hlp>HowTo =xlhowDisplayOrHideSpecificWindowElements@xlmain8.hlp>HowTo =xlhowChangeColorOfCellGridlines@xlmain8.hlp>HowTo =ofhowShowOrHideCommandBar>HowTo =ofhowMinimizeDocumentWindowToIcon@xlmain8.hlp>HowTo =ofhowRestoreDocumentIconToWindow@xlmain8.hlp>HowTo Microsoft Excel=ofhowArrangeDocumentIconsInProgramWindow@xlmain8.hlp>HowTo Windows=ofhowClearWindowsDesktop@xlmain8.hlp>HowTo =xlhowArrangeWindowsToViewMultipleWorksheets@xlmain8.hlp>HowTo =xlconSplittingWorksheetsAndFreezingPanes@xlmain8.hlp>Ref =xlhowRestoreSplitWindowToSinglePane@xlmain8.hlp>HowTo =xlrefCloseWorkbookWindows@xlmain8.hlp>Ref =xlconCustomViews@xlmain8.hlp>Ref =xlhowCreateOrDeleteAViewOfAWorksheet@xlmain8.hlp>HowTo =xlhowDisplayAViewOfAWorksheet@xlmain8.hlp>HowTo =xlhowPrintAViewOfAWorksheet@xlmain8.hlp>HowTo =xlhowDeleteAViewOfAWorksheet@xlmain8.hlp>HowTo =xlhowCreateAndSaveAWorkspaceFile@xlmain8.hlp>HowTo =xldecEnterDataInWorksheetCells@xlmain8.hlp>Ref =xlhowEnterNumbersWithFixedDecimalPlaces@xlmain8.hlp>HowTo =xldecAutomaticallyFillInDataBasedOnAdjacentCells@xlmain8.hlp>Ref =xlrefTypesOfSeriesYouCanCreateWithAutoFill@xlmain8.hlp>Ref =xlhowCancelOrUndoAnEntry@xlmain8.hlp>HowTo =xlhowChangeWayIEnterEditData@xlmain8.hlp>Ref =xlhowTypeAndOtherCharactersNotOnTheKeyboard>HowTo =xlconGuidelinesForEnteringDatesAndTimes@xlmain8.hlp>Ref =xlconGuidelinesForEnteringNumbers@xlmain8.hlp>Ref =xlconGuidelinesForEnteringText@xlmain8.hlp>Ref =xltbsTroubleshootEnteringData@xlmain8.hlp>Ref =xlhowMoveAndScrollWithinAWorksheet@xlmain8.hlp>Ref =xldecSelectCellsOfAWorksheet@xlmain8.hlp>Ref =xlSelectCellsThatContainSpecificTypesOfDataSuchAsFormulasOrConstants@xlmain8.hlp>HowTo =xlhowSelectVisibleCellsOnly@xlmain8.hlp>HowTo =xlhowSwitchToAnotherSheetInAWorkbook@xlmain8.hlp>HowTo =xlhowSelectSheetsInAWorkbook@xlmain8.hlp>Ref =xlhowCancelASelection@xlmain8.hlp>HowTo =xlCancelSelectionOfMultipleSheets@xlmain8.hlp>HowTo =xltbsTroubleshootSelectingAndMovingInAWorkbook@xlmain8.hlp>Ref =xlhowEditcellcontents@xlmain8.hlp>HowTo =xlconInsertinganddeletingcells@xlmain8.hlp>Ref =xlhowClearrowsandcolumns>HowTo =xlhowUndoMistakes@xlmain8.hlp>HowTo =xlhowRepeatMyLastAction@xlmain8.hlp>HowTo =xlhowSeparateTextValuesAcrossCells@xlmain8.hlp>HowTo =xltbsTroubleshootEditingData@xlmain8.hlp>Ref =xlhowFindOrReplaceTextOrNumbers@xlmain8.hlp>Ref =xldecIdentifyCellValuesThatMeetConditionsYouSpecify =xlhowFilteringAList>HowTo =xllrgWildcardCharactersYouCanUseToFindText@xlmain8.hlp>Ref =xldecMoveOrCopyCells@xlmain8.hlp>Ref =xlhowCopythecellformula>HowTo =xlhowCopyvisiblecells@xlmain8.hlp>HowTo =xlhowTransposerowsandcolumnsasyoupaste@xlmain8.hlp>HowTo =xlInsertCellsRowsOrColumns@xlmain8.hlp>Ref =xldecCheckSpellingOrAutomaticallyCorrectSpellingErrors@xlmain8.hlp>Ref =xlconWhichPartsOfWorksheetAreCheckedForSpelling@xlmain8.hlp>Ref =xlhownxlscTurnOffAutoCorrect@xlmain8.hlp>HowTo =wohowChangeTheContentsOfAnAutoCorrectEntry@xlmain8.hlp>HowTo =wohowDeleteanAutoCorrectentry@xlmain8.hlp>HowTo =xlhowPreventAutoCorrectFromCorrectingSpecificAbbreviationsOrCapitalizedText@xlmain8.hlp>HowTo =xltbsTroubleshootCorrectingSpellingTypingErrors@xlmain8.hlp>Ref =xllrgBasicFormatting@xlmain8.hlp>LgCard =xlhowCopyFormatsFromOneCellOrRangeToAnother@xlmain8.hlp>HowTo =xlhowChangeSizeFontColorOrOtherTextFormat@xlmain8.hlp>Ref =xlhowDisplayMultipleLinesOfTextWithinCell>HowTo =xldecIdentifyCellValuesThatMeetConditionsYouSpecify@xlmain8.hlp>Ref =xlhowFormatPivotTable>HowTo =xltbsTroubleshootFormattingCellsData@xlmain8.hlp>Ref =xldccAddBordersToCells@xlmain8.hlp>HowTo =xlhowShadeCellsWithSolidColors@xlmain8.hlp>HowTo =xlhowShadeCellsWithPatternedShading@xlmain8.hlp>HowTo =xlhowRemoveBorders@xlmain8.hlp>HowTo =xlhowRemoveShading@xlmain8.hlp>HowTo =xlhowAddBackgroundPatternsToSheets@xlmain8.hlp>HowTo =xlhowRemoveBackgroundPatternsFromSheet@xlmain8.hlp>HowTo =xlhowDisplayMultipleLinesOfTextWithinCell@xlmain8.hlp>HowTo =xlhowAdjustColumnWidthAndRowHeight@xlmain8.hlp>Ref =xldccMergeCellsToSpanSeveralColumnsOrRows@xlmain8.hlp>HowTo =xlhowSplitMergedCellIntoSeparateCells@xlmain8.hlp>HowTo =xllrgNumberFormatting@xlmain8.hlp>LgCard Microsoft Excel=xlhowChangeWayMicrosoftExcelDisplaysNumbersDatesTimes@xlmain8.hlp>HowTo =xlhowCreatecustomnumberformats@xlmain8.hlp>HowTo =xldefCustomNumberFormats@xlmain8.hlp>Ref =xlhowDeletecustomnumberformats@xlmain8.hlp>HowTo =xldecDisplayOrHideZeroValuesOrOtherCellData@xlmain8.hlp>Ref =xlhowDisplayFormulasOrFormulaResultsOnWorksheet@xlmain8.hlp>HowTo =xlhowFormatnumbersastext@xlmain8.hlp>HowTo =xltbsTroubleshootFormattingNumbersDatesTimes@xlmain8.hlp>Ref =xldecFormatCellsListsQuicklyWithStylesOrBuiltinTableFormats@xlmain8.hlp>Ref =xlhowCreateastylebyexample@xlmain8.hlp>HowTo =xlhowRemoveStyleFromSelectedCells@xlmain8.hlp>HowTo =xlhowClearanautoformat@xlmain8.hlp>HowTo =xlhowRedefineastylebyexample@xlmain8.hlp>HowTo =xlhowDeleteastyle@xlmain8.hlp>HowTo =xlhowCopystylesfromanotherworkbook@xlmain8.hlp>HowTo =xlhowSaveStylesToTheAutotemplate@xlmain8.hlp>HowTo =xllrgWhatToDoBeforeYouPrint@xlmain8.hlp>LgCard =xldccPrintSheetSelectedRangeOrEntireWorkbook@xlmain8.hlp>HowTo =xlhowTroubleshootPrinting@xlmain8.hlp>Ref =ofhowViewPrinterStatusInformationAboutDocumentsPrinting@xlmain8.hlp>HowTo =ofhowCreateFax@xlmain8.hlp>HowTo =ofhowSetUpNewPrinter@xlmain8.hlp>HowTo =ofhowSetDefaultPrinterInWindows@xlmain8.hlp>HowTo =xldccPrintRowColumnHeadingsOnEveryPage>HowTo =xldccPrintRowColumnLabelsOnEveryPage>HowTo =xldccPrintCellGridlines@xlmain8.hlp>HowTo =xldccPrintComments>HowTo =xldecPrintMoreThanCopyOfWorksheetMoreThanOneWorkbookOrPrintToFile@xlmain8.hlp>Ref Excel=xldecPrintWorksheetQuickly@xlmain8.hlp>Ref =xlhowSizeAndSetUpAChartSheetForPrinting>HowTo =xldecChangeOrRemovePrintArea@xlmain8.hlp>HowTo =xldccRemovePrintArea@xlmain8.hlp>HowTo =xldecInsertAndRemovePageBreaks@xlmain8.hlp>Ref =xlHowRemovePageBreaks@xlmain8.hlp>HowTo =xlhowSetPageMargins@xlmain8.hlp>HowTo Excel=xldecChangeLayoutOfPrintedWorksheet@xlmain8.hlp>Ref Excel, =xldecPrintWorksheetOnSpecificNumberOfPages@xlmain8.hlp>Ref =xldccPrintRowColumnHeadingsOnEveryPage@xlmain8.hlp>HowTo =xldccPrintRowColumnLabelsOnEveryPage@xlmain8.hlp>HowTo =xldccUseBuiltinHeaderOrFooter@xlmain8.hlp>HowTo =xlHowCreateCustomHeadersAndFooters@xlmain8.hlp>HowTo =xlhowSetHeaderAndFooterMargins@xlmain8.hlp>HowTo =xlhowFormatHeadersAndFooters@xlmain8.hlp>HowTo =xldccChangeFirstPageNumber@xlmain8.hlp>HowTo =xlconReportsProducedByUsingViewsScenarios@xlmain8.hlp>Ref =xlhowCreateAReport@xlmain8.hlp>HowTo =xlhowEditAReport@xlmain8.hlp>HowTo =xlhowPrintAReport@xlmain8.hlp>HowTo =xlcmdReportNameFilePrintReportPrintReportDialogBoxAddButtonAddReportDialogBox@xlmain8.hlp>Ref )=xlcmdPrintReportCommandFileMenu@xlmain8.hlp>Ref =xllrgFormsOnWorksheet@xlmain8.hlp>LgCard =xldecCreateForm@xlmain8.hlp>Ref =xldecFormatWorksheetToUseAsForm@xlmain8.hlp>Ref =xlconGuidelinesForPrintedOnlineForms@xlmain8.hlp>Ref =xlrefTipsForCreatingForms@xlmain8.hlp>Ref =xlhowFillInOnlineForm@xlmain8.hlp>HowTo =worefTroubleshootingforonlineforms@xlmain8.hlp>Ref =xlconAboutActiveXControls@xlmain8.hlp>Ref =xltbcAddButtonsCheckBoxesOrOtherControlsToWorksheet@xlmain8.hlp>Ref =xlrefTypesOfButtonsCheckBoxesOtherControlsOnFormsToolbar@xlmain8.hlp>Ref ActiveX=xlrefTypeOfActiveXControls@xlmain8.hlp>Ref ActiveX=xlhowAutomateTaskByUsingActiveXControl@xlmain8.hlp>HowTo =xltbcChangePropertiesOfButtonCheckBoxOrOtherControl@xlmain8.hlp>HowTo ActiveX=xlhowChangePropertiesOfActiveXControl@xlmain8.hlp>HowTo =xltbsTroubleshootButtonsCheckBoxesOtherControls@xlmain8.hlp>Ref =xlconWhenShouldIUseTheTemplateWizard@xlmain8.hlp>Ref =xlhowCreateATemplateToExportWorksheetDataToADatabase@xlmain8.hlp>HowTo =xlhowChangeRecordInLinkedDatabaseCreatedWithTemplateWizard@xlmain8.hlp>HowTo =xldecAddToOrChangeListByUsingDataForm Microsoft Excel Microsoft Access=xlhowCreatingANewAccessFormWizardFormInMicrosoftExcel>HowTo Microsoft Access Microsoft Excel=xlhowUseAnExistingFormForDataEntry>HowTo =xllrgQuickCalculationsInWorksheet@xlmain8.hlp>LgCard =xltbsTroubleshootErrorValues@xlmain8.hlp>Ref =xlrefCommonProblemsInFormulas@xlmain8.hlp>Ref =xlconHowFormulasWork@xlmain8.hlp>Ref =xlconAboutFormulaSyntax@xlmain8.hlp>Ref =xlconAboutUsingFormulaPaletteToEnterEditFormulas@xlmain8.hlp>Ref =xlrefUnderstandinghowOperatorswork@xlmain8.hlp>Ref =xlrefTheOrderOfEvaluationOfOperators@xlmain8.hlp>Ref =xlrefHowMicrosoftExcelhandlesunexpectedvaluesinformulas@xlmain8.hlp>Ref Microsoft Excel=xlrefHowMicrosoftExcelPerformsDateTimeCalculations@xlmain8.hlp>Ref =xldccCreateFormulaToCalculateValue@xlmain8.hlp>Ref =xlrefExamplesOfCommonFormulas@xlmain8.hlp>Ref =xlrefDisplayformulasandvaluesonaworksheet@xlmain8.hlp>HowTo =xlhowEditformulasthatcontainfunctions@xlmain8.hlp>HowTo =xlhowEditanarrayformula@xlmain8.hlp>HowTo =xlhowMoveOrCopyFormula@xlmain8.hlp>HowTo =xldecReplacePartOrAllOfFormulaWithItsCalculatedValue@xlmain8.hlp>Ref =xlhowDeleteFormulaOrArrayFormula@xlmain8.hlp>HowTo =xlrefReferencestyles@xlmain8.hlp>Ref =xlconTheDifferenceBetweenRelativeAbsoluteReferences@xlmain8.hlp>Ref R1C1=xlrefAboutR1C1References@xlmain8.hlp>Ref =xldecUseReferenceToSameCellOrRangeOnMultipleSheets@xlmain8.hlp>HowTo =xlrefGuidelinesForUsing3DReferences@xlmain8.hlp>Ref =xlconWhatHappensTo3DReferencesWhenYouMoveOrDeleteCells@xlmain8.hlp>Ref =xlconUsingfunctions@xlmain8.hlp>Ref =xlhowCreateANestedFunction@xlmain8.hlp>Ref =xlrefAboutDatabaseFunctions@xlmain8.hlp>Ref =xlrefAboutDateTimeFunctions@xlmain8.hlp>Ref =xlrefAboutEngineeringFunctions@xlmain8.hlp>Ref =xlrefAboutFinancialFunctions@xlmain8.hlp>Ref =xlrefAboutInformationFunctions@xlmain8.hlp>Ref =xlrefAboutLogicalFunctions@xlmain8.hlp>Ref =xlrefAboutLookupReferenceFunctions@xlmain8.hlp>Ref =xlrefAboutMathTrigonometryFunctions@xlmain8.hlp>Ref =xlrefAboutStatisticalFunctions@xlmain8.hlp>Ref =xlrefAboutTextFunctions@xlmain8.hlp>Ref =xlrefAboutUserDefinedFunctions@xlmain8.hlp>Ref =xlconLabelsNamesInFormulas@xlmain8.hlp>Ref =xlconAboutLabelingRangesByUsingLabelRangesCommand@xlmain8.hlp>Ref Microsoft Excel=xlconRulesForNames@xlmain8.hlp>Ref =xldecNameCellsInWorkbook@xlmain8.hlp>Ref =xlhowNameaformulaorreference@xlmain8.hlp>HowTo =xlhowCheckwhatanamerefersto@xlmain8.hlp>HowTo =xlhowReplacecellreferenceswithadefinedname@xlmain8.hlp>HowTo =xlhowEditthereferenceorformulaforaname@xlmain8.hlp>HowTo =xlhowChangeanamedreference@xlmain8.hlp>HowTo =xlconArrayformulas@xlmain8.hlp>Ref =xlconConstantsinanarray@xlmain8.hlp>Ref =xlrefItemsThatArrayConstantCanContain@xlmain8.hlp>Ref =xlhowSelectanarrayrange@xlmain8.hlp>HowTo =xlconControllingcalculationsinaworksheet@xlmain8.hlp>Ref =xldecChangeHowMicrosoftExcelCalculatesFormulas@xlmain8.hlp>Ref =xlhowManuallycalculateallopenworkbooks@xlmain8.hlp>HowTo =xlconControllingcircularreferenceformulas@xlmain8.hlp>Ref =xlhowIdentifyWorkWithCellsThatCreateCircularReference>HowTo =xlconWhentolinkworkbooks@xlmain8.hlp>Ref =xlhowEnteranexternalreferenceinaformula@xlmain8.hlp>HowTo =xlhowOpenasourceworkbook@xlmain8.hlp>HowTo =xlhowRedirectlinksforasourceworkbook@xlmain8.hlp>HowTo #####=xlrefWhatTheErrorValueMeans /0!=xlrefWhatTheErrorValueDIV0Means =xlrefWhatTheErrorValueNAMeans ?=xlrefWhatTheErrorValueNAMEMeans !=xlrefWhatTheErrorValueNULLMeans !=xlrefWhatTheErrorValueNUMMeans !=xlrefWhatTheErrorValueREFMeans !=xlrefWhatTheErrorValueVALUEMeans =xlfctDatabaseFunctions>LangRef =xlfctDAVERAGE>LangRef =xlfctDCOUNT>LangRef =xlfctDCOUNTA>LangRef =xlfctDGET@xlmain8.hlp>LangRef =xlfctDMAX>LangRef =xlfctDMIN>LangRef =xlfctDPRODUCT@xlmain8.hlp>LangRef =xlfctDSTDEV@xlmain8.hlp>LangRef =xlfctDSTDEVP@xlmain8.hlp>LangRef =xlfctDSUM@xlmain8.hlp>LangRef =xlfctDVAR>LangRef =xlfctDVARP>LangRef =xlfctGETPIVOTDATA@xlmain8.hlp>LangRef =xlfctDATE@xlmain8.hlp>LangRef =xlfctDATEVALUE@xlmain8.hlp>LangRef =xlfctDAY@xlmain8.hlp>LangRef 360=xlfctDAYS360@xlmain8.hlp>LangRef =xlfctEDATE>LangRef =xlfctEOMONTH@xlmain8.hlp>LangRef =xlfctHOUR@xlmain8.hlp>LangRef =xlfctMINUTE@xlmain8.hlp>LangRef =xlfctMONTH@xlmain8.hlp>LangRef =xlfctNETWORKDAYS@xlmain8.hlp>LangRef =xlfctNOW@xlmain8.hlp>LangRef =xlfctSECOND>LangRef =xlfctTIME>LangRef =xlfctTIMEVALUE>LangRef =xlfctTODAY>LangRef =xlfctWEEKDAY>LangRef =xlfctWEEKNUM>LangRef =xlfctWORKDAY>LangRef =xlfctYEAR>LangRef =xlfctYEARFRAC@xlmain8.hlp>LangRef =xlfctCALL>LangRef =xlfctREGISTERID>LangRef 4 SQL.REQUEST=xlfctSQLREQUEST>LangRef =xlfctUsingCALLandREGISTERFunctions>LangRef .I=xlfctBESSELI@xlmain8.hlp>LangRef .J=xlfctBESSELJ@xlmain8.hlp>LangRef .K=xlfctBESSELK@xlmain8.hlp>LangRef .Y=xlfctBESSELY@xlmain8.hlp>LangRef =xlfctBIN2DEC@xlmain8.hlp>LangRef =xlfctBIN2HEX@xlmain8.hlp>LangRef =xlfctBIN2OCT@xlmain8.hlp>LangRef =xlfctCOMPLEX@xlmain8.hlp>LangRef =xlfctCONVERT@xlmain8.hlp>LangRef =xlfctDEC2BIN@xlmain8.hlp>LangRef =xlfctDEC2HEX@xlmain8.hlp>LangRef =xlfctDEC2OCT@xlmain8.hlp>LangRef =xlfctDELTA@xlmain8.hlp>LangRef =xlfctERF@xlmain8.hlp>LangRef =xlfctERFC@xlmain8.hlp>LangRef =xlfctGESTEP@xlmain8.hlp>LangRef =xlfctHEX2BIN@xlmain8.hlp>LangRef =xlfctHEX2DEC@xlmain8.hlp>LangRef =xlfctHEX2OCT@xlmain8.hlp>LangRef .ABS=xlfctIMABS>LangRef =xlfctIMAGINARY>LangRef =xlfctIMARGUMENT@xlmain8.hlp>LangRef =xlfctIMCONJUGATE@xlmain8.hlp>LangRef .COS=xlfctIMCOS@xlmain8.hlp>LangRef =xlfctIMDIV@xlmain8.hlp>LangRef .EXP=xlfctIMEXP>LangRef .LN=xlfctIMLN>LangRef .LOG10=xlfctIMLOG10>LangRef .LOG2=xlfctIMLOG2>LangRef =xlfctIMPOWER@xlmain8.hlp>LangRef =xlfctIMPRODUCT@xlmain8.hlp>LangRef =xlfctIMREAL>LangRef .SIN=xlfctIMSIN@xlmain8.hlp>LangRef =xlfctIMSQRT@xlmain8.hlp>LangRef =xlfctIMSUB@xlmain8.hlp>LangRef =xlfctIMSUM>LangRef =xlfctOCT2BIN@xlmain8.hlp>LangRef =xlfctOCT2DEC@xlmain8.hlp>LangRef =xlfctOCT2HEX@xlmain8.hlp>LangRef =xlfctACCRINT>LangRef =xlfctACCRINTM>LangRef =xlfctAMORDEGRC@xlmain8.hlp>LangRef =xlfctAMORLINC@xlmain8.hlp>LangRef =xlfctCOUPDAYBS>LangRef =xlfctCOUPDAYS>LangRef =xlfctCOUPDAYSNC>LangRef =xlfctCOUPNCD>LangRef =xlfctCOUPNUM>LangRef =xlfctCOUPPCD>LangRef =xlfctCUMIPMT>LangRef =xlfctCUMPRINC>LangRef =xlfctDB@xlmain8.hlp>LangRef =xlfctDDB>LangRef =xlfctDISC>LangRef =xlfctDOLLARDE>LangRef =xlfctDOLLARFR>LangRef =xlfctDURATION>LangRef =xlfctEFFECT>LangRef =xlfctFV@xlmain8.hlp>LangRef =xlfctFVSCHEDULE@xlmain8.hlp>LangRef =xlfctINTRATE>LangRef =xlfctIPMT@xlmain8.hlp>LangRef =xlfctIRR>LangRef =xlfctMDURATION>LangRef =xlfctMIRR@xlmain8.hlp>LangRef =xlfctNOMINAL>LangRef =xlfctNPER@xlmain8.hlp>LangRef =xlfctNPV@xlmain8.hlp>LangRef =xlfctODDFPRICE>LangRef =xlfctODDFYIELD>LangRef =xlfctODDLPRICE>LangRef =xlfctODDLYIELD>LangRef =xlfctPMT>LangRef =xlfctPPMT>LangRef =xlfctPRICE@xlmain8.hlp>LangRef =xlfctPRICEDISC>LangRef =xlfctPRICEMAT>LangRef =xlfctPV>LangRef =xlfctRATE>LangRef =xlfctRECEIVED>LangRef =xlfctSLN>LangRef =xlfctSYD>LangRef =xlfctTBILLEQ>LangRef =xlfctTBILLPRICE>LangRef =xlfctTBILLYIELD>LangRef =xlfctVDB>LangRef =xlfctXIRR>LangRef =xlfctXNPV>LangRef =xlfctYIELD>LangRef =xlfctYIELDDISC>LangRef =xlfctYIELDMAT>LangRef =xlfctCELL>LangRef =xlfctCOUNTBLANK@xlmain8.hlp>LangRef =xlfctERRORTYPE>LangRef =xlfctINFO@xlmain8.hlp>LangRef =xlfctISFunctions>LangRef =xlfctISEVEN@xlmain8.hlp>LangRef =xlfctISODD@xlmain8.hlp>LangRef =xlfctN@xlmain8.hlp>LangRef =xlfctNA@xlmain8.hlp>LangRef =xlfctTYPE>LangRef =xlfctAND@xlmain8.hlp>LangRef =xlfctFALSE@xlmain8.hlp>LangRef =xlfctIF@xlmain8.hlp>LangRef =xlfctNOT@xlmain8.hlp>LangRef =xlfctOR>LangRef =xlfctTRUE>LangRef =xlfctADDRESS@xlmain8.hlp>LangRef =xlfctAREAS@xlmain8.hlp>LangRef =xlfctCHOOSE>LangRef =xlfctCOLUMN>LangRef =xlfctCOLUMNS>LangRef =xlfctHLOOKUP>LangRef =xlfctHYPERLINK@xlmain8.hlp>LangRef =xlfctINDEX>LangRef =xlfctINDIRECT@xlmain8.hlp>LangRef =xlfctLOOKUP>LangRef =xlfctMATCH>LangRef =xlfctOFFSET>LangRef =xlfctROW@xlmain8.hlp>LangRef =xlfctROWS>LangRef =xlfctTRANSPOSE>LangRef =xlfctVLOOKUP>LangRef 4 ABS=xlfctABS@xlmain8.hlp>LangRef 4 ACOS=xlfctACOS@xlmain8.hlp>LangRef 4 ACOSH=xlfctACOSH@xlmain8.hlp>LangRef 4 ASIN=xlfctASIN@xlmain8.hlp>LangRef 4 ASINH=xlfctASINH@xlmain8.hlp>LangRef 4 ATAN=xlfctATAN@xlmain8.hlp>LangRef 4 ATAN2=xlfctATAN2@xlmain8.hlp>LangRef 4 ATANH=xlfctATANH@xlmain8.hlp>LangRef =xlfctCEILING@xlmain8.hlp>LangRef =xlfctCOMBIN@xlmain8.hlp>LangRef 4 COS=xlfctCOS@xlmain8.hlp>LangRef 4 COSH=xlfctCOSH@xlmain8.hlp>LangRef =xlfctCOUNTIF@xlmain8.hlp>LangRef =xlfctDEGREES>LangRef =xlfctEVEN@xlmain8.hlp>LangRef 4 EXP=xlfctEXP@xlmain8.hlp>LangRef =xlfctFACT@xlmain8.hlp>LangRef =xlfctFACTDOUBLE@xlmain8.hlp>LangRef =xlfctFLOOR@xlmain8.hlp>LangRef =xlfctGCD@xlmain8.hlp>LangRef =xlfctINT@xlmain8.hlp>LangRef =xlfctLCM@xlmain8.hlp>LangRef 4 LN=xlfctLN@xlmain8.hlp>LangRef 4 LOG=xlfctLOG@xlmain8.hlp>LangRef 4 LOG10=xlfctLOG10@xlmain8.hlp>LangRef =xlfctMDETERM@xlmain8.hlp>LangRef =xlfctMINVERSE@xlmain8.hlp>LangRef =xlfctMMULT@xlmain8.hlp>LangRef =xlfctMOD@xlmain8.hlp>LangRef =xlfctMROUND@xlmain8.hlp>LangRef =xlfctMULTINOMIAL@xlmain8.hlp>LangRef =xlfctODD@xlmain8.hlp>LangRef =xlfctPI>LangRef =xlfctPOWER@xlmain8.hlp>LangRef =xlfctPRODUCT>LangRef =xlfctQUOTIENT@xlmain8.hlp>LangRef =xlfctRADIANS>LangRef =xlfctRAND>LangRef =xlfctRANDBETWEEN@xlmain8.hlp>LangRef =xlfctROMAN>LangRef =xlfctROUND>LangRef =xlfctROUNDDOWN@xlmain8.hlp>LangRef =xlfctROUNDUP@xlmain8.hlp>LangRef =xlfctSERIESSUM@xlmain8.hlp>LangRef =xlfctSIGN>LangRef 4 SIN=xlfctSIN>LangRef 4 SINH=xlfctSINH>LangRef =xlfctSQRT>LangRef =xlfctSQRTPI@xlmain8.hlp>LangRef =xlfctSUBTOTAL>LangRef =xlfctSUM>LangRef =xlfctSUMIF@xlmain8.hlp>LangRef =xlfctSUMPRODUCT>LangRef =xlfctSUMSQ@xlmain8.hlp>LangRef =xlfctSUMX2MY2>LangRef =xlfctSUMX2PY2>LangRef =xlfctSUMXMY2>LangRef 4 TAN=xlfctTAN@xlmain8.hlp>LangRef 4 TANH=xlfctTANH>LangRef =xlfctTRUNC>LangRef =xlfctAVEDEV@xlmain8.hlp>LangRef =xlfctAVERAGE@xlmain8.hlp>LangRef =xlfctAveragea@xlmain8.hlp>LangRef =xlfctBETADIST>LangRef =xlfctBETAINV>LangRef =xlfctBINOMDIST>LangRef =xlfctCHIDIST>LangRef =xlfctCHIINV>LangRef =xlfctCHITEST>LangRef =xlfctCONFIDENCE>LangRef =xlfctCORREL>LangRef =xlfctCOUNT@xlmain8.hlp>LangRef =xlfctCOUNTA@xlmain8.hlp>LangRef =xlfctCOVAR@xlmain8.hlp>LangRef =xlfctCRITBINOM>LangRef =xlfctDEVSQ>LangRef =xlfctEXPONDIST>LangRef =xlfctFDIST>LangRef =xlfctFINV>LangRef =xlfctFISHER>LangRef =xlfctFISHERINV>LangRef =xlfctFORECAST>LangRef =xlfctFREQUENCY@xlmain8.hlp>LangRef =xlfctFTEST>LangRef =xlfctGAMMADIST>LangRef =xlfctGAMMAINV>LangRef =xlfctGAMMALN@xlmain8.hlp>LangRef =xlfctGEOMEAN>LangRef =xlfctGROWTH>LangRef =xlfctHARMEAN>LangRef =xlfctHYPGEOMDIST>LangRef =xlfctINTERCEPT@xlmain8.hlp>LangRef =xlfctKURT>LangRef =xlfctLARGE>LangRef =xlfctLINEST>LangRef =xlfctLOGEST@xlmain8.hlp>LangRef =xlfctLOGINV@xlmain8.hlp>LangRef =xlfctLOGNORMDIST>LangRef =xlfctMAX>LangRef =xlfctMAXA@xlmain8.hlp>LangRef =xlfctMEDIAN@xlmain8.hlp>LangRef =xlfctMIN@xlmain8.hlp>LangRef =xlfctMINA@xlmain8.hlp>LangRef =xlfctMODE@xlmain8.hlp>LangRef =xlfctNEGBINOMDIST>LangRef =xlfctNORMDIST>LangRef =xlfctNORMINV>LangRef =xlfctNORMSDIST>LangRef =xlfctNORMSINV>LangRef =xlfctPEARSON>LangRef =xlfctPERCENTILE>LangRef =xlfctPERCENTRANK>LangRef =xlfctPERMUT>LangRef =xlfctPOISSON>LangRef =xlfctPROB>LangRef =xlfctQUARTILE>LangRef =xlfctRANK@xlmain8.hlp>LangRef =xlfctRSQ>LangRef =xlfctSKEW>LangRef =xlfctSLOPE>LangRef =xlfctSMALL>LangRef =xlfctSTANDARDIZE>LangRef =xlfctSTDEV>LangRef =xlfctSTDEVA@xlmain8.hlp>LangRef =xlfctSTDEVP>LangRef =xlfctSTDEVPA@xlmain8.hlp>LangRef YX=xlfctSTEYX>LangRef =xlfctTDIST>LangRef =xlfctTINV>LangRef =xlfctTREND>LangRef =xlfctTRIMMEAN>LangRef =xlfctTTEST>LangRef =xlfctVAR>LangRef =xlfctVARA@xlmain8.hlp>LangRef =xlfctVARP>LangRef =xlfctVARPA@xlmain8.hlp>LangRef =xlfctWEIBULL@xlmain8.hlp>LangRef =xlfctZTEST>LangRef =xlfctCHAR@xlmain8.hlp>LangRef =xlfctCLEAN@xlmain8.hlp>LangRef =xlfctCODE>LangRef =xlfctCONCATENATE>LangRef =xlfctDOLLAR@xlmain8.hlp>LangRef =xlfctEXACT@xlmain8.hlp>LangRef =xlfctFIND>LangRef =xlfctFIXED@xlmain8.hlp>LangRef =xlfctLEFT@xlmain8.hlp>LangRef =xlfctLEN@xlmain8.hlp>LangRef =xlfctLOWER@xlmain8.hlp>LangRef =xlfctMID@xlmain8.hlp>LangRef =xlfctPROPER>LangRef =xlfctREPLACE>LangRef =xlfctREPT@xlmain8.hlp>LangRef =xlfctRIGHT>LangRef =xlfctSEARCH>LangRef =xlfctSUBSTITUTE>LangRef T=xlfctT>LangRef =xlfctTEXT>LangRef =xlfctTRIM>LangRef =xlfctUPPER>LangRef =xlfctVALUE>LangRef =xllrgAboutExaminingStructureOfFormulas@xlmain8.hlp>LgCard =xldecLocateCellsThatProvideDataToCellsOrDependOnValuesInOtherCells@xlmain8.hlp>Ref =xlhowRemoveIndividualTracerArrows@xlmain8.hlp>HowTo =xlhowIdentifyWorkWithCellsThatCreateCircularReference@xlmain8.hlp>HowTo =xlhowFindCellsThatDontFitThePatternInARowOrColumn@xlmain8.hlp>HowTo =xlhowShowOrHideCirclesAroundInvalidEntriesInCells>HowTo =xlTBSTroubleshootAuditingAndAddingCommentsToAWorksheet@xlmain8.hlp>Ref =xldecCreateAChart@xlmain8.hlp>Ref =xlhowCreateChartUsingDefaultChartType@xlmain8.hlp>HowTo Microsoft Excel =xllrgHowWorksheetDataIsRepresentedInChart@xlmain8.hlp>LgCard =xltbsTroubleshootingFormattingAChart@xlmain8.hlp>Ref =xldecAddAndDeleteChartData@xlmain8.hlp>Ref =xldccModifyDataRangeOrSeriesDefinition@xlmain8.hlp>HowTo =xlconPreventingChangesToAChart@xlmain8.hlp>Ref =cohowAddUnattachedText@xlmain8.hlp>HowTo =xlhowChangeChartLabelsTitlesOtherText@xlmain8.hlp>Ref =xlhowChangePointsPlottedInPieOfPieOrBarOfPieChart@xlmain8.hlp>HowTo =xldecChangeTheWayYourDataIsPlotted@xlmain8.hlp>Ref =xlhowChangeDataPointValuesInAWorksheetCell@xlmain8.hlp>HowTo =xlhowChangeDataPointValuesUsingGoalSeeking@xlmain8.hlp>HowTo =xlhowDeleteDataSeriesOrPoints@xlmain8.hlp>HowTo =xlhowEditChartAxisTitles@xlmain8.hlp>HowTo =xlhowLinkChartTitlesAndTextBoxesToAWorksheetCell@xlmain8.hlp>HowTo =xlhowRelinkTextInAChart@xlmain8.hlp>HowTo =xlhowCreateAChartFromVisibleWorksheetData@xlmain8.hlp>HowTo =xlconTipsForUsingTimescaleAxes@xlmain8.hlp>Ref =xlhowChangeEmbeddedChartToChartSheetViceVersa@xlmain8.hlp>HowTo =xldecChangeDisplayOptionsInChart@xlmain8.hlp>Ref =cohowDeleteDataLabelsTitlesLegendsOrGridlines@xlmain8.hlp>HowTo =xlhowControlDisplayOfChartTips@xlmain8.hlp>HowTo =xlhowSizeAndSetUpAChartSheetForPrinting@xlmain8.hlp>HowTo =xlhowSizeAChartSheetWithTheWindow@xlmain8.hlp>HowTo =xlhowEditEmbeddedChartInItsOwnWindow@xlmain8.hlp>HowTo =xlnschowChangeTheChartType@xlmain8.hlp>HowTo =xlconColumnChartExample@xlmain8.hlp>LgCard =xllrgCombinationChartsSecondaryAxes@xlmain8.hlp>LgCard =xlconExplanationOfCustomChartTypes@xlmain8.hlp>Ref =xlhowAddOrDeleteCustomChartAutoFormats@xlmain8.hlp>HowTo =xlhowShareCustomChartAutoFormatsWithOtherUsers@xlmain8.hlp>HowTo =xlhowDeleteACustomChartAutoFormat@xlmain8.hlp>HowTo =xlhowChangeTheDefaultChartFormat@xlmain8.hlp>Ref =xllrgAboutFormattingItemsInCharts@xlmain8.hlp>LgCard =xlhowWaysToSelectFormatChartItems@xlmain8.hlp>Ref =xldecMoveSelectAndSizeChartsAndChartItems@xlmain8.hlp>HowTo =xlhowApplyColorsPatternsAndBordersToChartItems@xlmain8.hlp>HowTo =xlhowChangeSizeOfLineChartMarkers@xlmain8.hlp>HowTo =cohowFormat3DSurfaceChartLevels@xlmain8.hlp>HowTo =xlhowFormatDataMarkers@xlmain8.hlp>HowTo =xlhowCreateAndFormatPictureMarkers@xlmain8.hlp>HowTo =xlhowClearPictureOrFillEffectFromDataSeries@xlmain8.hlp>HowTo =xlhowClearPictureOrFillEffectFromChartItem@xlmain8.hlp>HowTo =cohowChangeTheFontAndAlignmentOfChartText@xlmain8.hlp>HowTo =xlhowAlignTextInChartTitlesTextBoxes@xlmain8.hlp>HowTo =xlhowRotateAlignTextInChart@xlmain8.hlp>HowTo =xlhowRepositionDataLabelsAutomatically@xlmain8.hlp>HowTo =xlhowChangeNumberFormatsForChartValues@xlmain8.hlp>HowTo =grhowReestablishLinksBetweenNumberFormatsInDatasheetChart@xlmain8.hlp>HowTo =xlhowArrangeAndSpaceDataMarkersInBarAndColumnCharts@xlmain8.hlp>HowTo =xlhowUseSpecialLinesAndBarsToEmphasizeData@xlmain8.hlp>HowTo =xlhowChangeTheScaleOfAxes@xlmain8.hlp>HowTo =xlhowChangeTheCategoryOrSeriesAxisScale@xlmain8.hlp>HowTo =xldecModifyChartAxes@xlmain8.hlp>HowTo =xlhowFormatPieAndDoughnutSlices@xlmain8.hlp>HowTo =xlhowChangeTheAngleOfTheFirstDoughnutOrPieSlice@xlmain8.hlp>HowTo =xlhowChangeSizeOfPieOfPieOrBarOfPiePlotArea@xlmain8.hlp>HowTo =xlhowChangeTheDoughnutHoleSize@xlmain8.hlp>HowTo =xlhowSmoothTheAnglesOfLineCharts@xlmain8.hlp>HowTo =codecFormat3DCharts@xlmain8.hlp>Ref =xldecAddModifyAndDeleteTrendlinesInAChart@xlmain8.hlp>Ref =xlhowAddATrendlineToADataSeries@xlmain8.hlp>HowTo =xlhowModifyTrendlineSettings@xlmain8.hlp>HowTo =xlhowDeleteATrendline@xlmain8.hlp>HowTo =xlrefEquationsForCalculatingTrendlines@xlmain8.hlp>Ref =xlconErrorBarsInCharts@xlmain8.hlp>Ref =xlhowAddErrorBarsToADataSeries@xlmain8.hlp>HowTo =xlhowModifyErrorBarSettings@xlmain8.hlp>HowTo =xlhowDeleteErrorBars@xlmain8.hlp>HowTo =xlrefEquationsForCalculatingTheErrorAmount@xlmain8.hlp>Ref =xllrgAboutDisplayingDataInMap@xlmain8.hlp>LgCard =xlconGuidelinesForSettingUpDataToCreateMap@xlmain8.hlp>Ref =corefMicrosoftQueryandDataMap@xlmain8.hlp>HowTo =xlhowAddDataToMap@xlmain8.hlp>HowTo =xlhowGetMoreHelpOnMaps@xlmain8.hlp>HowTo =xllrgAboutGraphics@xlmain8.hlp>LgCard =xldecCreatePicturesOfCellsAndObjects =xltbcShowOrHideDrawingToolbar@xlmain8.hlp>HowTo =esdccAddAutoShape@xlmain8.hlp>HowTo =esdccChangeOneAutoShapeToAnother@xlmain8.hlp>HowTo =ppconCustomShapes@xlmain8.hlp>Ref =pphowAddCurve@xlmain8.hlp>HowTo =pphowAddFreeformObject@xlmain8.hlp>HowTo =pphowAddLine@xlmain8.hlp>HowTo =pphowAddOrRemoveArrowheads@xlmain8.hlp>HowTo =ppdecAddOrReshapeConnectorLine@xlmain8.hlp>Ref =xlhowDisplayOrHideDrawingObjects@xlmain8.hlp>HowTo =pphowSaveAnObjectsStyleAsTheDefault@xlmain8.hlp>HowTo =pptbsTroubleshootObjectDrawingAndHandling@xlmain8.hlp>Ref WordArt =xlrefICantFindTheFormatObjectCommand@xlmain8.hlp>Ref =pphowAddOrChangeAFill@xlmain8.hlp>Ref =ppconRotatingAndFlippingObjects@xlmain8.hlp>Ref =ppdecChangeTheColorOfALineArcOrBorder@xlmain8.hlp>HowTo =pphowChangeTheShapeOfACustomShape@xlmain8.hlp>HowTo =pphowChangeThicknessOfLineOrBorder@xlmain8.hlp>HowTo =pphowMakeDashedLineOrBorder@xlmain8.hlp>HowTo =pphowRemoveABorderOrLine@xlmain8.hlp>HowTo =ppdecResizeObjects@xlmain8.hlp>Ref =pphowAddChangeOrRemoveAnObjectShadow@xlmain8.hlp>Ref =esdecAdd3DEffectToObject@xlmain8.hlp>Ref =pptbsTroubleshootAddingBordersFillsAndShadows@xlmain8.hlp>Ref =ppdecAddTextToASlide@xlmain8.hlp>Ref =pphowChangeOneOrMoreAttributesOfTextAtTheSameTime@xlmain8.hlp>HowTo =pptbsICantMoveATextObject@xlmain8.hlp>HowTo =ppdecPositionAlignSpaceTextWithinObjects@xlmain8.hlp>Ref =pphowInsertWordArt@xlmain8.hlp>Ref WordArt?=ppconWhatHappenedToWordArt@xlmain8.hlp>Ref =ppconGroupingObjects =ppconStackingObjects@xlmain8.hlp>HowTo =ppdecAlignObjects@xlmain8.hlp>Ref =pphowMoveAnObjectOrSetOfObjects@xlmain8.hlp>HowTo =pphowNudgeAnObjectInSmallIncrements@xlmain8.hlp>HowTo =xlhowMoveSizeObjectsWithCells@xlmain8.hlp>HowTo =pptbsTroubleshootAligningArrangingObjects@xlmain8.hlp>Ref =ppconInsertingPicturesOnSlides@xlmain8.hlp>Ref =pphowInsertPicturesIntoAPresentation@xlmain8.hlp>Ref =xlhowUngroupClipArtToModifyIt@xlmain8.hlp>HowTo Microsoft Excel=worefListFilesOfTypeInsertmenuPicture@xlmain8.hlp>Ref =ppconSolvingGraphicsFilterProblems@xlmain8.hlp>Ref Microsoft Camcorder Microsoft Camcorder=ofconMicrosoftGDICap@xlmain8.hlp>Ref =xlconUsingAListAsADatabase@xlmain8.hlp>Ref =xlconGuidelinesForCreatingAListOnAWorksheet@xlmain8.hlp>Ref =xlrefDefaultSortOrders@xlmain8.hlp>Ref =xldecSortAList@xlmain8.hlp>Ref =xltbsTroubleshootSorting@xlmain8.hlp>Ref =xllrgWaysToFindValuesInList@xlmain8.hlp>LgCard =xlhowFilteringAList@xlmain8.hlp>HowTo =xlhowCreatingACustomFilter@xlmain8.hlp>Ref =xldecRemoveAFilterFromAList@xlmain8.hlp>HowTo =xlrefAutoFilterOptions@xlmain8.hlp>Ref =xlhowFilterAListUsingComplexCriteria@xlmain8.hlp>HowTo =xlrefExamplesOfCriteriaForAdvancedFilter@xlmain8.hlp>Ref =xlrefTypesOfComparisonCriteria@xlmain8.hlp>Ref =xlhowFindValueInListUsingLookupWizard@xlmain8.hlp>HowTo =xldecAddToOrChangeListByUsingDataForm@xlmain8.hlp>Ref =xlhowDeleteRecordInListByUsingDataForm@xlmain8.hlp>HowTo =xldccFindRecordsInListByUsingDataForm@xlmain8.hlp>HowTo Microsoft Query=xllrgExampleOfConstructingQuery@xlmain8.hlp>LgCard =xlrefDatabasesYouCanAccessWithMicrosoftQuery@xlmain8.hlp>Ref =xlhowTroubleshootRetrievingExternalData@xlmain8.hlp>Ref Microsoft Query =xlconWhatYouNeedToConnectToExternalDataSourceUseMicrosoftQuery@xlmain8.hlp>Ref Microsoft Query=xlhowSetUpMicrosoftQuery@xlmain8.hlp>HowTo ODBC=xlhowInstallSupportForExternalDataSource@xlmain8.hlp>HowTo =xlhowSpecifySourceToRetrieveDataFrom@xlmain8.hlp>HowTo =qutbcICantSeemToCreateNewDataSource =xldecWaysToRetrieveExternalDataSoThatYouCanAnalyzeItInExcel@xlmain8.hlp>Ref =xlhowRunExistingQuery@xlmain8.hlp>HowTo =xlconConstructingQuerySoThatItReturnsDataYouWant@xlmain8.hlp>Ref =xlhowGetExternalDataUsingQueryWizard@xlmain8.hlp>HowTo Microsoft Query=xlconGetExternalDataIntoMicrosoftExcelWorksheet@xlmain8.hlp>Ref Web=xlhowGetDataFromInternetSource HTML Web=xlhowReturnDataStoredInHTMLTable@xlmain8.hlp>HowTo =quconDistributingReportsThatContainDataFromExternalDatabase@xlmain8.hlp>Ref =quhowWaysToDesignQueryThatPromptsForInformationWhenRun@xlmain8.hlp>Ref =xlhowSelectWhereToPutExternalDataRange@xlmain8.hlp>HowTo =xlhowUpdateExternalData@xlmain8.hlp>HowTo =xldecControlFormattingLayoutOfExternalData@xlmain8.hlp>Ref =xldecControlHowMicrosoftExcelRefreshesExternalData@xlmain8.hlp>Ref =xlhowRequirePasswordToRefreshExternalDataRange@xlmain8.hlp>HowTo =xlhowFindExternalDataRangeOnYourWorksheet@xlmain8.hlp>HowTo =xlrefUseQueryWizardToChangeUnderlyingQuery@xlmain8.hlp>HowTo =xlhowNameExternalDataRange@xlmain8.hlp>HowTo =xlhowCopyExternalDataItsQueryToAnotherWorkbook@xlmain8.hlp>HowTo =xlhowRemoveExternalDataRangeFromWorksheet@xlmain8.hlp>HowTo Visual Basic =xlhowHowMacrosCanAccessListsExternalDatabases@xlmain8.hlp>Ref DAO Visual Basic=xlhowInstallDataAccessObjectsForVisualBasic@xlmain8.hlp>HowTo (DDE) Microsoft Query=xlconUsingDynamicDataExchangeWithMicrosoftQuery@xlmain8.hlp>Ref =xldecSummarizeData@xlmain8.hlp>Ref =xldecSummarizeValuesInListOrDatabase@xlmain8.hlp>Ref =xllrgxsummarzSubtotalsHowMicrosoftExcelSummarizesData@xlmain8.hlp>LgCard =xldecSubtotalValuesInList@xlmain8.hlp>Ref =xlhowRemoveSubtotalsFromList@xlmain8.hlp>HowTo =xlconHowSubtotalAndGrandTotalValuesAreCalculated@xlmain8.hlp>Ref =xldecSummarizedatabyoutliningaworksheet@xlmain8.hlp>Ref =xlhowShoworhidedetaildatainanoutline@xlmain8.hlp>Ref =xlhowDisplayorhideoutlinesymbols@xlmain8.hlp>HowTo =xlhowUngrouprowsorcolumns@xlmain8.hlp>HowTo =xlhowRemoveanoutline@xlmain8.hlp>HowTo =xlhowTroubleshootoutliningaworksheet@xlmain8.hlp>Ref =xllrgConsolidateDataByUsing3DReferences@xlmain8.hlp>LgCard =xlhowConsolidateData@xlmain8.hlp>Ref =xlconChoosingTheSourceAreaForMyConsolidationTable@xlmain8.hlp>Ref =xldecChangeADataConsolidationTable@xlmain8.hlp>Ref =xlhowTroubleshootDataConsolidation@xlmain8.hlp>Ref =xllrgPivotTablesanalyzingDataInteractively>LgCard =xlnschowPivotTableCommandDataMenu>HowTo Microsoft Access Microsoft Access Microsoft Excel=xlhowCreatingAReportWithAccessReportWizardInMicrosoftExcel>HowTo Microsoft Access Microsoft Excel=xlhowModifyingAnExistingReport>HowTo =xllrgPivotTablesanalyzingDataInteractively@xlmain8.hlp>LgCard =xllrgPartsOfPivotTable@xlmain8.hlp>LgCard =xlconExamplesOfHowToSelectDataInPivotTables@xlmain8.hlp>Ref =xlcmdTroubleshootingCustomizeAPivotTable@xlmain8.hlp>Ref =xltbsTroubleshootPivotTableFormatting@xlmain8.hlp>Ref =xlnschowPivotTableCommandDataMenu@xlmain8.hlp>HowTo =xldecChoosePivotTableDataSource@xlmain8.hlp>Ref Microsoft Excel=xlhowCreateAPivotTableFromAMicrosoftExcelListOrDatabase@xlmain8.hlp>Ref =xlhowCreateAPivotTableFromAnotherPivotTable@xlmain8.hlp>Ref =xlhowCreateAPivotTableByCombiningDataFromMultipleConsolidationRanges@xlmain8.hlp>Ref =xlhowCreateAPivotTableFromAnExternalDataSource =xlhowDeleteAPivotTable@xlmain8.hlp>HowTo Microsoft Excel 4.0 =xlhowConvertAMicrosoftExcelVersion40CrosstabTableToAPivotTable@xlmain8.hlp>HowTo =xltbsChangeTheLayoutOfAPivotTable@xlmain8.hlp>Ref =xlhowAddAFieldToAPivotTable@xlmain8.hlp>HowTo =xlhowFormatPivotTable@xlmain8.hlp>HowTo =xldecUsePageFieldsInAPivotTable@xlmain8.hlp>Ref =xldecGroupItemsInAPivotTable@xlmain8.hlp>Ref =xldecShowOrHidePivotTableDetail@xlmain8.hlp>Ref =xllrgPreventAccessToPivotTableDetail@xlmain8.hlp>HowTo =xldecSortItemsInAPivotTable@xlmain8.hlp>Ref =xlhowChangeTheNumberFormatForTheDataAreaOfAPivotTable@xlmain8.hlp>HowTo =xlhowChangeHowErrorsEmptyCellsZeroValuesAreShownInPivotTable@xlmain8.hlp>HowTo =xlhowChangeTheNameOfAPivotTableField@xlmain8.hlp>HowTo =xldecUseTotalsSubtotalsInPivotTable@xlmain8.hlp>Ref =xldecUseSummaryFunctionsInAPivotTable@xlmain8.hlp>Ref =xlrefPivotTableFieldCommandForDataFieldsDataMenu@xlmain8.hlp>Ref =xlcmdUsingCustomCalculationsInAPivotTable@xlmain8.hlp>Ref =xlhowCreateCalculatedPivotTableFieldOrItem@xlmain8.hlp>HowTo =xlhowCreateCalculatedPivotTableItem@xlmain8.hlp>HowTo =xlrefCalculatedFieldItemSyntax@xlmain8.hlp>Ref =xlhowEditFormulaForCalculatedPivotTableFieldOrItem@xlmain8.hlp>HowTo =xltbcChangeFormulaForCalculatedPivotTableItem@xlmain8.hlp>HowTo =xlhowDeleteCalculatedPivotTableField@xlmain8.hlp>HowTo =xlhowDeleteCalculatedPivotTableItem@xlmain8.hlp>HowTo =xlhowChangeOrderOfCalculationForCalculatedPivotTableFieldsItems@xlmain8.hlp>HowTo =xlhowDisplayListOfFormulasInPivotTable@xlmain8.hlp>HowTo =xldecChangeHowPivotTableDataIsCalculated@xlmain8.hlp>Ref =xlhowUsePivotTableDataInFormulaOutsidePivotTable@xlmain8.hlp>HowTo =xldecCreateChartFromPivotTable@xlmain8.hlp>Ref =xlhowCreateAPivotTableFromAnExternalDataSource@xlmain8.hlp>Ref =xldecChangeSourceDataForPivotTableOrHowItIsRefreshed@xlmain8.hlp>Ref =xlhowRunQueryForPivotTableImmediatelyOrInBackground@xlmain8.hlp>HowTo =xlhowMakePivotTablePageFieldServerbasedOrLocal>HowTo =xlhowPreventRefreshOfPivotTable@xlmain8.hlp>HowTo =xllrgXWhatIfDataTables@xlmain8.hlp>LgCard =xltbsTroubleshootWhatIfProblems@xlmain8.hlp>Ref =xldecProjectFutureValuesPerformRegressionAnalysis@xlmain8.hlp>Ref =xlhowCreateOnevariableDataTable@xlmain8.hlp>HowTo =xlhowAddaformulatoanexistingdatatable@xlmain8.hlp>HowTo =xlhowConvertresultingdatatablevaluestoconstantvalues@xlmain8.hlp>HowTo =xlhowFillinaTwoVariableDataTable@xlmain8.hlp>HowTo =xlhowClearresultingvaluesfromadatatable@xlmain8.hlp>HowTo =xlhowClearanentiredatatable@xlmain8.hlp>HowTo =xlhowSeekaspecificsolutiontoaformula@xlmain8.hlp>HowTo =xlhowCreateascenario@xlmain8.hlp>HowTo =xlhowDisplayascenario@xlmain8.hlp>HowTo =xlhowEditascenario@xlmain8.hlp>HowTo =xlhowMergescenarios@xlmain8.hlp>HowTo =xlhowCreateascenariosummaryreport@xlmain8.hlp>HowTo =xlhowProtectascenariofromunwantedchanges@xlmain8.hlp>HowTo =xlhowDeleteascenario@xlmain8.hlp>HowTo =xlhowDefineandsolveaproblemusingSolver@xlmain8.hlp>HowTo =xlconGuidelinesForDesigningModelToFindValuesWithSolver@xlmain8.hlp>Ref =xlhowInstallSolver@xlmain8.hlp>HowTo =xlconSolverSampleWorksheets@xlmain8.hlp>Ref =xlhowLoadaproblemmodelusingSolver@xlmain8.hlp>HowTo =xldecSetSolverOptions@xlmain8.hlp>Ref =xlconSolvingforaValuetoMaximizeAnotherValue@xlmain8.hlp>Ref =xlhowStepthroughSolvertrialsolutions@xlmain8.hlp>HowTo =xlhowCreateareportusingSolver@xlmain8.hlp>HowTo =xlhowSavechangingcellvaluesinSolverasascenario@xlmain8.hlp>HowTo =xlhowSaveaproblemmodelusingSolver@xlmain8.hlp>HowTo =xlrefSolverCompletionMessages@xlmain8.hlp>Ref =xlrefAlgorithmusedbySolver@xlmain8.hlp>Ref =xltbsTroubleshootproblemsusingSolver@xlmain8.hlp>Ref =xlconAnalyzingstatistics@xlmain8.hlp>Ref =xlhowUsetheAnalysisToolPak@xlmain8.hlp>HowTo =xlrefAboutStatisticalMethodsAlgorithms@xlmain8.hlp>Ref =xldecPerformAnalysisOfVarianceanova@xlmain8.hlp>Ref =xlrefCorrelationanalysistool@xlmain8.hlp>Ref =xlrefCovarianceanalysistool@xlmain8.hlp>Ref =xlrefDescriptiveStatisticsanalysistool@xlmain8.hlp>Ref =xlrefExponentialSmoothinganalysistool@xlmain8.hlp>Ref =xlrefFTestTwoSampleForVariancesanalysistool@xlmain8.hlp>Ref =xldecPerformTTestAnalysis =xlrefzTestTwoSampleForMeansanalysistool@xlmain8.hlp>Ref =xlrefHistogramanalysistool@xlmain8.hlp>Ref =xlrefMovingAverageanalysistool@xlmain8.hlp>Ref =xlrefRandomNumberGenerationanalysistool@xlmain8.hlp>Ref =xlrefRankAndPercentileanalysistool@xlmain8.hlp>Ref =xlrefRegressionanalysistool@xlmain8.hlp>Ref =xlrefFourierAnalysisanalysistool@xlmain8.hlp>Ref =xlrefSamplinganalysistool@xlmain8.hlp>Ref =xltbsDataappearsonthefirstworksheetonly =xldecWorkOnShareReviseWorkbooks@xlmain8.hlp>Ref =xllrgAboutSharingWorkbookWithOtherPeople@xlmain8.hlp>LgCard =xlhowWhatYouNeedToKnowBeforeYouWorkWithSharedWorkbook@xlmain8.hlp>Ref =xlhowCreateASharedList@xlmain8.hlp>HowTo =xldecManageConflictingChangesToSharedWorkbook@xlmain8.hlp>Ref =xlhowDetermineHowOftenToGetUpdatesToSharedWorkbook@xlmain8.hlp>HowTo =xlhowKeepPersonalViewPrintSettingsForSharedWorkbook@xlmain8.hlp>HowTo =xlrefListOfFeaturesUnavailableInSharedWorkbooksOrWhenChangeTrackingIsTurnedOn@xlmain8.hlp>Ref =xlhowLimitAccessToSharedWorkbook>HowTo =xlhowReturnProtectedSharedWorkbookToFullAccess@xlmain8.hlp>HowTo =xlhowDisconnectUserFromSharedWorkbook@xlmain8.hlp>HowTo =xlhowEditSharedWorkbookExclusively@xlmain8.hlp>HowTo =xlhowPrepareCopiesOfWorkbookForReviewMerging@xlmain8.hlp>HowTo =xlhowMergeCommentsFromSeveralCopiesOfWorkbook>HowTo =xllrgAboutWorkingWithCommentsRevisions>LgCard =xlhowKeepTrackOfChangesToWorkbook @xlmain8.hlp>HowTo =xlhowTurnChangeTrackingOff@xlmain8.hlp>HowTo =xldecViewChangesToWorkbook@xlmain8.hlp>Ref =xlhowViewCompleteChangeHistoryOfWorkbook@xlmain8.hlp>HowTo =xlhowMarkWorkbookRevisions@xlmain8.hlp>HowTo =xlhowReviewIncorporateRevisions@xlmain8.hlp>HowTo =xlhowAllowOnlyMarkedRevisionsToWorkbook@xlmain8.hlp>HowTo Microsoft Excel=xlhowTypesOfRevisionsThatMicrosoftExcelMarksIgnores@xlmain8.hlp>Ref =xlhowShowOrHideRevisionHighlightingDetailsAboutChanges@xlmain8.hlp>HowTo =xltbsTroubleshootSharedWorkbooks@xlmain8.hlp>Ref =xltbcTroubleshootMergingWorkbooks@xlmain8.hlp>Ref =xltbsTroubleshootRevisionHighlighting@xlmain8.hlp>Ref =xltbsTroubleshootRevisionHistoryTracking@xlmain8.hlp>Ref =xllrgAboutWorkingWithCommentsRevisions@xlmain8.hlp>LgCard =xlhowAddATextNoteToACell@xlmain8.hlp>HowTo =xlhowChangeAppearanceOrPositionOfComment@xlmain8.hlp>HowTo =xlhowEditComment@xlmain8.hlp>HowTo =xlhowCopythecellformula@xlmain8.hlp>HowTo =xlhowClearrowsandcolumns@xlmain8.hlp>HowTo =xlhowDisplayOrHideCellNoteIndicators@xlmain8.hlp>HowTo =xlhowMergeCommentsFromSeveralCopiesOfWorkbook@xlmain8.hlp>HowTo =xlhowReviewCommentsInWorkbook@xlmain8.hlp>HowTo =xldccPrintComments@xlmain8.hlp>HowTo =xltbsCommentsInPivotTableDontStayInRightCells Microsoft Excel=xlrefSecurityFeaturesInMicrosoftExcel@xlmain8.hlp>Ref =xldecControlChangesToAWorkbook@xlmain8.hlp>Ref =xlhowLimitAccessToSharedWorkbook@xlmain8.hlp>HowTo =xlidxReturnProtectedWorkbooksOrWorksheetsToUnrestrictedUse@xlmain8.hlp>Ref =xlhowChangeOrDeleteAPassword@xlmain8.hlp>HowTo =xltbsTroubleshootSecurityProtection@xlmain8.hlp>Ref =xlmscAboutVirusesWorkbookMacros@xlmain8.hlp>Ref =xlhowCheckWorkbooksForMacrosThatMightContainViruses@xlmain8.hlp>HowTo =xlhowTurnOffCheckingOfWorkbooksForMacrosThatMightContainViruses@xlmain8.hlp>HowTo =xllrgDataValidationHelpingPeopleEnterCorrectData@xlmain8.hlp>LgCard =xldecRestrictWhatDataIsValidForCell@xlmain8.hlp>Ref =xlrefDataValidationTypes@xlmain8.hlp>Ref =xldecDisplayMessagesPromptingForInputOrExplainingInvalidInput@xlmain8.hlp>Ref =xlhowChangeWhatDataIsValidOrMessagesAreDisplayedForCell@xlmain8.hlp>HowTo =xlhowCopyDataValidationRestrictionsMessages@xlmain8.hlp>HowTo =xlhowRemoveDataValidationRestrictionsMessagesFromCell@xlmain8.hlp>HowTo =xlhowPreventChangesToDataValidationRestrictionsMessages@xlmain8.hlp>HowTo =xlhowFindCellsThatHaveDataValidationRestrictionsOrMessages>HowTo =xlhowTypesOfDataValidationMessages@xlmain8.hlp>HowTo =xltbsTroubleshootDataRestrictionsMessages@xlmain8.hlp>Ref =xlhowShowOrHideCirclesAroundInvalidEntriesInCells>HowTo =xldecHideCirclesAroundIncorrectEntriesInCells@xlmain8.hlp>HowTo =xlhowFindCellsThatHaveDataValidationRestrictionsOrMessages@xlmain8.hlp>HowTo Excel=ofhowShareFolderWithAnotherPerson@xlmain8.hlp>HowTo =codecSendDocumentsToReviewInElectronicMail@xlmain8.hlp>Ref =cohowCreateARoutingSlip@xlmain8.hlp>HowTo =cohowEditTheRoutingSlipOfARoutedDocument@xlmain8.hlp>HowTo =wotbsTroubleshootProblemsSendingDocumentsToOthersInElectronicMail@xlmain8.hlp>Ref Microsoft Excel Lotus Notes Lotus Notes=wodecEmbedAWordDocumentInALotusNotesForm@xlmain8.hlp>Ref Lotus Notes=wohowUpdateLotusNotesFields@xlmain8.hlp>Ref Lotus Notes=xlhowImportWorksheetDataIntoARichTextFieldInALotusNotesForm@xlmain8.hlp>HowTo Lotus Notes=xlhowCreateAFieldInMicrosoftExcelToUseInLotusNotes@xlmain8.hlp>HowTo Lotus NotesFlow Action=ofhowLotusNotesFlowMicrosoftprogram@xlmain8.hlp>Ref Microsoft Excel Lotus Notes=pprefUsingNotesFXWithMicrosoftPowerPoint@xlmain8.hlp>Ref Office Binder Office Binder=ofconOfficeBinder@xlmain8.hlp>Ref Microsoft Excel Microsoft Excel =xllrgWaysToLinkToOtherWorkbooksWorksheets@xlmain8.hlp>LgCard =xldecCreateLinksToConnectToDataFiles =xldecCreateHyperlinkToAnotherDocument@xlmain8.hlp>Ref =xldccUseHyperlinkToOpenAnotherDocument@xlmain8.hlp>HowTo =xltbsTroubleshootHyperlinks@xlmain8.hlp>Ref =xlhowChangeDestinationOfHyperlink@xlmain8.hlp>HowTo =ofhowSetHyperlinkBase@xlmain8.hlp>HowTo =xlhowChangeTextOrGraphicForHyperlink@xlmain8.hlp>HowTo =xlhowChangeAppearanceOfHyperlinkText@xlmain8.hlp>HowTo =xlhowCopyOrMoveHyperlink@xlmain8.hlp>HowTo =xlhowDeleteHyperlink@xlmain8.hlp>HowTo =ofdecOpenDocument@xlmain8.hlp>Ref FTP =ofhowAddFTPSiteToListOfInternetSites@xlmain8.hlp>HowTo FTP=ofhowSaveDocumentToInternet@xlmain8.hlp>HowTo FTP=ofhowChangeLoginOrPasswordForInternetSite@xlmain8.hlp>Howto FTP =ofhowDeleteFTPSiteFromListOfInternetSites@xlmain8.hlp>HowTo =xlhowCreateLinkToInternetOrWebData@xlmain8.hlp>HowTo =xlhowUpdateLinkToInternetOrWebData@xlmain8.hlp>HowTo Web=xlhowGetDataFromInternetSource@xlmain8.hlp>HowTo Web=ofhowOpenWorldWideWebStartPage@xlmain8.hlp>HowTo Web=ofhowOpenSearchPage@xlmain8.hlp>HowTo Web=ofhowOpenPreviousOrNextDocumentInHistoryList@xlmain8.hlp>HowTo Web=ofhowHideAllToolbarsExceptWebToolbar@xlmain8.hlp>HowTo Web=ofhowRefreshCurrentPage@xlmain8.hlp>HowTo Web =ofhowAddCurrentDocumentToFavorites@xlmain8.hlp>HowTo Web=ofhowSetStartPage@xlmain8.hlp>HowTo Web=ofhowAddSearchPage@xlmain8.hlp>HowTo Web=ofconOpenOfficeSearchPageInInternetBrowser@xlmain8.hlp>Ref Microsoft Excel Web=xlhowPublishMicrosoftExcelDataOnWeb@xlmain8.hlp>Ref =xldecCreateLinksToConnectToDataFiles@xlmain8.hlp>Ref =xlconAboutLinkingEmbedding@xlmain8.hlp>Ref =coconDraggingAndDroppingBetweenApplications@xlmain8.hlp>HowTo =ofhowOtherWaysToPasteInformation =xlconUsingDataFromOtherApplicationsInCalculations@xlmain8.hlp>Ref =xldecCreatePicturesOfCellsAndObjects@xlmain8.hlp>Ref =xltbsTroubleshootingSharingDataandGraphicswithOtherApplications@xlmain8.hlp>Ref Office Microsoft Office=ofhowMicrosoftOfficeShortcutBar@xlmain8.hlp>Ref Office=ofhowManageTimeContactsTasksEmailFromOfficeShortcutBar Microsoft Excel, Word PowerPoint Office=ofdecShareInformationBetweenOfficeApplications@xlmain8.hlp>Ref Microsoft Excel Office=ofrefWaysToShareInformationInMicrosoftOfficeProgram@xlmain8.hlp>Ref Microsoft Excel Word PowerPoint=xldecCopyMicrosoftExcelDataToWordOrPowerPoint@xlmain8.hlp>Ref Word PowerPoint=xldccCopyResultOfFormulaIntoWordDocumentOrPowerPointPresentation@xlmain8.hlp>HowTo Excel Word PowerPoint=xldccCopyWorksheetCellsIntoWordDocumentOrPowerPointPresentation@xlmain8.hlp>HowTo Microsoft Excel Word=xlhowUseMicrosoftExcelDataAsMailMergeDataSourceInWord@xlmain8.hlp>HowTo Microsoft Excel Word PowerPoint=xldccCopyChartIntoWordDocumentOrPowerPointPresentation@xlmain8.hlp>HowTo Word Microsoft Excel=xlhowCopyWordTableIntoMicrosoftExcelWorksheet@xlmain8.hlp>HowTo Microsoft Excel Microsoft Outlook Office=ofhowManageTimeContactsTasksEmailFromOfficeShortcutBar@xlmain8.hlp>Ref Microsoft Excel Outlook=xlhowAddNamesAddressFromMicrosoftExcelWorkbookToOutlookContactList@xlmain8.hlp>HowTo Outlook Microsoft Excel=xlhowAddNamesAddressesFromOutlookContactListToMicrosoftExcelWorkbook@xlmain8.hlp>HowTo Microsoft Outlook=ofrefHowMicrosoftOutlookIntegratesWithMicrosoftOffice@xlmain8.hlp>Ref Microsoft Excel Microsoft Access Microsoft Excel Microsoft Access=codecShareInformationbetweenMicrosoftExcelandMicrosoftAccess Microsoft Excel Microsoft Access=ofhowImportDataFromMicrosoftAccessIntoMicrosoftExcel@xlmain8.hlp>HowTo Microsoft Access Microsoft Excel=ofhowCopyMicrosoftAccessRecordsToAnExistingMicrosoftExcelWorksheet@xlmain8.hlp>HowTo Microsoft Excel Microsoft Access=ofhowImportDataFromMicrosoftExcelIntoMicrosoftAccess@xlmain8.hlp>HowTo Microsoft Excel Microsoft Access=xlhowCreatingANewAccessFormWizardFormInMicrosoftExcel@xlmain8.hlp>HowTo Microsoft Access Microsoft Excel=xlhowUseAnExistingFormForDataEntry@xlmain8.hlp>HowTo Microsoft Access Microsoft Excel=xlhowCreatingAReportWithAccessReportWizardInMicrosoftExcel@xlmain8.hlp>HowTo Microsoft Access Microsoft Excel=xlhowModifyingAnExistingReport@xlmain8.hlp>HowTo Microsoft Excel Microsoft Access=xlcmdConvertingYourExcelDataToAccess@xlmain8.hlp>HowTo MS Access.=xltbsTheViewAccessFormOrViewAccessReportButtonOnWorksheetDoesntWork@xlmain8.hlp>Ref =ofhowOtherWaysToPasteInformation@xlmain8.hlp>Ref =cohowEditAnEmbeddedObject@xlmain8.hlp>Ref Microsoft Excel=xldecControlTheUpdatingOfLinksInExcel@xlmain8.hlp>Ref =ofhowReconnectLinkWhenSourceFileMovesOrIsRenamed@xlmain8.hlp>HowTo Excel=xlhowUpdateALinkedPicture@xlmain8.hlp>HowTo =ofdecChangeWayLinkOrEmbeddedObjectIsDisplayed@xlmain8.hlp>Ref Microsoft Excel=xldecImportTextDataIntoMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel=xlmscFileFormatsSuppliedWithMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel 97 Microsoft Excel =xlconUsingFilesCreatedWithPreviousVersionsOfMicrosoftExcel =xldecFormattingFeaturesNotTransferredInFileConversions@xlmain8.hlp>Ref Windows Macintosh=cohowMoveFilesBetweenWindowsAndTheMacintosh@xlmain8.hlp>HowTo =xldecTroubleshootConvertingFileFormats@xlmain8.hlp>Ref =xldecAutomateTasksYouDoRepeatedly@xlmain8.hlp>Ref =xlhowRecordamacro@xlmain8.hlp>HowTo =xlhowRunOrStopMacro@xlmain8.hlp>Ref =xldecAssignAmacro@xlmain8.hlp>Ref =xlhowStopMacroWhileItIsRunning@xlmain8.hlp>HowTo =xldccViewEditMacroCode@xlmain8.hlp>HowTo =xlhowCopyamacro@xlmain8.hlp>Ref Microsoft Excel Microsoft Excel=xltbsTroubleshootCustomizingMicrosoftExcel@xlmain8.hlp>Ref =ofhowShowOrHideCommandBar>HowTo =ofhowItemsYouCanDragOntoCommandBar>HowTo =xlhowMoveAndResizeToolbars>HowTo =cohowResizeAToolbar>HowTo =cohowDisplayOrHideRecentlyUsedDocumentsOnTheFileMenu@xlmain8.hlp>HowTo Windows=ofhowArrangeAllWindowsOnWindowsDesktop@xlmain8.hlp>HowTo =xldecChangeColorsUsedInWorkbook@xlmain8.hlp>Ref =ofhowViewMoreInformationOnScreen@xlmain8.hlp>HowTo Microsoft Excel =woconWordAccessibility@xlmain8.hlp>Ref =oflrgSetWorkingFolderToUseWhenIOpenOrSaveDocuments Microsoft Excel =oftbcTheFolderITypedInStartInBoxInprogramShortcutIsNotActiveWhenIStartprogram =wohowAddLanguageOrKeyboardLayout@xlmain8.hlp>HowTo =wohowAddNewFontToYourComputer@xlmain8.hlp>HowTo =ofhowAllAboutCommandBars@xlmain8.hlp>Ref =ofhowShowOrHideCommandBar@xlmain8.hlp>HowTo =ofhowItemsYouCanDragOntoCommandBar@xlmain8.hlp>HowTo =xlhowMoveAndResizeToolbars@xlmain8.hlp>HowTo =cohowResizeAToolbar@xlmain8.hlp>HowTo =xlhowSaveMoreThanOneToolbarConfiguration@xlmain8.hlp>HowTo =xlhowAttachCustomToolbarToWorkbook@xlmain8.hlp>HowTo =ofhowCreateCustomCommandBar@xlmain8.hlp>HowTo =cohowAddOrDeleteAToolbarButton@xlmain8.hlp>HowTo =ofdccAddOrDeleteMenu@xlmain8.hlp>HowTo =ofdccCreateCustomMenu@xlmain8.hlp>HowTo =ofhowAddCommandToMenu@xlmain8.hlp>HowTo =xlhowAssignamacrotoatoolbarbutton@xlmain8.hlp>HowTo =ofhowDeleteCommandBarButton@xlmain8.hlp>HowTo =cohowDeleteACustomToolbar>HowTo =cohowDeleteACustomToolbar@xlmain8.hlp>HowTo =ofhowDeleteCommandBarMenu@xlmain8.hlp>HowTo =ofdccChangeCommandBarSounds =ofhowMakeCommandBarButtonsMenusLarger@xlmain8.hlp>HowTo =cohowChangeTheWidthOfADropdownListBoxOnAToolbar@xlmain8.hlp>HowTo =rehowDisplayIconTextOrTextOnlyOnMenuCommand@xlmain8.hlp>HowTo =ofhowDisplayTextOrIconOnCommandBarButton@xlmain8.hlp>HowTo =cohowSpaceOutButtonsOnAToolbar@xlmain8.hlp>HowTo =ofhowMoveMenu@xlmain8.hlp>Ref =ofhowMoveOrCopyMenuCommand@xlmain8.hlp>HowTo =cohowMoveAndCopyToolbarButtons@xlmain8.hlp>HowTo =ofdccRenameCustomMenu@xlmain8.hlp>HowTo =ofhowRenameCustomCommandBar@xlmain8.hlp>HowTo =rehowRenameMenuCommandOrToolbarButton@xlmain8.hlp>HowTo =cohowRestoreABuiltinToolbar@xlmain8.hlp>HowTo =ofdccRestoreBuiltinMenu@xlmain8.hlp>HowTo =wohowRestoreABuiltinToolbar@xlmain8.hlp>HowTo =ofhowTurnOffCommandBarSounds@xlmain8.hlp>HowTo =ofdccChangeCommandBarSounds@xlmain8.hlp>HowTo Microsoft Excel Microsoft Excel=xldecControlWhatHappensWhenYouStartMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel =ofhowMakeprogramStartEveryTimeIStartWindows@xlmain8.hlp>HowTo =IDH_ofdefAlwaysOpenParticularFilesWithprogram@xlmain8.hlp>HowTo Microsoft Excel =ofhowStartprogramWithoutLoadingAddins@xlmain8.hlp>HowTo Microsoft Excel=xldecUseAddinComponentsOfMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel=xlrefAddinProgramsIncludedWithMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel=xlrefUsingshortcutkeys@xlmain8.hlp>Ref =xlrefFunctionkeys@xlmain8.hlp>Ref Microsoft Excel Lotus 1-2-3=xlrefLotus123KeyboardEquivalents@xlmain8.hlp>Ref =xlrefOutlinedatausingshortcutkeys@xlmain8.hlp>Ref =corefPrintandpreviewadocumentusingshortcutkeys@xlmain8.hlp>Ref =xlrefEditandmovedatausingshortcutkeys@xlmain8.hlp>Ref =xlrefEnterandformatdatausingshortcutkeys@xlmain8.hlp>Ref =xlrefFormatDataByUsingShortcutKeys@xlmain8.hlp>Ref =xlrefMoveDataByUsingShortcutKeys =xlrefSelectDataCellsChartItemsOrObectsByUsingShortcutKeys@xlmain8.hlp>Ref Lotus 1-2-3=xlrefTransitionnavigationkeys@xlmain8.hlp>Ref =xlrefWorkwithdatabaseslistsandPivotTablesusingshortcutkeys@xlmain8.hlp>Ref =ofhowKeysForMovingAroundInMenus@xlmain8.hlp>Ref =ofrefKeysForMovingAroundInCommandBars@xlmain8.hlp>Ref =ofrefKeysForWorkingWithOfficeAssistant@xlmain8.hlp>Ref =corerefWorkinwindowsanddialogboxes@xlmain8.hlp>Ref Microsoft Excel Microsoft Excel=ofxldefTrendlineLabel@xlmain8.hlp>Ref Lotus 1-2-3 Lotus 1-2-3=xldecLotus123Functions Microsoft Excel Lotus 1-2-3=xlconDifferencesBetweenMicrosoftExcelLotus123@xlmain8.hlp>Ref Lotus 1-2-3 Microsoft Excel=xldecDifferencesBetweenLotus123MicrosoftExcelFunctions@xlmain8.hlp>Ref Lotus 1-2-3 Microsoft Excel=xlhowLearnHowToUseMicrosoftExcelByUsingLotus123Help@xlmain8.hlp>HowTo Lotus 1-2-3=xldecEnteringAndCalculatingLotus123Formulas@xlmain8.hlp>Ref Microsoft Excel =xldecGuidelinesForRunningLotus123MacrosInMicrosoftExcel Lotus 1-2-3 Microsoft Excel=xlrefAboutLinkingLotus123MicrosoftExcelWorksheets@xlmain8.hlp>Ref Lotus 1-2-3=xlhowCreateFormulaToCalculateDataOnLotus123Worksheet@xlmain8.hlp>HowTo Quattro Pro Quattro Pro=xldecSwitchFromQuattroPro@xlmain8.hlp>Ref Quattro Pro Microsoft Excel=xlrefOpenQuattroProWorksheetsInMicrosoftExcel@xlmain8.hlp>HowTo Quattro Pro Microsoft Excel=xlhowGuidelinesForOpeningQuattroProFilesInMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel=xldecGuidelinesForRunningLotus123MacrosInMicrosoftExcel@xlmain8.hlp>Ref Microsoft Excel Visual Basic Visual Basic=!IE(FE("vbaxl8.hlp"),`EF("vbaxl8.hlp")',`JI("xlmain8.hlp>Ref","rehowGetOnlineHelpForVisualBasic")') :Include EULA8.CNT