:Base XLMAIN8.HLP>REF
:Title Microsoft Excel
:Index Microsoft Excel Help=XLMAIN8.HLP
:Index Microsoft Excel Upgrade Help=XLNEW8.HLP
:Index Microsoft Excel Quick Tips=XLTIP8.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
1 Key Information
2 If you are upgrading from a previous version of Microsoft Excel
3 What's new in Microsoft Excel 97?=xldecWhatsNewInMicrosoftExcel97@xlnew8.hlp>Ref
3 What's new in Microsoft Excel 97 for developers?=xlrefWhatsNewInMicrosoftExcel97ForDevelopers@xlnew8.hlp>Ref
3 What do I need to know about upgrading and converting files to Microsoft Excel 97?=xlrefWhatDoINeedToKnowAboutUpgradingConvertingFilesToMicrosoftExcel97@xlnew8.hlp>Ref
3 How to get started with Microsoft Excel 97=xlrefHowDoIGetStartedWithMicrosoftExcel@xlnew8.hlp>Ref
3 Components installed with Microsoft Excel=xldecWhatsInstalledWithMicrosoftExcel@xlnew8.hlp>Ref
2 If you are new to spreadsheets
3 How to get started with Microsoft Excel 97=xlrefHowDoIGetStartedWithMicrosoftExcel@xlnew8.hlp>Ref
3 Overview of new features=xldecWhatsNewInMicrosoftExcel97@xlnew8.hlp>Ref
2 If you are switching from another spreadsheet program
3 How to get started with Microsoft Excel 97=xlrefHowDoIGetStartedWithMicrosoftExcel@xlnew8.hlp>Ref
3 If you are switching from Lotus 1-2-3=xldecIfYouAreSwitchingFromLotus123@xlnew8.hlp>Ref
3 If you are switching from Quattro Pro=xldecIfYouAreSwitchingFromQuattroPro@xlnew8.hlp>Ref
1 Getting Help
2 Ways to get assistance while you work=oflrgWaysToGetAssistanceWhileYouWork@xlmain8.hlp>LgCard
2 Change the font size in a Help topic=ofhowChangeFontDisplayedInHelp@xlmain8.hlp>HowTo
2 Print a Help topic=ofhowPrintHelpTopic@xlmain8.hlp>HowTo
3 Connect to Microsoft on the Web from Microsoft Excel=ofrefTheMicrosoftCorporationHomePage@xlmain8.hlp>HowTo
3 Connect to Microsoft technical resources=ofdecConnectToMicrosoft@xlmain8.hlp>Ref
3 Get information about your program and computer=ofhowGetInformationAboutMyComputer@xlmain8.hlp>HowTo
3 Get Visual Basic Help in Microsoft Excel=rehowGetOnlineHelpForVisualBasic@xlmain8.hlp>HowTo
3 How to obtain the Microsoft Office 97 Resource Kit=rerefObtainingTheMicrosoftOffice97ResourceKit@xlmain8.hlp>Ref
3 How to obtain the Microsoft Office 97/ Visual Basic Programmer's Guide=rerefObtainMicrosoftOffice97VisualBasicProgrammersGuide@xlmain8.hlp>Ref
3 I can't use the commands on Microsoft on the Web (Help menu).=retbsICantUseCommandsOnMicrosoftOnTheWebSubmenuHelpMenu@xlmain8.hlp>Ref
3 Send product suggestions=ofdccMSWish@xlmain8.hlp>HowTo
2 Microsoft Excel Readme=!EF("XLREAD8.TXT","",5):Exit()
2 Technical support=!EF("PSS8.HLP","",5):Exit()
2 Using the Office Assistant
3 Get Help, tips, and messages through the Office Assistant=ofdecGetHelpTipsUsingOfficeAssistant@xlmain8.hlp>Ref
3 Hide or show the Office Assistant=IDH_ofdefShowOfficeAssistant@xlmain8.hlp>HowTo
3 Show the Tip of the Day when Microsoft Excel starts=ofhowShowTipOfDayWhenprogramStarts@xlmain8.hlp>HowTo
3 Change the size of the Office Assistant=ofdccChangeSizeOfOfficeAssistant@xlmain8.hlp>HowTo
3 Choose a different Office Assistant=ofhowChangeOfficeAssistant@xlmain8.hlp>HowTo
3 Move the Office Assistant and its balloon=ofhowMoveOfficeAssistant@xlmain8.hlp>HowTo
3 Turn the Office Assistant sound on or off=ofdccTurnOfficeAssistantSoundOnOrOff@xlmain8.hlp>HowTo
3 Get Help without using the Office Assistant=oftbcGetHelpWithoutShowingOfficeAssistant@xlmain8.hlp>HowTo
3 Keys for using the Office Assistant=ofrefKeysForWorkingWithOfficeAssistant@xlmain8.hlp>Ref
3 Troubleshoot the Office Assistant=ofhowTroubleshootOfficeAssistant@xlmain8.hlp>Ref
2 Getting Help on Topics in the Getting Results Book
3 View the online Getting Results book=ofhowViewOnlineGettingResultsBook@xlmain8.hlp>HowTo
3 Microsoft Excel
4 Getting Results - About Creating and Opening Workbooks=xlidxAboutCreatingOpeningWorkbooks@xlmain8.hlp>Ref
4 Getting Results - Analyze Data from an Experiment=xlidxAnalyzeDataFromExperiment@xlmain8.hlp>Ref
4 Getting Results - Answers to Questions About File Compatibility=xlidxAnswersToQuestionsAboutFileCompatibility@xlmain8.hlp>Ref
4 Getting Results - Automate Repetitive Tasks=xlidxAutomateRepetitiveTasks@xlmain8.hlp>Ref
4 Getting Results - Consolidate Budget Input=xlidxConsolidateBudgetInput@xlmain8.hlp>Ref
4 Getting Results - Create a Business Contact List=xlidxCreateBusinessContactList@xlmain8.hlp>Ref
4 Getting Results - Create a Business Report=xlidxCreateBusinessReport@xlmain8.hlp>Ref
4 Getting Results - Create a Chart from Worksheet Data=xlidxCreateChartFromWorksheetData@xlmain8.hlp>Ref
4 Getting Results - Create a Detailed Sales Report=xlidxCreateDetailedSalesReport@xlmain8.hlp>Ref
4 Getting Results - Create a Form for Online Invoices=xlidxCreateFormForOnlineCustomerQuotes@xlmain8.hlp>Ref
4 Getting Results - Create a Mailing=xlidxCreateMailing@xlmain8.hlp>Ref
4 Getting Results - Create a Sales Forecast=xlidxCreateSalesForecast@xlmain8.hlp>Ref
4 Getting Results - Create a Sales Summary=xlidxCreateSalesSummary@xlmain8.hlp>Ref
4 Getting Results - Create Your First Workbook=xlidxCreateYourFirstWorkbook@xlmain8.hlp>Ref
4 Getting Results - Customize Microsoft Excel=xlidxCustomizeMicrosoftExcel@xlmain8.hlp>Ref
4 Getting Results - Customize the Look of a Chart=xlidxCustomizeLookOfChart@xlmain8.hlp>Ref
4 Getting Results - Develop Budgeting Alternatives=xlidxDevelopBudgetingAlternatives@xlmain8.hlp>Ref
4 Getting Results - Display Data in a Map=xlidxDisplayDataOnMap@xlmain8.hlp>Ref
4 Getting Results - Display Scientific Data in a Chart=xlidxDisplayScientificDataInChart@xlmain8.hlp>Ref
4 Getting Results - Distribute Documents Electronically=xlidxDistributeDocumentsElectronically@xlmain8.hlp>Ref
4 Getting Results - Get Assistance While You Work=xlidxGetAssistanceWhileYouWork@xlmain8.hlp>Ref
4 Getting Results - Get Sales Information from a Database=xlidxGetSalesInformationFromDatabase@xlmain8.hlp>Ref
4 Getting Results - Get Your Point Across with Graphics=xlidxGetYourPointAcrossWithGraphics@xlmain8.hlp>Ref
4 Getting Results - Install and Start Microsoft Excel=xlidxInstallStartMicrosoftExcel@xlmain8.hlp>Ref
4 Getting Results - Make Your Worksheet Look Great=xlidxMakeYourWorksheetLookGreat@xlmain8.hlp>Ref
4 Getting Results - Microsoft Excel and the Web=xlidxMicrosoftExcelWeb@xlmain8.hlp>Ref
4 Getting Results - Prepare a Customer Quote=xlidxPrepareCustomerQuote@xlmain8.hlp>Ref
4 Getting Results - Publish Microsoft Excel Tables and Charts on the Web=xlidxCreateWebPageWithMicrosoftExcel@xlmain8.hlp>Ref
4 Getting Results - Share a Workbook with a Co-worker=xlidxShareWorkbookWithCoworker@xlmain8.hlp>Ref
4 Getting Results - Use Microsoft Excel with Other Applications=xlidxUseMicrosoftExcelWithOtherApplications@xlmain8.hlp>Ref
4 Getting Results - What's New in Microsoft Excel 97?=xlidxWhatsNewInMicrosoftExcel97@xlmain8.hlp>Ref
3 Microsoft Office
4 Getting Results - About Creating and Opening Documents and Databases=xlidxGettingResultsAboutCreatingOpeningDocumentsDatabases@xlmain8.hlp>Ref
4 Getting Results - Customize Office=xlidxGettingResultsCustomizeOffice@xlmain8.hlp>Ref
4 Getting Results - Install and Start Microsoft Office=xlidxGettingResultsInstallStartMicrosoftOffice@xlmain8.hlp>Ref
4 Getting Results - Office and the Web=xlidxGettingResultsOfficeWeb@xlmain8.hlp>Ref
4 Getting Results - Take a Shortcut to Work=oflistindexTakeAShortcutToWork@xlmain8.hlp>Ref
4 Getting Results - Using Office Applications Together=xlidxGettingResultsUsingOfficeApplicationsTogether@xlmain8.hlp>Ref
4 Getting Results - What's New in Office 97?=xlidxGettingResultsWhatsNewInOffice97@xlmain8.hlp>Ref
1 Installing and Removing Microsoft Excel
2 Install or remove individual components of Microsoft Office or Microsoft Excel=wohowInstallorremoveindividualcomponentsofWord@xlmain8.hlp>HowTo
2 Add-in programs included with Microsoft Excel=xlrefAddinProgramsIncludedWithMicrosoftExcel@xlmain8.hlp>Ref
2 Install multilanguage support=wohowAddNewFontToYourComputer@xlmain8.hlp>HowTo
2 Register Microsoft Office or Microsoft Excel=oftbsRegisterMicrosoftOfficeOrprogram@xlmain8.hlp>HowTo
2 My Office program won't run.=oftbcImReceivingErrorMessageThatProgramCannotBeLocated@xlmain8.hlp>Ref
1 Creating, Opening, and Saving Files
2 Creating a Workbook
3 Create a new workbook=ofconCreateNewDocument@xlmain8.hlp>HowTo
3 Create a form=xldecCreateForm@xlmain8.hlp>Ref
3 Set the default working folder that appears in the Open and Save As dialog boxes=oflrgSetWorkingFolderToUseWhenIOpenOrSaveDocuments@xlmain8.hlp>Ref
3 View or save files from other programs as Microsoft Excel workbooks=xldecImportTextDataIntoMicrosoftExcel@xlmain8.hlp>Ref
2 Opening a Workbook
3 Open a workbook=ofdecOpenDocument@xlmain8.hlp>Ref
3 Open several workbooks at once=ofhowSelectMultipleFiles@xlmain8.hlp>HowTo
3 Open a workbook as read-only=ofhowOpenDocumentReadOnly@xlmain8.hlp>HowTo
3 Open workbooks when Microsoft Excel starts=xlhowOpenworkbookswhenMicrosoftExcelstarts@xlmain8.hlp>HowTo
3 Open a backup copy of a workbook=xlhowOpenabackupcopyofadocument@xlmain8.hlp>HowTo
2 View all file types and file name extensions=ofhowViewAllFilesFileNameExtensions@xlmain8.hlp>HowTo
3 Add a folder or file shortcut to the Favorites folder=coconTheFavoritesFolderAndMyDocumentsFolder@xlmain8.hlp>HowTo
3 Connect to a network drive=ofhowPrintSelectedFiles@xlmain8.hlp>HowTo
3 Give others access to workbooks on my hard disk=ofhowShareFolderWithAnotherPerson@xlmain8.hlp>HowTo
3 Show or hide the list of recently used workbooks on the File menu=cohowDisplayOrHideRecentlyUsedDocumentsOnTheFileMenu@xlmain8.hlp>HowTo
3 Troubleshoot finding and opening files=cotbsTroubleshootingProblemsFindingDocuments@xlmain8.hlp>Ref
2 Identifying Files by Using File Properties
3 Use file properties to locate files=codecViewAndEditDocumentProperties@xlmain8.hlp>Ref
3 Change the author name for workbooks=cohowChangeTheUserNameThatAppearsInTheAuthorBox@xlmain8.hlp>HowTo
3 Preview file contents and properties=cohowViewFileContentsAndOtherFileInformation@xlmain8.hlp>HowTo
3 Set properties to make a workbook read-only=xlhowSetPropertiesToMakeFileReadonlyHiddenOrArchivable@xlmain8.hlp>HowTo
3 Use Microsoft Outlook to view files by file properties=ofhowCreateviewsofdocumentsbasedonproperties@xlmain8.hlp>HowTo
2 Finding and Previewing Files
3 Find files=ofdecUseSavedSearchCriteriaToFindFiles@xlmain8.hlp>Ref
3 Use file properties to locate files=codecViewAndEditDocumentProperties@xlmain8.hlp>Ref
3 Sort a list of files=cohowSortAListOfFilesFound@xlmain8.hlp>HowTo
3 Delete a saved search=cohowDeleteASavedSearch@xlmain8.hlp>HowTo
3 Display file names from different folders as one list=ofhowGroupFilesByFolder>HowTo
3 Ways to speed up file searches with Find Fast=coconSpeedingUpFileSearches@xlmain8.hlp>Ref
3 Troubleshoot finding and opening files=cotbsTroubleshootingProblemsFindingDocuments@xlmain8.hlp>Ref
2 Creating and Using Workbook Templates
3 Customize the defaults for a workbook or worksheet by using a template=xlhowChangeTheDefaultFormatsUsedForNewWorkbooksAndSheets@xlmain8.hlp>HowTo
3 Change the format or content of an existing template=xldccModifyAnExistingTemplate@xlmain8.hlp>Ref
3 Ready-to-use forms and templates included with Microsoft Excel=xlconTemplatesIncludedWithMicrosoftExcel@xlmain8.hlp>HowTo
3 Insert a new sheet that's based on a custom template=xlhowInsertANewSheetBasedOnATemplateISelect@xlmain8.hlp>HowTo
3 Create a template to export worksheet data to a database=xlhowCreateATemplateToExportWorksheetDataToADatabase@xlmain8.hlp>HowTo
3 Guidelines for storing templates=xlconWhereShouldIStoreMyTemplates@xlmain8.hlp>Ref
3 Settings Microsoft Excel can save in a template=xlconWhatSettingsCanISaveInATemplate@xlmain8.hlp>Ref
3 Troubleshoot template problems=xltbsTroubleshootTemplates@xlmain8.hlp>Ref
2 Organizing Office Documents into a Binder
3 Combine and organize related files by using Office Binder=ofconOfficeBinder@xlmain8.hlp>Ref
2 Saving Work and Closing Workbooks
3 Guidelines for naming workbooks=xlconNamingDocumentsExcel@xlmain8.hlp>Ref
3 The best place to store workbooks=ofdecAboutOpenSaveDialogBoxes@xlmain8.hlp>Ref
3 Save a workbook=xltbsTroubleshootProblemsWithSavingAndClosingDocuments@xlmain8.hlp>Ref
3 Save workbook data as an HTML Web page=xlhowCreateWebPageFromWorksheetData@xlmain8.hlp>HowTo
3 Close a workbook=cohowCloseADocument@xlmain8.hlp>HowTo
3 Save a group of workbooks in a customized workspace=xlhowCreateAndSaveAWorkspaceFile@xlmain8.hlp>HowTo
3 Change the default file format for saving workbooks=xldccSetDefaultFileFormatForSavingDocuments@xlmain8.hlp>HowTo
3 Troubleshoot saving and closing workbooks=xltbsTroubleshootProblemsWithSavingAndClosingDocuments@xlmain8.hlp>Ref
2 Managing Files
3 Copy a file=ofhowCopyFile@xlmain8.hlp>HowTo
3 Delete a file=ofhowDeleteFile@xlmain8.hlp>HowTo
3 Move a file=ofhowMoveFile@xlmain8.hlp>HowTo
3 Rename a file=ofhowRenameFile@xlmain8.hlp>HowTo
2 Converting Files to and from Microsoft Excel
3 View or save files from other programs as Microsoft Excel workbooks=xldecImportTextDataIntoMicrosoftExcel@xlmain8.hlp>Ref
3 Using Microsoft Excel 97 files with previous versions of Microsoft Excel or other programs=xlconUsingFilesCreatedWithPreviousVersionsOfMicrosoftExcel
3 Save workbook data as an HTML Web page=xlhowCreateWebPageFromWorksheetData@xlmain8.hlp>HowTo
3 File format converters supplied with Microsoft Excel=xlmscFileFormatsSuppliedWithMicrosoftExcel@xlmain8.hlp>Ref
3 Formatting and features not transferred in file conversions=xldecFormattingFeaturesNotTransferredInFileConversions@xlmain8.hlp>Ref
3 Move files between Windows and the Macintosh=cohowMoveFilesBetweenWindowsAndTheMacintosh@xlmain8.hlp>HowTo
3 Troubleshoot converting file formats=xldecTroubleshootConvertingFileFormats@xlmain8.hlp>Ref
1 Working with Workbooks and Worksheets
2 About workbooks and worksheets=xlconWorkbooksAndWorksheets@xlmain8.hlp>Ref
2 Use shortcut keys in Microsoft Excel=xlrefUsingshortcutkeys@xlmain8.hlp>Ref
3 Troubleshoot working with workbooks and worksheets=xltbsTroubleshootWorkingWithWorkbooksWorksheets@xlmain8.hlp>Ref
2 Moving Around in Workbooks
3 Move and scroll through a worksheet=xlhowMoveAndScrollWithinAWorksheet@xlmain8.hlp>Ref
3 Switch to another sheet in a workbook=xlhowSwitchToAnotherSheetInAWorkbook@xlmain8.hlp>HowTo
3 Select sheets in a workbook=xlhowSelectSheetsInAWorkbook@xlmain8.hlp>Ref
3 Display more or fewer sheet tabs=xlhowDisplayMoreOrFewerSheetTabs@xlmain8.hlp>HowTo
3 Scroll and zoom on a worksheet by using the Microsoft IntelliMouse pointing device=xlhowScrollZoomThroughYourWorksheetByUsingIntelliMouse@xlmain8.hlp>Ref
2 Managing Worksheets
3 Insert a new worksheet=xlnschowAddAWorksheet@xlmain8.hlp>HowTo
3 Insert a new sheet that's based on a custom template=xlhowInsertANewSheetBasedOnATemplateISelect@xlmain8.hlp>HowTo
3 Move or copy sheets=xlhowMoveOrCopySheets@xlmain8.hlp>HowTo
3 Delete sheets from a workbook=xlhowDeleteSheetsFromAWorkbook@xlmain8.hlp>HowTo
3 Rename a sheet=xlhowRenameASheet@xlmain8.hlp>HowTo
3 Display more or fewer sheet tabs=xlhowDisplayMoreOrFewerSheetTabs@xlmain8.hlp>HowTo
3 Hide all or part of a workbook=xldecHideAndUnhideWorkbooksAndSheets@xlmain8.hlp>Ref
3 Display a hidden workbook=xlhowDisplayHiddenWorkbook@xlmain8.hlp>HowTo
3 Display a hidden sheet=xlnschowDisplayAHiddenSheet@xlmain8.hlp>HowTo
3 Display hidden rows or columns=xnsclhowDisplayHiddenRowsOrColumns@xlmain8.hlp>HowTo
2 Changing the Defaults for New Workbooks and Worksheets
3 Change the default number of worksheets in a new workbook=xlhowChangeDefaultNumberOfWorksheetsInNewWorkbook@xlmain8.hlp>HowTo
3 Create a template for new worksheets=xlhowChangeTheDefaultTemplateUsedForNewSheetsInAWorkbook@xlmain8.hlp>HowTo
3 Restore original settings for new workbooks and worksheets=xlhowRestoreOriginalSettingsNewWorkbooksWorksheets@xlmain8.hlp>HowTo
2 Changing What You See on the Screen
3 Magnify or reduce the display=xlhowMagnifyOrReduceDisplay@xlmain8.hlp>HowTo
3 Hide window elements to show more data on the screen=conschowDisplayTheFullScreen@xlmain8.hlp>HowTo
3 Display or hide specific window elements=xlhowDisplayOrHideSpecificWindowElements@xlmain8.hlp>HowTo
3 Change the color of cell gridlines=xlhowChangeColorOfCellGridlines@xlmain8.hlp>HowTo
3 Show or hide a toolbar=ofhowShowOrHideCommandBar@xlmain8.hlp>HowTo
2 Arranging Workbook Windows
3 Minimize a workbook window=ofhowMinimizeDocumentWindowToIcon@xlmain8.hlp>HowTo
3 Restore a minimized workbook window=ofhowRestoreDocumentIconToWindow@xlmain8.hlp>HowTo
3 Arrange minimized workbook icons in the Microsoft Excel window=ofhowArrangeDocumentIconsInProgramWindow@xlmain8.hlp>HowTo
3 Minimize all program windows on the Windows desktop=ofhowClearWindowsDesktop@xlmain8.hlp>HowTo
3 View mulitple sheets or workbooks=xlhowArrangeWindowsToViewMultipleWorksheets@xlmain8.hlp>HowTo
3 View different parts of a worksheet at the same time=xlconSplittingWorksheetsAndFreezingPanes@xlmain8.hlp>Ref
3 Restore a split window to a single pane=xlhowRestoreSplitWindowToSinglePane@xlmain8.hlp>HowTo
3 Close workbook windows=xlrefCloseWorkbookWindows@xlmain8.hlp>Ref
2 Saving Display and Print Settings as a View
3 Custom views=xlconCustomViews@xlmain8.hlp>Ref
3 Create a view=xlhowCreateOrDeleteAViewOfAWorksheet@xlmain8.hlp>HowTo
3 Display a view=xlhowDisplayAViewOfAWorksheet@xlmain8.hlp>HowTo
3 Print a view=xlhowPrintAViewOfAWorksheet@xlmain8.hlp>HowTo
3 Delete a view=xlhowDeleteAViewOfAWorksheet@xlmain8.hlp>HowTo
2 Saving Your Workspace
3 Create and save a workspace file=xlhowCreateAndSaveAWorkspaceFile@xlmain8.hlp>HowTo
1 Entering Data and Selecting Cells
2 Entering Data
3 Enter data in worksheet cells=xldecEnterDataInWorksheetCells@xlmain8.hlp>Ref
3 Enter numbers with decimal places or trailing zeros=xlhowEnterNumbersWithFixedDecimalPlaces@xlmain8.hlp>HowTo
3 Automatically fill in data based on adjacent cells=xldecAutomaticallyFillInDataBasedOnAdjacentCells@xlmain8.hlp>Ref
3 Types of series that Microsoft Excel can fill in for you=xlrefTypesOfSeriesYouCanCreateWithAutoFill@xlmain8.hlp>Ref
3 Cancel or undo an entry=xlhowCancelOrUndoAnEntry@xlmain8.hlp>HowTo
3 Change options for entering and editing data=xlhowChangeWayIEnterEditData@xlmain8.hlp>Ref
3 Type ¢, £, ¥, (r), and other characters not on the keyboard=xlhowTypeAndOtherCharactersNotOnTheKeyboard>HowTo
3 Tips on entering dates and times=xlconGuidelinesForEnteringDatesAndTimes@xlmain8.hlp>Ref
3 Tips on entering numbers=xlconGuidelinesForEnteringNumbers@xlmain8.hlp>Ref
3 Tips on entering text=xlconGuidelinesForEnteringText@xlmain8.hlp>Ref
3 Troubleshoot entering data=xltbsTroubleshootEnteringData@xlmain8.hlp>Ref
2 Selecting and Moving Around in a Workbook
3 Move and scroll through a worksheet=xlhowMoveAndScrollWithinAWorksheet@xlmain8.hlp>Ref
3 Select cells on a worksheet=xldecSelectCellsOfAWorksheet@xlmain8.hlp>Ref
3 Select only blank cells or cells that contain formulas, constants, or comments=xlSelectCellsThatContainSpecificTypesOfDataSuchAsFormulasOrConstants@xlmain8.hlp>HowTo
3 Select only visible cells=xlhowSelectVisibleCellsOnly@xlmain8.hlp>HowTo
3 Switch to another sheet in a workbook=xlhowSwitchToAnotherSheetInAWorkbook@xlmain8.hlp>HowTo
3 Select sheets in a workbook=xlhowSelectSheetsInAWorkbook@xlmain8.hlp>Ref
3 Cancel a selection of cells=xlhowCancelASelection@xlmain8.hlp>HowTo
3 Cancel a selection of multiple sheets=xlCancelSelectionOfMultipleSheets@xlmain8.hlp>HowTo
3 Troubleshoot selecting and moving in a workbook=xltbsTroubleshootSelectingAndMovingInAWorkbook@xlmain8.hlp>Ref
1 Editing Worksheet Data
2 Edit cell contents=xlhowEditcellcontents@xlmain8.hlp>HowTo
2 Clear or delete cells, rows, or columns=xlconInsertinganddeletingcells@xlmain8.hlp>Ref
2 Clear contents, formats, or comments from cells=xlhowClearrowsandcolumns@xlmain8.hlp>HowTo
2 Undo mistakes=xlhowUndoMistakes@xlmain8.hlp>HowTo
2 Repeat the last action=xlhowRepeatMyLastAction@xlmain8.hlp>HowTo
2 Separate text across cells=xlhowSeparateTextValuesAcrossCells@xlmain8.hlp>HowTo
2 Troubleshoot editing data=xltbsTroubleshootEditingData@xlmain8.hlp>Ref
2 Finding or Replacing Data
3 Find or replace data=xlhowFindOrReplaceTextOrNumbers@xlmain8.hlp>Ref
3 Highlight values that meet conditions you specify=xldecIdentifyCellValuesThatMeetConditionsYouSpecify@xlmain8.hlp>Ref
3 Display a subset of rows in a list by using filters=xlhowFilteringAList@xlmain8.hlp>HowTo
3 Wildcard characters you can use to find text or numbers=xllrgWildcardCharactersYouCanUseToFindText@xlmain8.hlp>Ref
2 Inserting, Copying, and Moving Cells and Data
3 Move or copy cell data=xldecMoveOrCopyCells@xlmain8.hlp>Ref
3 Copy only values, formulas, comments, or cell formats=xlhowCopythecellformula@xlmain8.hlp>HowTo
3 Copy only visible cells=xlhowCopyvisiblecells@xlmain8.hlp>HowTo
3 Switch rows of cells to columns, or columns to rows=xlhowTransposerowsandcolumnsasyoupaste@xlmain8.hlp>HowTo
3 Insert cells, rows, or columns=xlInsertCellsRowsOrColumns@xlmain8.hlp>Ref
2 Checking Spelling and Correcting Typing Errors
3 Check spelling or automatically correct spelling errors=xldecCheckSpellingOrAutomaticallyCorrectSpellingErrors@xlmain8.hlp>Ref
3 Parts of a worksheet that are checked for spelling=xlconWhichPartsOfWorksheetAreCheckedForSpelling@xlmain8.hlp>Ref
3 Prevent automatic corrections=xlhownxlscTurnOffAutoCorrect@xlmain8.hlp>HowTo
3 Change the name or contents of an AutoCorrect entry=wohowChangeTheContentsOfAnAutoCorrectEntry@xlmain8.hlp>HowTo
3 Delete an AutoCorrect entry=wohowDeleteanAutoCorrectentry@xlmain8.hlp>HowTo
3 Exclude specific abbreviations or capitalized text from automatic changes=xlhowPreventAutoCorrectFromCorrectingSpecificAbbreviationsOrCapitalizedText@xlmain8.hlp>HowTo
3 Troubleshoot correcting spelling and typing errors=xltbsTroubleshootCorrectingSpellingTypingErrors@xlmain8.hlp>Ref
1 Formatting  Worksheets
2 Basic Formatting=xllrgBasicFormatting@xlmain8.hlp>LgCard
2 Formatting Text and Cells
3 Copy formats from one cell or range to another=xlhowCopyFormatsFromOneCellOrRangeToAnother@xlmain8.hlp>HowTo
3 Change the size, font, color, or other text format=xlhowChangeSizeFontColorOrOtherTextFormat@xlmain8.hlp>Ref
3 Display multiple lines of text within a cell=xlhowDisplayMultipleLinesOfTextWithinCell@xlmain8.hlp>HowTo
3 Highlight values that meet conditions you specify=xldecIdentifyCellValuesThatMeetConditionsYouSpecify@xlmain8.hlp>Ref
3 Format a PivotTable=xlhowFormatPivotTable@xlmain8.hlp>HowTo
3 Troubleshoot formatting cells and data=xltbsTroubleshootFormattingCellsData@xlmain8.hlp>Ref
2 Applying Borders, Shading, and Background Patterns
3 Apply borders to cells=xldccAddBordersToCells@xlmain8.hlp>HowTo
3 Shade cells with solid color=xlhowShadeCellsWithSolidColors@xlmain8.hlp>HowTo
3 Shade cells with patterns=xlhowShadeCellsWithPatternedShading@xlmain8.hlp>HowTo
3 Remove borders=xlhowRemoveBorders@xlmain8.hlp>HowTo
3 Remove shading=xlhowRemoveShading@xlmain8.hlp>HowTo
3 Add background patterns to entire sheets=xlhowAddBackgroundPatternsToSheets@xlmain8.hlp>HowTo
3 Remove a sheet background pattern=xlhowRemoveBackgroundPatternsFromSheet@xlmain8.hlp>HowTo
2 Positioning Cells and Text Within Cells
3 Display multiple lines of text within a cell=xlhowDisplayMultipleLinesOfTextWithinCell@xlmain8.hlp>HowTo
3 Change column width and row height=xlhowAdjustColumnWidthAndRowHeight@xlmain8.hlp>Ref
3 Merge cells to span several columns or rows=xldccMergeCellsToSpanSeveralColumnsOrRows@xlmain8.hlp>HowTo
3 Split a merged cell into separate cells=xlhowSplitMergedCellIntoSeparateCells@xlmain8.hlp>HowTo
2 Formatting Numbers, Dates, and Times
3 Number formatting=xllrgNumberFormatting@xlmain8.hlp>LgCard
3 Change the way Microsoft Excel displays numbers, dates, and times=xlhowChangeWayMicrosoftExcelDisplaysNumbersDatesTimes@xlmain8.hlp>HowTo
3 Create a custom number format=xlhowCreatecustomnumberformats@xlmain8.hlp>HowTo
3 Custom number, date, and time format codes=xldefCustomNumberFormats@xlmain8.hlp>Ref
3 Delete custom number formats=xlhowDeletecustomnumberformats@xlmain8.hlp>HowTo
3 Display or hide zero values or other cell data=xldecDisplayOrHideZeroValuesOrOtherCellData@xlmain8.hlp>Ref
3 Display formulas or formula results on a worksheet=xlhowDisplayFormulasOrFormulaResultsOnWorksheet@xlmain8.hlp>HowTo
3 Format numbers as text=xlhowFormatnumbersastext@xlmain8.hlp>HowTo
3 Troubleshoot formatting numbers, dates, and times=xltbsTroubleshootFormattingNumbersDatesTimes@xlmain8.hlp>Ref
2 Formatting Quickly with Styles and Built-in Formats
3 Format cells and lists quickly with styles or built-in table formats=xldecFormatCellsListsQuicklyWithStylesOrBuiltinTableFormats@xlmain8.hlp>Ref
3 Create a new style=xlhowCreateastylebyexample@xlmain8.hlp>HowTo
3 Remove a style from selected cells=xlhowRemoveStyleFromSelectedCells@xlmain8.hlp>HowTo
3 Remove an autoformat from a range of cells=xlhowClearanautoformat@xlmain8.hlp>HowTo
3 Change the formats for an existing style=xlhowRedefineastylebyexample@xlmain8.hlp>HowTo
3 Delete a style=xlhowDeleteastyle@xlmain8.hlp>HowTo
3 Copy styles from another workbook=xlhowCopystylesfromanotherworkbook@xlmain8.hlp>HowTo
3 Save styles for use in new workbooks=xlhowSaveStylesToTheAutotemplate@xlmain8.hlp>HowTo
1 Printing
2 What to do before you print=xllrgWhatToDoBeforeYouPrint@xlmain8.hlp>LgCard
2 Print the active sheets, a selected range, or an entire workbook=xldccPrintSheetSelectedRangeOrEntireWorkbook@xlmain8.hlp>HowTo
2 Troubleshoot printing=xlhowTroubleshootPrinting@xlmain8.hlp>Ref
2 View the printing status of the printer and files as they print=ofhowViewPrinterStatusInformationAboutDocumentsPrinting@xlmain8.hlp>HowTo
2 Send a fax=ofhowCreateFax@xlmain8.hlp>HowTo
2 Setting Up the Printer
3 Set up a new printer=ofhowSetUpNewPrinter@xlmain8.hlp>HowTo
3 Set the default printer=ofhowSetDefaultPrinterInWindows@xlmain8.hlp>HowTo
2 Setting Print Options
3 Print the row and column headings on every page=xldccPrintRowColumnHeadingsOnEveryPage@xlmain8.hlp>HowTo
3 Print row and column labels on every page=xldccPrintRowColumnLabelsOnEveryPage@xlmain8.hlp>HowTo
3 Print cell gridlines=xldccPrintCellGridlines@xlmain8.hlp>HowTo
3 Print comments=xldccPrintComments@xlmain8.hlp>HowTo
3 Print more than one copy of a sheet or a workbook, or print to a file=xldecPrintMoreThanCopyOfWorksheetMoreThanOneWorkbookOrPrintToFile@xlmain8.hlp>Ref
3 Speed up printing a worksheet=xldecPrintWorksheetQuickly@xlmain8.hlp>Ref
3 Size and set up a chart for printing=xlhowSizeAndSetUpAChartSheetForPrinting@xlmain8.hlp>HowTo
2 Changing the Layout, Page Breaks, and Margins of a Printed Worksheet
3 Print a specific area of a worksheet=xldecChangeOrRemovePrintArea@xlmain8.hlp>HowTo
3 Remove a print area=xldccRemovePrintArea@xlmain8.hlp>HowTo
3 Insert or move a page break=xldecInsertAndRemovePageBreaks@xlmain8.hlp>Ref
3 Remove page breaks=xlHowRemovePageBreaks@xlmain8.hlp>HowTo
3 Set page margins=xlhowSetPageMargins@xlmain8.hlp>HowTo
3 Change the layout of the printed worksheet=xldecChangeLayoutOfPrintedWorksheet@xlmain8.hlp>Ref
3 Change the worksheet area that appears on a printed page=xldecPrintWorksheetOnSpecificNumberOfPages@xlmain8.hlp>Ref
2 Changing the Headers and Footers
3 Print the row and column headings on every page=xldccPrintRowColumnHeadingsOnEveryPage@xlmain8.hlp>HowTo
3 Print row and column labels on every page=xldccPrintRowColumnLabelsOnEveryPage@xlmain8.hlp>HowTo
3 Select a built-in header or footer=xldccUseBuiltinHeaderOrFooter@xlmain8.hlp>HowTo
3 Create custom headers and footers=xlHowCreateCustomHeadersAndFooters@xlmain8.hlp>HowTo
3 Set header or footer margins=xlhowSetHeaderAndFooterMargins@xlmain8.hlp>HowTo
3 Change the font in header and footer text=xlhowFormatHeadersAndFooters@xlmain8.hlp>HowTo
3 Change the page number for the first page=xldccChangeFirstPageNumber@xlmain8.hlp>HowTo
2 Printing Custom Reports
3 Reports produced by using views and scenarios=xlconReportsProducedByUsingViewsScenarios@xlmain8.hlp>Ref
3 Combine views and scenarios into a printed report=xlhowCreateAReport@xlmain8.hlp>HowTo
3 Edit a report created with Report Manager=xlhowEditAReport@xlmain8.hlp>HowTo
3 Print a report created with Report Manager=xlhowPrintAReport@xlmain8.hlp>HowTo
3 About the Add Report and Edit Report dialog boxes=xlcmdReportNameFilePrintReportPrintReportDialogBoxAddButtonAddReportDialogBox@xlmain8.hlp>Ref
3 About the Report Manager command (View menu)=xlcmdPrintReportCommandFileMenu@xlmain8.hlp>Ref
1 Creating an Online or Printed Form
2 Worksheet forms=xllrgFormsOnWorksheet@xlmain8.hlp>LgCard
2 Create a form=xldecCreateForm@xlmain8.hlp>Ref
2 Format a worksheet to use as a form=xldecFormatWorksheetToUseAsForm@xlmain8.hlp>Ref
2 Guidelines for printed and online forms=xlconGuidelinesForPrintedOnlineForms@xlmain8.hlp>Ref
2 Tips for creating and formatting forms=xlrefTipsForCreatingForms@xlmain8.hlp>Ref
2 Fill out an online form=xlhowFillInOnlineForm@xlmain8.hlp>HowTo
2 Troubleshoot creating forms=worefTroubleshootingforonlineforms@xlmain8.hlp>Ref
2 Adding Buttons and Other Controls to a Worksheet
3 About adding buttons, check boxes, and other controls=xlconAboutActiveXControls@xlmain8.hlp>Ref
3 Add buttons, check boxes, or other controls to a worksheet=xltbcAddButtonsCheckBoxesOrOtherControlsToWorksheet@xlmain8.hlp>Ref
3 Types of buttons, check boxes, and other controls on the Forms toolbar=xlrefTypesOfButtonsCheckBoxesOtherControlsOnFormsToolbar@xlmain8.hlp>Ref
3 Types of ActiveX controls=xlrefTypeOfActiveXControls@xlmain8.hlp>Ref
3 Automate a task by using an ActiveX control=xlhowAutomateTaskByUsingActiveXControl@xlmain8.hlp>HowTo
3 Change, move, or resize a button, check box, or other control=xltbcChangePropertiesOfButtonCheckBoxOrOtherControl@xlmain8.hlp>HowTo
3 Change, move, or resize an ActiveX control=xlhowChangePropertiesOfActiveXControl@xlmain8.hlp>HowTo
3 Troubleshoot buttons, check boxes, and other controls=xltbsTroubleshootButtonsCheckBoxesOtherControls@xlmain8.hlp>Ref
2 Tracking Form Information in a Database
3 What is the Template Wizard with Data Tracking?=xlconWhenShouldIUseTheTemplateWizard@xlmain8.hlp>Ref
3 Create a form template that copies worksheet data to a database=xlhowCreateATemplateToExportWorksheetDataToADatabase@xlmain8.hlp>HowTo
3 Change a record in a linked database created with the Template Wizard=xlhowChangeRecordInLinkedDatabaseCreatedWithTemplateWizard@xlmain8.hlp>HowTo
2 Creating Forms for Data Entry
3 Add to or change a list by using a data form=xldecAddToOrChangeListByUsingDataForm@xlmain8.hlp>Ref
3 Create a Microsoft Access form for a Microsoft Excel list=xlhowCreatingANewAccessFormWizardFormInMicrosoftExcel@xlmain8.hlp>HowTo
3 Enter data in a Microsoft Excel list by using a Microsoft Access form=xlhowUseAnExistingFormForDataEntry@xlmain8.hlp>HowTo
1 Creating Formulas and Auditing Workbooks
2 Quick calculations on a worksheet=xllrgQuickCalculationsInWorksheet@xlmain8.hlp>LgCard
2 Troubleshoot formulas and error values=xltbsTroubleshootErrorValues@xlmain8.hlp>Ref
2 Troubleshoot errors in formulas=xlrefCommonProblemsInFormulas@xlmain8.hlp>Ref
2 Entering Formulas
3 How formulas calculate values=xlconHowFormulasWork@xlmain8.hlp>Ref
3 About formula syntax=xlconAboutFormulaSyntax@xlmain8.hlp>Ref
3 About using the Formula Palette to enter and edit formulas=xlconAboutUsingFormulaPaletteToEnterEditFormulas@xlmain8.hlp>Ref
3 Calculation operators in formulas=xlrefUnderstandinghowOperatorswork@xlmain8.hlp>Ref
3 The order in which Microsoft Excel performs operations in formulas=xlrefTheOrderOfEvaluationOfOperators@xlmain8.hlp>Ref
3 How Microsoft Excel converts values in formulas=xlrefHowMicrosoftExcelhandlesunexpectedvaluesinformulas@xlmain8.hlp>Ref
3 How Microsoft Excel performs date and time calculations=xlrefHowMicrosoftExcelPerformsDateTimeCalculations@xlmain8.hlp>Ref
3 Enter a formula to calculate a value=xldccCreateFormulaToCalculateValue@xlmain8.hlp>Ref
3 Examples of common formulas=xlrefExamplesOfCommonFormulas@xlmain8.hlp>Ref
3 Display formulas and values on a worksheet=xlrefDisplayformulasandvaluesonaworksheet@xlmain8.hlp>HowTo
2 Editing Formulas
3 Edit a formula=xlhowEditformulasthatcontainfunctions@xlmain8.hlp>HowTo
3 Edit an array formula=xlhowEditanarrayformula@xlmain8.hlp>HowTo
3 Move or copy a formula=xlhowMoveOrCopyFormula@xlmain8.hlp>HowTo
3 Replace all or part of a formula with its calculated value=xldecReplacePartOrAllOfFormulaWithItsCalculatedValue@xlmain8.hlp>Ref
3 Delete a formula or an array formula=xlhowDeleteFormulaOrArrayFormula@xlmain8.hlp>HowTo
2 Using References
3 About cell and range references =xlrefReferencestyles@xlmain8.hlp>Ref
3 The difference between relative and absolute references=xlconTheDifferenceBetweenRelativeAbsoluteReferences@xlmain8.hlp>Ref
3 About R1C1 references=xlrefAboutR1C1References@xlmain8.hlp>Ref
3 Refer to the same cell or range on multiple sheets by using a 3-D reference=xldecUseReferenceToSameCellOrRangeOnMultipleSheets@xlmain8.hlp>HowTo
3 Guidelines for using 3-D references=xlrefGuidelinesForUsing3DReferences@xlmain8.hlp>Ref
3 What happens to a 3-D reference when you move, copy, insert, or delete worksheets=xlconWhatHappensTo3DReferencesWhenYouMoveOrDeleteCells@xlmain8.hlp>Ref
2 Using Functions
3 About using functions to calculate values=xlconUsingfunctions@xlmain8.hlp>Ref
3 About multiple functions within functions, or nesting=xlhowCreateANestedFunction@xlmain8.hlp>Ref
3 About database functions=xlrefAboutDatabaseFunctions@xlmain8.hlp>Ref
3 About date and time functions=xlrefAboutDateTimeFunctions@xlmain8.hlp>Ref
3 About engineering functions=xlrefAboutEngineeringFunctions@xlmain8.hlp>Ref
3 About financial functions=xlrefAboutFinancialFunctions@xlmain8.hlp>Ref
3 About information functions=xlrefAboutInformationFunctions@xlmain8.hlp>Ref
3 About logical functions=xlrefAboutLogicalFunctions@xlmain8.hlp>Ref
3 About lookup and reference functions=xlrefAboutLookupReferenceFunctions@xlmain8.hlp>Ref
3 About math and trigonometry functions=xlrefAboutMathTrigonometryFunctions@xlmain8.hlp>Ref
3 About statistical functions=xlrefAboutStatisticalFunctions@xlmain8.hlp>Ref
3 About text functions=xlrefAboutTextFunctions@xlmain8.hlp>Ref
3 About user-defined functions=xlrefAboutUserDefinedFunctions@xlmain8.hlp>Ref
2 Working with Labels and Names
3 About labels and names in formulas=xlconLabelsNamesInFormulas@xlmain8.hlp>Ref
3 About labeling ranges by using the Label Ranges dialog box=xlconAboutLabelingRangesByUsingLabelRangesCommand@xlmain8.hlp>Ref
3 Guidelines for naming cells, formulas, and constants in Microsoft Excel=xlconRulesForNames@xlmain8.hlp>Ref
3 Name cells in a workbook=xldecNameCellsInWorkbook@xlmain8.hlp>Ref
3 Create a name to represent a formula or a constant value=xlhowNameaformulaorreference@xlmain8.hlp>HowTo
3 Determine what a name refers to=xlhowCheckwhatanamerefersto@xlmain8.hlp>HowTo
3 Change cell references in formulas to names=xlhowReplacecellreferenceswithadefinedname@xlmain8.hlp>HowTo
3 Change the cell, formula, or constant represented by a name=xlhowEditthereferenceorformulaforaname@xlmain8.hlp>HowTo
3 Change the name for a reference, formula, or constant=xlhowChangeanamedreference@xlmain8.hlp>HowTo
2 Working with Arrays
3 About array formulas and how to enter them=xlconArrayformulas@xlmain8.hlp>Ref
3 Values that do not change in array formulas=xlconConstantsinanarray@xlmain8.hlp>Ref
3 Items that an array constant can contain=xlrefItemsThatArrayConstantCanContain@xlmain8.hlp>Ref
3 Select a range that contains an array formula=xlhowSelectanarrayrange@xlmain8.hlp>HowTo
2 Controlling Calculation
3 About calculation in workbooks=xlconControllingcalculationsinaworksheet@xlmain8.hlp>Ref
3 Change the way Microsoft Excel calculates formulas=xldecChangeHowMicrosoftExcelCalculatesFormulas@xlmain8.hlp>Ref
3 Manually calculate all open workbooks=xlhowManuallycalculateallopenworkbooks@xlmain8.hlp>HowTo
2 Solving Circular Reference Formulas
3 Formulas that refer back to their own cells=xlconControllingcircularreferenceformulas@xlmain8.hlp>Ref
3 Locate cells that create a circular reference=xlhowIdentifyWorkWithCellsThatCreateCircularReference@xlmain8.hlp>HowTo
2 Linking Workbooks
3 About using formulas to calculate values on other worksheets and workbooks=xlconWhentolinkworkbooks@xlmain8.hlp>Ref
3 Create a formula to calculate data on another worksheet or workbook=xlhowEnteranexternalreferenceinaformula@xlmain8.hlp>HowTo
3 Open a workbook referenced by a formula=xlhowOpenasourceworkbook@xlmain8.hlp>HowTo
3 Update references to a workbook that has been renamed or moved=xlhowRedirectlinksforasourceworkbook@xlmain8.hlp>HowTo
2 Understanding Errors Returned by Formulas
3 What does the error ##### mean?=xlrefWhatTheErrorValueMeans@xlmain8.hlp>Ref
3 What does the error #DIV/0! mean?=xlrefWhatTheErrorValueDIV0Means@xlmain8.hlp>Ref
3 What does the error #N/A mean?=xlrefWhatTheErrorValueNAMeans@xlmain8.hlp>Ref
3 What does the error #NAME? mean?=xlrefWhatTheErrorValueNAMEMeans@xlmain8.hlp>Ref
3 What does the error #NULL! mean?=xlrefWhatTheErrorValueNULLMeans@xlmain8.hlp>Ref
3 What does the error #NUM! mean?=xlrefWhatTheErrorValueNUMMeans@xlmain8.hlp>Ref
3 What does the error #REF! mean?=xlrefWhatTheErrorValueREFMeans@xlmain8.hlp>Ref
3 What does the error #VALUE! mean?=xlrefWhatTheErrorValueVALUEMeans@xlmain8.hlp>Ref
2 Worksheet Function Reference
3 Database and List-Management Functions
4 Database Functions=xlfctDatabaseFunctions@xlmain8.hlp>LangRef
4 DAVERAGE Worksheet Function=xlfctDAVERAGE@xlmain8.hlp>LangRef
4 DCOUNT Worksheet Function=xlfctDCOUNT@xlmain8.hlp>LangRef
4 DCOUNTA Worksheet Function=xlfctDCOUNTA@xlmain8.hlp>LangRef
4 DGET Worksheet Function=xlfctDGET@xlmain8.hlp>LangRef
4 DMAX Worksheet Function=xlfctDMAX@xlmain8.hlp>LangRef
4 DMIN Worksheet Function=xlfctDMIN@xlmain8.hlp>LangRef
4 DPRODUCT Worksheet Function=xlfctDPRODUCT@xlmain8.hlp>LangRef
4 DSTDEV Worksheet Function=xlfctDSTDEV@xlmain8.hlp>LangRef
4 DSTDEVP Worksheet Function=xlfctDSTDEVP@xlmain8.hlp>LangRef
4 DSUM Worksheet Function=xlfctDSUM@xlmain8.hlp>LangRef
4 DVAR Worksheet Function=xlfctDVAR@xlmain8.hlp>LangRef
4 DVARP Worksheet Function=xlfctDVARP@xlmain8.hlp>LangRef
4 GETPIVOTDATA Worksheet Function=xlfctGETPIVOTDATA@xlmain8.hlp>LangRef
3 Date and Time Functions
4 DATE Worksheet Function=xlfctDATE@xlmain8.hlp>LangRef
4 DATEVALUE Worksheet Function=xlfctDATEVALUE@xlmain8.hlp>LangRef
4 DAY Worksheet Function=xlfctDAY@xlmain8.hlp>LangRef
4 DAYS360 Worksheet Function=xlfctDAYS360@xlmain8.hlp>LangRef
4 EDATE Worksheet Function=xlfctEDATE@xlmain8.hlp>LangRef
4 EOMONTH Worksheet Function=xlfctEOMONTH@xlmain8.hlp>LangRef
4 HOUR Worksheet Function=xlfctHOUR@xlmain8.hlp>LangRef
4 MINUTE Worksheet Function=xlfctMINUTE@xlmain8.hlp>LangRef
4 MONTH Worksheet Function=xlfctMONTH@xlmain8.hlp>LangRef
4 NETWORKDAYS Worksheet Function=xlfctNETWORKDAYS@xlmain8.hlp>LangRef
4 NOW Worksheet Function=xlfctNOW@xlmain8.hlp>LangRef
4 SECOND Worksheet Function=xlfctSECOND@xlmain8.hlp>LangRef
4 TIME Worksheet Function=xlfctTIME@xlmain8.hlp>LangRef
4 TIMEVALUE Worksheet Function=xlfctTIMEVALUE@xlmain8.hlp>LangRef
4 TODAY Worksheet Function=xlfctTODAY@xlmain8.hlp>LangRef
4 WEEKDAY Worksheet Function=xlfctWEEKDAY@xlmain8.hlp>LangRef
4 WEEKNUM Worksheet Function=xlfctWEEKNUM@xlmain8.hlp>LangRef
4 WORKDAY Worksheet Function=xlfctWORKDAY@xlmain8.hlp>LangRef
4 YEAR Worksheet Function=xlfctYEAR@xlmain8.hlp>LangRef
4 YEARFRAC Worksheet Function=xlfctYEARFRAC@xlmain8.hlp>LangRef
3 DDE and External Functions
4 CALL Worksheet Function=xlfctCALL@xlmain8.hlp>LangRef
4 REGISTER.ID Worksheet Function=xlfctREGISTERID@xlmain8.hlp>LangRef
4 SQL.REQUEST Worksheet Function=xlfctSQLREQUEST@xlmain8.hlp>LangRef
4 Using the CALL and REGISTER Functions=xlfctUsingCALLandREGISTERFunctions@xlmain8.hlp>LangRef
3 Engineering Functions
4 BESSELI Worksheet Function=xlfctBESSELI@xlmain8.hlp>LangRef
4 BESSELJ Worksheet Function=xlfctBESSELJ@xlmain8.hlp>LangRef
4 BESSELK Worksheet Function=xlfctBESSELK@xlmain8.hlp>LangRef
4 BESSELY Worksheet Function=xlfctBESSELY@xlmain8.hlp>LangRef
4 BIN2DEC Worksheet Function=xlfctBIN2DEC@xlmain8.hlp>LangRef
4 BIN2HEX Worksheet Function=xlfctBIN2HEX@xlmain8.hlp>LangRef
4 BIN2OCT Worksheet Function=xlfctBIN2OCT@xlmain8.hlp>LangRef
4 COMPLEX Worksheet Function=xlfctCOMPLEX@xlmain8.hlp>LangRef
4 CONVERT Worksheet Function=xlfctCONVERT@xlmain8.hlp>LangRef
4 DEC2BIN Worksheet Function=xlfctDEC2BIN@xlmain8.hlp>LangRef
4 DEC2HEX Worksheet Function=xlfctDEC2HEX@xlmain8.hlp>LangRef
4 DEC2OCT Worksheet Function=xlfctDEC2OCT@xlmain8.hlp>LangRef
4 DELTA Worksheet Function=xlfctDELTA@xlmain8.hlp>LangRef
4 ERF Worksheet Function=xlfctERF@xlmain8.hlp>LangRef
4 ERFC Worksheet Function=xlfctERFC@xlmain8.hlp>LangRef
4 GESTEP Worksheet Function=xlfctGESTEP@xlmain8.hlp>LangRef
4 HEX2BIN Worksheet Function=xlfctHEX2BIN@xlmain8.hlp>LangRef
4 HEX2DEC Worksheet Function=xlfctHEX2DEC@xlmain8.hlp>LangRef
4 HEX2OCT Worksheet Function=xlfctHEX2OCT@xlmain8.hlp>LangRef
4 IMABS Worksheet Function=xlfctIMABS@xlmain8.hlp>LangRef
4 IMAGINARY Worksheet Function=xlfctIMAGINARY@xlmain8.hlp>LangRef
4 IMARGUMENT Worksheet Function=xlfctIMARGUMENT@xlmain8.hlp>LangRef
4 IMCONJUGATE Worksheet Function=xlfctIMCONJUGATE@xlmain8.hlp>LangRef
4 IMCOS Worksheet Function=xlfctIMCOS@xlmain8.hlp>LangRef
4 IMDIV Worksheet Function=xlfctIMDIV@xlmain8.hlp>LangRef
4 IMEXP Worksheet Function=xlfctIMEXP@xlmain8.hlp>LangRef
4 IMLN Worksheet Function=xlfctIMLN@xlmain8.hlp>LangRef
4 IMLOG10 Worksheet Function=xlfctIMLOG10@xlmain8.hlp>LangRef
4 IMLOG2 Worksheet Function=xlfctIMLOG2@xlmain8.hlp>LangRef
4 IMPOWER Worksheet Function=xlfctIMPOWER@xlmain8.hlp>LangRef
4 IMPRODUCT Worksheet Function=xlfctIMPRODUCT@xlmain8.hlp>LangRef
4 IMREAL Worksheet Function=xlfctIMREAL@xlmain8.hlp>LangRef
4 IMSIN Worksheet Function=xlfctIMSIN@xlmain8.hlp>LangRef
4 IMSQRT Worksheet Function=xlfctIMSQRT@xlmain8.hlp>LangRef
4 IMSUB Worksheet Function=xlfctIMSUB@xlmain8.hlp>LangRef
4 IMSUM Worksheet Function=xlfctIMSUM@xlmain8.hlp>LangRef
4 OCT2BIN Worksheet Function=xlfctOCT2BIN@xlmain8.hlp>LangRef
4 OCT2DEC Worksheet Function=xlfctOCT2DEC@xlmain8.hlp>LangRef
4 OCT2HEX Worksheet Function=xlfctOCT2HEX@xlmain8.hlp>LangRef
3 Financial Functions
4 ACCRINT Worksheet Function=xlfctACCRINT@xlmain8.hlp>LangRef
4 ACCRINTM Worksheet Function=xlfctACCRINTM@xlmain8.hlp>LangRef
4 AMORDEGRC Worksheet Function=xlfctAMORDEGRC@xlmain8.hlp>LangRef
4 AMORLINC Worksheet Function=xlfctAMORLINC@xlmain8.hlp>LangRef
4 COUPDAYBS Worksheet Function=xlfctCOUPDAYBS@xlmain8.hlp>LangRef
4 COUPDAYS Worksheet Function=xlfctCOUPDAYS@xlmain8.hlp>LangRef
4 COUPDAYSNC Worksheet Function=xlfctCOUPDAYSNC@xlmain8.hlp>LangRef
4 COUPNCD Worksheet Function=xlfctCOUPNCD@xlmain8.hlp>LangRef
4 COUPNUM Worksheet Function=xlfctCOUPNUM@xlmain8.hlp>LangRef
4 COUPPCD Worksheet Function=xlfctCOUPPCD@xlmain8.hlp>LangRef
4 CUMIPMT Worksheet Function=xlfctCUMIPMT@xlmain8.hlp>LangRef
4 CUMPRINC Worksheet Function=xlfctCUMPRINC@xlmain8.hlp>LangRef
4 DB Worksheet Function=xlfctDB@xlmain8.hlp>LangRef
4 DDB Worksheet Function=xlfctDDB@xlmain8.hlp>LangRef
4 DISC Worksheet Function=xlfctDISC@xlmain8.hlp>LangRef
4 DOLLARDE Worksheet Function=xlfctDOLLARDE@xlmain8.hlp>LangRef
4 DOLLARFR Worksheet Function=xlfctDOLLARFR@xlmain8.hlp>LangRef
4 DURATION Worksheet Function=xlfctDURATION@xlmain8.hlp>LangRef
4 EFFECT Worksheet Function=xlfctEFFECT@xlmain8.hlp>LangRef
4 FV Worksheet Function=xlfctFV@xlmain8.hlp>LangRef
4 FVSCHEDULE Worksheet Function=xlfctFVSCHEDULE@xlmain8.hlp>LangRef
4 INTRATE Worksheet Function=xlfctINTRATE@xlmain8.hlp>LangRef
4 IPMT Worksheet Function=xlfctIPMT@xlmain8.hlp>LangRef
4 IRR Worksheet Function=xlfctIRR@xlmain8.hlp>LangRef
4 MDURATION Worksheet Function=xlfctMDURATION@xlmain8.hlp>LangRef
4 MIRR Worksheet Function=xlfctMIRR@xlmain8.hlp>LangRef
4 NOMINAL Worksheet Function=xlfctNOMINAL@xlmain8.hlp>LangRef
4 NPER Worksheet Function=xlfctNPER@xlmain8.hlp>LangRef
4 NPV Worksheet Function=xlfctNPV@xlmain8.hlp>LangRef
4 ODDFPRICE Worksheet Function=xlfctODDFPRICE@xlmain8.hlp>LangRef
4 ODDFYIELD Worksheet Function=xlfctODDFYIELD@xlmain8.hlp>LangRef
4 ODDLPRICE Worksheet Function=xlfctODDLPRICE@xlmain8.hlp>LangRef
4 ODDLYIELD Worksheet Function=xlfctODDLYIELD@xlmain8.hlp>LangRef
4 PMT Worksheet Function=xlfctPMT@xlmain8.hlp>LangRef
4 PPMT Worksheet Function=xlfctPPMT@xlmain8.hlp>LangRef
4 PRICE Worksheet Function=xlfctPRICE@xlmain8.hlp>LangRef
4 PRICEDISC Worksheet Function=xlfctPRICEDISC@xlmain8.hlp>LangRef
4 PRICEMAT Worksheet Function=xlfctPRICEMAT@xlmain8.hlp>LangRef
4 PV Worksheet Function=xlfctPV@xlmain8.hlp>LangRef
4 RATE Worksheet Function=xlfctRATE@xlmain8.hlp>LangRef
4 RECEIVED Worksheet Function=xlfctRECEIVED@xlmain8.hlp>LangRef
4 SLN Worksheet Function=xlfctSLN@xlmain8.hlp>LangRef
4 SYD Worksheet Function=xlfctSYD@xlmain8.hlp>LangRef
4 TBILLEQ Worksheet Function=xlfctTBILLEQ@xlmain8.hlp>LangRef
4 TBILLPRICE Worksheet Function=xlfctTBILLPRICE@xlmain8.hlp>LangRef
4 TBILLYIELD Worksheet Function=xlfctTBILLYIELD@xlmain8.hlp>LangRef
4 VDB Worksheet Function=xlfctVDB@xlmain8.hlp>LangRef
4 XIRR Worksheet Function=xlfctXIRR@xlmain8.hlp>LangRef
4 XNPV Worksheet Function=xlfctXNPV@xlmain8.hlp>LangRef
4 YIELD Worksheet Function=xlfctYIELD@xlmain8.hlp>LangRef
4 YIELDDISC Worksheet Function=xlfctYIELDDISC@xlmain8.hlp>LangRef
4 YIELDMAT Worksheet Function=xlfctYIELDMAT@xlmain8.hlp>LangRef
3 Information Functions
4 CELL Worksheet Function=xlfctCELL@xlmain8.hlp>LangRef
4 COUNTBLANK Worksheet Function=xlfctCOUNTBLANK@xlmain8.hlp>LangRef
4 ERROR.TYPE Worksheet Function=xlfctERRORTYPE@xlmain8.hlp>LangRef
4 INFO Worksheet Function=xlfctINFO@xlmain8.hlp>LangRef
4 IS Functions=xlfctISFunctions@xlmain8.hlp>LangRef
4 ISEVEN Worksheet Function=xlfctISEVEN@xlmain8.hlp>LangRef
4 ISODD Worksheet Function=xlfctISODD@xlmain8.hlp>LangRef
4 N Worksheet Function=xlfctN@xlmain8.hlp>LangRef
4 NA Worksheet Function=xlfctNA@xlmain8.hlp>LangRef
4 TYPE Worksheet Function=xlfctTYPE@xlmain8.hlp>LangRef
3 Logical Functions
4 AND Worksheet Function=xlfctAND@xlmain8.hlp>LangRef
4 FALSE Worksheet Function=xlfctFALSE@xlmain8.hlp>LangRef
4 IF Worksheet Function=xlfctIF@xlmain8.hlp>LangRef
4 NOT Worksheet Function=xlfctNOT@xlmain8.hlp>LangRef
4 OR Worksheet Function=xlfctOR@xlmain8.hlp>LangRef
4 TRUE Worksheet Function=xlfctTRUE@xlmain8.hlp>LangRef
3 Lookup and Reference Functions
4 ADDRESS Worksheet Function=xlfctADDRESS@xlmain8.hlp>LangRef
4 AREAS Worksheet Function=xlfctAREAS@xlmain8.hlp>LangRef
4 CHOOSE Worksheet Function=xlfctCHOOSE@xlmain8.hlp>LangRef
4 COLUMN Worksheet Function=xlfctCOLUMN@xlmain8.hlp>LangRef
4 COLUMNS Worksheet Function=xlfctCOLUMNS@xlmain8.hlp>LangRef
4 HLOOKUP Worksheet Function=xlfctHLOOKUP@xlmain8.hlp>LangRef
4 HYPERLINK Worksheet Function=xlfctHYPERLINK@xlmain8.hlp>LangRef
4 INDEX Worksheet Function=xlfctINDEX@xlmain8.hlp>LangRef
4 INDIRECT Worksheet Function=xlfctINDIRECT@xlmain8.hlp>LangRef
4 LOOKUP Worksheet Function=xlfctLOOKUP@xlmain8.hlp>LangRef
4 MATCH Worksheet Function=xlfctMATCH@xlmain8.hlp>LangRef
4 OFFSET Worksheet Function=xlfctOFFSET@xlmain8.hlp>LangRef
4 ROW Worksheet Function=xlfctROW@xlmain8.hlp>LangRef
4 ROWS Worksheet Function=xlfctROWS@xlmain8.hlp>LangRef
4 TRANSPOSE Worksheet Function=xlfctTRANSPOSE@xlmain8.hlp>LangRef
4 VLOOKUP Worksheet Function=xlfctVLOOKUP@xlmain8.hlp>LangRef
3 Math and Trigonometry Functions
4 ABS Worksheet Function=xlfctABS@xlmain8.hlp>LangRef
4 ACOS Worksheet Function=xlfctACOS@xlmain8.hlp>LangRef
4 ACOSH Worksheet Function=xlfctACOSH@xlmain8.hlp>LangRef
4 ASIN Worksheet Function=xlfctASIN@xlmain8.hlp>LangRef
4 ASINH Worksheet Function=xlfctASINH@xlmain8.hlp>LangRef
4 ATAN Worksheet Function=xlfctATAN@xlmain8.hlp>LangRef
4 ATAN2 Worksheet Function=xlfctATAN2@xlmain8.hlp>LangRef
4 ATANH Worksheet Function=xlfctATANH@xlmain8.hlp>LangRef
4 CEILING Worksheet Function=xlfctCEILING@xlmain8.hlp>LangRef
4 COMBIN Worksheet Function=xlfctCOMBIN@xlmain8.hlp>LangRef
4 COS Worksheet Function=xlfctCOS@xlmain8.hlp>LangRef
4 COSH Worksheet Function=xlfctCOSH@xlmain8.hlp>LangRef
4 COUNTIF Worksheet Function=xlfctCOUNTIF@xlmain8.hlp>LangRef
4 DEGREES Worksheet Function=xlfctDEGREES@xlmain8.hlp>LangRef
4 EVEN Worksheet Function=xlfctEVEN@xlmain8.hlp>LangRef
4 EXP Worksheet Function=xlfctEXP@xlmain8.hlp>LangRef
4 FACT Worksheet Function=xlfctFACT@xlmain8.hlp>LangRef
4 FACTDOUBLE Worksheet Function=xlfctFACTDOUBLE@xlmain8.hlp>LangRef
4 FLOOR Worksheet Function=xlfctFLOOR@xlmain8.hlp>LangRef
4 GCD Worksheet Function=xlfctGCD@xlmain8.hlp>LangRef
4 INT Worksheet Function=xlfctINT@xlmain8.hlp>LangRef
4 LCM Worksheet Function=xlfctLCM@xlmain8.hlp>LangRef
4 LN Worksheet Function=xlfctLN@xlmain8.hlp>LangRef
4 LOG Worksheet Function=xlfctLOG@xlmain8.hlp>LangRef
4 LOG10 Worksheet Function=xlfctLOG10@xlmain8.hlp>LangRef
4 MDETERM Worksheet Function=xlfctMDETERM@xlmain8.hlp>LangRef
4 MINVERSE Worksheet Function=xlfctMINVERSE@xlmain8.hlp>LangRef
4 MMULT Worksheet Function=xlfctMMULT@xlmain8.hlp>LangRef
4 MOD Worksheet Function=xlfctMOD@xlmain8.hlp>LangRef
4 MROUND Worksheet Function=xlfctMROUND@xlmain8.hlp>LangRef
4 MULTINOMIAL Worksheet Function=xlfctMULTINOMIAL@xlmain8.hlp>LangRef
4 ODD Worksheet Function=xlfctODD@xlmain8.hlp>LangRef
4 PI Worksheet Function=xlfctPI@xlmain8.hlp>LangRef
4 POWER Worksheet Function=xlfctPOWER@xlmain8.hlp>LangRef
4 PRODUCT Worksheet Function=xlfctPRODUCT@xlmain8.hlp>LangRef
4 QUOTIENT Worksheet Function=xlfctQUOTIENT@xlmain8.hlp>LangRef
4 RADIANS Worksheet Function=xlfctRADIANS@xlmain8.hlp>LangRef
4 RAND Worksheet Function=xlfctRAND@xlmain8.hlp>LangRef
4 RANDBETWEEN Worksheet Function=xlfctRANDBETWEEN@xlmain8.hlp>LangRef
4 ROMAN Worksheet Function=xlfctROMAN@xlmain8.hlp>LangRef
4 ROUND Worksheet Function=xlfctROUND@xlmain8.hlp>LangRef
4 ROUNDDOWN Worksheet Function=xlfctROUNDDOWN@xlmain8.hlp>LangRef
4 ROUNDUP Worksheet Function=xlfctROUNDUP@xlmain8.hlp>LangRef
4 SERIESSUM Worksheet Function=xlfctSERIESSUM@xlmain8.hlp>LangRef
4 SIGN Worksheet Function=xlfctSIGN@xlmain8.hlp>LangRef
4 SIN Worksheet Function=xlfctSIN@xlmain8.hlp>LangRef
4 SINH Worksheet Function=xlfctSINH@xlmain8.hlp>LangRef
4 SQRT Worksheet Function=xlfctSQRT@xlmain8.hlp>LangRef
4 SQRTPI Worksheet Function=xlfctSQRTPI@xlmain8.hlp>LangRef
4 SUBTOTAL Worksheet Function=xlfctSUBTOTAL@xlmain8.hlp>LangRef
4 SUM Worksheet Function=xlfctSUM@xlmain8.hlp>LangRef
4 SUMIF Worksheet Function=xlfctSUMIF@xlmain8.hlp>LangRef
4 SUMPRODUCT Worksheet Function=xlfctSUMPRODUCT@xlmain8.hlp>LangRef
4 SUMSQ Worksheet Function=xlfctSUMSQ@xlmain8.hlp>LangRef
4 SUMX2MY2 Worksheet Function=xlfctSUMX2MY2@xlmain8.hlp>LangRef
4 SUMX2PY2 Worksheet Function=xlfctSUMX2PY2@xlmain8.hlp>LangRef
4 SUMXMY2 Worksheet Function=xlfctSUMXMY2@xlmain8.hlp>LangRef
4 TAN Worksheet Function=xlfctTAN@xlmain8.hlp>LangRef
4 TANH Worksheet Function=xlfctTANH@xlmain8.hlp>LangRef
4 TRUNC Worksheet Function=xlfctTRUNC@xlmain8.hlp>LangRef
3 Statistical Functions
4 AVEDEV Worksheet Function=xlfctAVEDEV@xlmain8.hlp>LangRef
4 AVERAGE Worksheet Function=xlfctAVERAGE@xlmain8.hlp>LangRef
4 AVERAGEA Worksheet Function=xlfctAveragea@xlmain8.hlp>LangRef
4 BETADIST Worksheet Function=xlfctBETADIST@xlmain8.hlp>LangRef
4 BETAINV Worksheet Function=xlfctBETAINV@xlmain8.hlp>LangRef
4 BINOMDIST Worksheet Function=xlfctBINOMDIST@xlmain8.hlp>LangRef
4 CHIDIST Worksheet Function=xlfctCHIDIST@xlmain8.hlp>LangRef
4 CHIINV Worksheet Function=xlfctCHIINV@xlmain8.hlp>LangRef
4 CHITEST Worksheet Function=xlfctCHITEST@xlmain8.hlp>LangRef
4 CONFIDENCE Worksheet Function=xlfctCONFIDENCE@xlmain8.hlp>LangRef
4 CORREL Worksheet Function=xlfctCORREL@xlmain8.hlp>LangRef
4 COUNT Worksheet Function=xlfctCOUNT@xlmain8.hlp>LangRef
4 COUNTA Worksheet Function=xlfctCOUNTA@xlmain8.hlp>LangRef
4 COVAR Worksheet Function=xlfctCOVAR@xlmain8.hlp>LangRef
4 CRITBINOM Worksheet Function=xlfctCRITBINOM@xlmain8.hlp>LangRef
4 DEVSQ Worksheet Function=xlfctDEVSQ@xlmain8.hlp>LangRef
4 EXPONDIST Worksheet Function=xlfctEXPONDIST@xlmain8.hlp>LangRef
4 FDIST Worksheet Function=xlfctFDIST@xlmain8.hlp>LangRef
4 FINV Worksheet Function=xlfctFINV@xlmain8.hlp>LangRef
4 FISHER Worksheet Function=xlfctFISHER@xlmain8.hlp>LangRef
4 FISHERINV Worksheet Function=xlfctFISHERINV@xlmain8.hlp>LangRef
4 FORECAST Worksheet Function=xlfctFORECAST@xlmain8.hlp>LangRef
4 FREQUENCY Worksheet Function=xlfctFREQUENCY@xlmain8.hlp>LangRef
4 FTEST Worksheet Function=xlfctFTEST@xlmain8.hlp>LangRef
4 GAMMADIST Worksheet Function=xlfctGAMMADIST@xlmain8.hlp>LangRef
4 GAMMAINV Worksheet Function=xlfctGAMMAINV@xlmain8.hlp>LangRef
4 GAMMALN Worksheet Function=xlfctGAMMALN@xlmain8.hlp>LangRef
4 GEOMEAN Worksheet Function=xlfctGEOMEAN@xlmain8.hlp>LangRef
4 GROWTH Worksheet Function=xlfctGROWTH@xlmain8.hlp>LangRef
4 HARMEAN Worksheet Function=xlfctHARMEAN@xlmain8.hlp>LangRef
4 HYPGEOMDIST Worksheet Function=xlfctHYPGEOMDIST@xlmain8.hlp>LangRef
4 INTERCEPT Worksheet Function=xlfctINTERCEPT@xlmain8.hlp>LangRef
4 KURT Worksheet Function=xlfctKURT@xlmain8.hlp>LangRef
4 LARGE Worksheet Function=xlfctLARGE@xlmain8.hlp>LangRef
4 LINEST Worksheet Function=xlfctLINEST@xlmain8.hlp>LangRef
4 LOGEST Worksheet Function=xlfctLOGEST@xlmain8.hlp>LangRef
4 LOGINV Worksheet Function=xlfctLOGINV@xlmain8.hlp>LangRef
4 LOGNORMDIST Worksheet Function=xlfctLOGNORMDIST@xlmain8.hlp>LangRef
4 MAX Worksheet Function=xlfctMAX@xlmain8.hlp>LangRef
4 MAXA Worksheet Function=xlfctMAXA@xlmain8.hlp>LangRef
4 MEDIAN Worksheet Function=xlfctMEDIAN@xlmain8.hlp>LangRef
4 MIN Worksheet Function=xlfctMIN@xlmain8.hlp>LangRef
4 MINA Worksheet Function=xlfctMINA@xlmain8.hlp>LangRef
4 MODE Worksheet Function=xlfctMODE@xlmain8.hlp>LangRef
4 NEGBINOMDIST Worksheet Function=xlfctNEGBINOMDIST@xlmain8.hlp>LangRef
4 NORMDIST Worksheet Function=xlfctNORMDIST@xlmain8.hlp>LangRef
4 NORMINV Worksheet Function=xlfctNORMINV@xlmain8.hlp>LangRef
4 NORMSDIST Worksheet Function=xlfctNORMSDIST@xlmain8.hlp>LangRef
4 NORMSINV Worksheet Function=xlfctNORMSINV@xlmain8.hlp>LangRef
4 PEARSON Worksheet Function=xlfctPEARSON@xlmain8.hlp>LangRef
4 PERCENTILE Worksheet Function=xlfctPERCENTILE@xlmain8.hlp>LangRef
4 PERCENTRANK Worksheet Function=xlfctPERCENTRANK@xlmain8.hlp>LangRef
4 PERMUT Worksheet Function=xlfctPERMUT@xlmain8.hlp>LangRef
4 POISSON Worksheet Function=xlfctPOISSON@xlmain8.hlp>LangRef
4 PROB Worksheet Function=xlfctPROB@xlmain8.hlp>LangRef
4 QUARTILE Worksheet Function=xlfctQUARTILE@xlmain8.hlp>LangRef
4 RANK Worksheet Function=xlfctRANK@xlmain8.hlp>LangRef
4 RSQ Worksheet Function=xlfctRSQ@xlmain8.hlp>LangRef
4 SKEW Worksheet Function=xlfctSKEW@xlmain8.hlp>LangRef
4 SLOPE Worksheet Function=xlfctSLOPE@xlmain8.hlp>LangRef
4 SMALL Worksheet Function=xlfctSMALL@xlmain8.hlp>LangRef
4 STANDARDIZE Worksheet Function=xlfctSTANDARDIZE@xlmain8.hlp>LangRef
4 STDEV Worksheet Function=xlfctSTDEV@xlmain8.hlp>LangRef
4 STDEVA Worksheet Function=xlfctSTDEVA@xlmain8.hlp>LangRef
4 STDEVP Worksheet Function=xlfctSTDEVP@xlmain8.hlp>LangRef
4 STDEVPA Worksheet Function=xlfctSTDEVPA@xlmain8.hlp>LangRef
4 STEYX Worksheet Function=xlfctSTEYX@xlmain8.hlp>LangRef
4 TDIST Worksheet Function=xlfctTDIST@xlmain8.hlp>LangRef
4 TINV Worksheet Function=xlfctTINV@xlmain8.hlp>LangRef
4 TREND Worksheet Function=xlfctTREND@xlmain8.hlp>LangRef
4 TRIMMEAN Worksheet Function=xlfctTRIMMEAN@xlmain8.hlp>LangRef
4 TTEST Worksheet Function=xlfctTTEST@xlmain8.hlp>LangRef
4 VAR Worksheet Function=xlfctVAR@xlmain8.hlp>LangRef
4 VARA Worksheet Function=xlfctVARA@xlmain8.hlp>LangRef
4 VARP Worksheet Function=xlfctVARP@xlmain8.hlp>LangRef
4 VARPA Worksheet Function=xlfctVARPA@xlmain8.hlp>LangRef
4 WEIBULL Worksheet Function=xlfctWEIBULL@xlmain8.hlp>LangRef
4 ZTEST Worksheet Function=xlfctZTEST@xlmain8.hlp>LangRef
3 Text Functions
4 CHAR Worksheet Function=xlfctCHAR@xlmain8.hlp>LangRef
4 CLEAN Worksheet Function=xlfctCLEAN@xlmain8.hlp>LangRef
4 CODE Worksheet Function=xlfctCODE@xlmain8.hlp>LangRef
4 CONCATENATE Worksheet Function=xlfctCONCATENATE@xlmain8.hlp>LangRef
4 DOLLAR Worksheet Function=xlfctDOLLAR@xlmain8.hlp>LangRef
4 EXACT Worksheet Function=xlfctEXACT@xlmain8.hlp>LangRef
4 FIND Worksheet Function=xlfctFIND@xlmain8.hlp>LangRef
4 FIXED Worksheet Function=xlfctFIXED@xlmain8.hlp>LangRef
4 LEFT Worksheet Function=xlfctLEFT@xlmain8.hlp>LangRef
4 LEN Worksheet Function=xlfctLEN@xlmain8.hlp>LangRef
4 LOWER Worksheet Function=xlfctLOWER@xlmain8.hlp>LangRef
4 MID Worksheet Function=xlfctMID@xlmain8.hlp>LangRef
4 PROPER Worksheet Function=xlfctPROPER@xlmain8.hlp>LangRef
4 REPLACE Worksheet Function=xlfctREPLACE@xlmain8.hlp>LangRef
4 REPT Worksheet Function=xlfctREPT@xlmain8.hlp>LangRef
4 RIGHT Worksheet Function=xlfctRIGHT@xlmain8.hlp>LangRef
4 SEARCH Worksheet Function=xlfctSEARCH@xlmain8.hlp>LangRef
4 SUBSTITUTE Worksheet Function=xlfctSUBSTITUTE@xlmain8.hlp>LangRef
4 T Worksheet Function=xlfctT@xlmain8.hlp>LangRef
4 TEXT Worksheet Function=xlfctTEXT@xlmain8.hlp>LangRef
4 TRIM Worksheet Function=xlfctTRIM@xlmain8.hlp>LangRef
4 UPPER Worksheet Function=xlfctUPPER@xlmain8.hlp>LangRef
4 VALUE Worksheet Function=xlfctVALUE@xlmain8.hlp>LangRef
2 Auditing Workbooks
3 About examining the structure of formulas=xllrgAboutExaminingStructureOfFormulas@xlmain8.hlp>LgCard
3 Locate cells referenced by formulas or cells that depend on values in other cells=xldecLocateCellsThatProvideDataToCellsOrDependOnValuesInOtherCells@xlmain8.hlp>Ref
3 Remove one or more levels of tracer arrows=xlhowRemoveIndividualTracerArrows@xlmain8.hlp>HowTo
3 Locate cells that create a circular reference=xlhowIdentifyWorkWithCellsThatCreateCircularReference@xlmain8.hlp>HowTo
3 Locate cells that don't match the value in the active cell in a row or column=xlhowFindCellsThatDontFitThePatternInARowOrColumn@xlmain8.hlp>HowTo
3 Identify incorrect values in cells=xlhowShowOrHideCirclesAroundInvalidEntriesInCells@xlmain8.hlp>HowTo
3 Troubleshoot auditing a worksheet=xlTBSTroubleshootAuditingAndAddingCommentsToAWorksheet@xlmain8.hlp>Ref
1 Working with Charts
2 Creating a Chart
3 Create a chart=xldecCreateAChart@xlmain8.hlp>Ref
3 Create a default chart in one step=xlhowCreateChartUsingDefaultChartType@xlmain8.hlp>HowTo
3 How Microsoft Excel represents worksheet data in a chart=xllrgHowWorksheetDataIsRepresentedInChart@xlmain8.hlp>LgCard
3 Troubleshoot charts=xltbsTroubleshootingFormattingAChart@xlmain8.hlp>Ref
2 Adding and Changing Text and Data in a Chart
3 Add data to a chart=xldecAddAndDeleteChartData@xlmain8.hlp>Ref
3 Change the cell range used to create a chart=xldccModifyDataRangeOrSeriesDefinition@xlmain8.hlp>HowTo
3 About preventing changes to a chart=xlconPreventingChangesToAChart@xlmain8.hlp>Ref
3 Add a text box to a chart=cohowAddUnattachedText@xlmain8.hlp>HowTo
3 Change chart labels, titles, and other text=xlhowChangeChartLabelsTitlesOtherText@xlmain8.hlp>Ref
3 Change the points plotted in a pie of pie or bar of pie chart=xlhowChangePointsPlottedInPieOfPieOrBarOfPieChart@xlmain8.hlp>HowTo
3 Change the way data is plotted=xldecChangeTheWayYourDataIsPlotted@xlmain8.hlp>Ref
3 Change values in a chart=xlhowChangeDataPointValuesInAWorksheetCell@xlmain8.hlp>HowTo
3 Change values in a chart by dragging data markers and using goal seeking=xlhowChangeDataPointValuesUsingGoalSeeking@xlmain8.hlp>HowTo
3 Delete a data series=xlhowDeleteDataSeriesOrPoints@xlmain8.hlp>HowTo
3 Edit chart and axis titles=xlhowEditChartAxisTitles@xlmain8.hlp>HowTo
3 Link a chart title or text box to a worksheet cell=xlhowLinkChartTitlesAndTextBoxesToAWorksheetCell@xlmain8.hlp>HowTo
3 Reestablish links between data labels and worksheet cells=xlhowRelinkTextInAChart@xlmain8.hlp>HowTo
3 Show only visible worksheet data in a chart=xlhowCreateAChartFromVisibleWorksheetData@xlmain8.hlp>HowTo
2 Changing the Display, View, or Placement of a Chart
3 About time-scale axes=xlconTipsForUsingTimescaleAxes@xlmain8.hlp>Ref
3 Change an embedded chart to a chart sheet and vice versa=xlhowChangeEmbeddedChartToChartSheetViceVersa@xlmain8.hlp>HowTo
3 Change the display of chart labels, data tables, legends, gridlines, or axes=xldecChangeDisplayOptionsInChart@xlmain8.hlp>Ref
3 Delete data labels, titles, or legends on a chart=cohowDeleteDataLabelsTitlesLegendsOrGridlines@xlmain8.hlp>HowTo
3 Display or hide information about chart items=xlhowControlDisplayOfChartTips@xlmain8.hlp>HowTo
3 Size and set up a chart for printing=xlhowSizeAndSetUpAChartSheetForPrinting@xlmain8.hlp>HowTo
3 Zoom or size the display of a chart sheet=xlhowSizeAChartSheetWithTheWindow@xlmain8.hlp>HowTo
3 View an embedded chart in its own window=xlhowEditEmbeddedChartInItsOwnWindow@xlmain8.hlp>HowTo
2 Changing the Type of a Chart
3 Select a different chart type=xlnschowChangeTheChartType@xlmain8.hlp>HowTo
3 Examples of chart types=xlconColumnChartExample@xlmain8.hlp>LgCard
3 Combination charts for showing mixed data=xllrgCombinationChartsSecondaryAxes@xlmain8.hlp>LgCard
3 Custom chart types=xlconExplanationOfCustomChartTypes@xlmain8.hlp>Ref
3 Save a custom chart type to apply to other charts=xlhowAddOrDeleteCustomChartAutoFormats@xlmain8.hlp>HowTo
3 Share a custom chart type with other users=xlhowShareCustomChartAutoFormatsWithOtherUsers@xlmain8.hlp>HowTo
3 Delete a user-defined custom chart type=xlhowDeleteACustomChartAutoFormat@xlmain8.hlp>HowTo
3 Change the default chart type=xlhowChangeTheDefaultChartFormat@xlmain8.hlp>Ref
2 Formatting Data Markers, Labels, and Other Chart Items
3 About formatting charts=xllrgAboutFormattingItemsInCharts@xlmain8.hlp>LgCard
3 Ways to select chart items=xlhowWaysToSelectFormatChartItems@xlmain8.hlp>Ref
3 Move and resize chart items by using the mouse=xldecMoveSelectAndSizeChartsAndChartItems@xlmain8.hlp>HowTo
3 Change colors, patterns, lines, fills, and borders in charts=xlhowApplyColorsPatternsAndBordersToChartItems@xlmain8.hlp>HowTo
3 Change the size, color, or shape of line or xy (scatter) chart markers=xlhowChangeSizeOfLineChartMarkers@xlmain8.hlp>HowTo
3 Change colors in a surface chart=cohowFormat3DSurfaceChartLevels@xlmain8.hlp>HowTo
3 Vary colors in the same data series=xlhowFormatDataMarkers@xlmain8.hlp>HowTo
3 Add a picture to a chart item=xlhowCreateAndFormatPictureMarkers@xlmain8.hlp>HowTo
3 Clear a picture or fill effect from a data series=xlhowClearPictureOrFillEffectFromDataSeries@xlmain8.hlp>HowTo
3 Clear a picture or fill effect from a chart item=xlhowClearPictureOrFillEffectFromChartItem@xlmain8.hlp>HowTo
3 Change the font and size of text in a chart=cohowChangeTheFontAndAlignmentOfChartText@xlmain8.hlp>HowTo
3 Align text in chart titles and text boxes=xlhowAlignTextInChartTitlesTextBoxes@xlmain8.hlp>HowTo
3 Rotate text in a chart title or along an axis=xlhowRotateAlignTextInChart@xlmain8.hlp>HowTo
3 Change the position of data labels automatically=xlhowRepositionDataLabelsAutomatically@xlmain8.hlp>HowTo
3 Change number formats in charts=xlhowChangeNumberFormatsForChartValues@xlmain8.hlp>HowTo
3 Reestablish links between number formats used on a worksheet and a related chart=grhowReestablishLinksBetweenNumberFormatsInDatasheetChart@xlmain8.hlp>HowTo
3 Overlap or space data markers in bar and column charts=xlhowArrangeAndSpaceDataMarkersInBarAndColumnCharts@xlmain8.hlp>HowTo
3 Add up-down bars and drop, series, and high-low lines to charts=xlhowUseSpecialLinesAndBarsToEmphasizeData@xlmain8.hlp>HowTo
3 Change the scale of the value axis=xlhowChangeTheScaleOfAxes@xlmain8.hlp>HowTo
3 Change the spacing of tick marks and labels on the category axis=xlhowChangeTheCategoryOrSeriesAxisScale@xlmain8.hlp>HowTo
3 Change tick mark appearance and label placement on an axis=xldecModifyChartAxes@xlmain8.hlp>HowTo
3 Pull out slices in pie and doughnut charts=xlhowFormatPieAndDoughnutSlices@xlmain8.hlp>HowTo
3 Rotate the position of the slices in a doughnut or pie chart=xlhowChangeTheAngleOfTheFirstDoughnutOrPieSlice@xlmain8.hlp>HowTo
3 Change the size of the pie-of-pie or bar-of-pie plot area=xlhowChangeSizeOfPieOfPieOrBarOfPiePlotArea@xlmain8.hlp>HowTo
3 Change the hole size in a doughnut chart=xlhowChangeTheDoughnutHoleSize@xlmain8.hlp>HowTo
3 Smooth the angles of line charts=xlhowSmoothTheAnglesOfLineCharts@xlmain8.hlp>HowTo
3 Change the view of a 3-D chart=codecFormat3DCharts@xlmain8.hlp>Ref
2 Using Error Bars and Trendlines
3 Trendlines in charts=xldecAddModifyAndDeleteTrendlinesInAChart@xlmain8.hlp>Ref
3 Add a trendline to a data series=xlhowAddATrendlineToADataSeries@xlmain8.hlp>HowTo
3 Change trendline settings=xlhowModifyTrendlineSettings@xlmain8.hlp>HowTo
3 Delete a trendline=xlhowDeleteATrendline@xlmain8.hlp>HowTo
3 Equations for calculating trendlines=xlrefEquationsForCalculatingTrendlines@xlmain8.hlp>Ref
3 Error bars in charts=xlconErrorBarsInCharts@xlmain8.hlp>Ref
3 Add error bars to a data series=xlhowAddErrorBarsToADataSeries@xlmain8.hlp>HowTo
3 Change error bar settings=xlhowModifyErrorBarSettings@xlmain8.hlp>HowTo
3 Delete error bars=xlhowDeleteErrorBars@xlmain8.hlp>HowTo
3 Equations for calculating the error amount=xlrefEquationsForCalculatingTheErrorAmount@xlmain8.hlp>Ref
1 Displaying Data in a Map
2 About displaying data in a map=xllrgAboutDisplayingDataInMap@xlmain8.hlp>LgCard
2 Guidelines for setting up data to create a map=xlconGuidelinesForSettingUpDataToCreateMap@xlmain8.hlp>Ref
2 Create a map=corefMicrosoftQueryandDataMap@xlmain8.hlp>HowTo
2 Add data to a map=xlhowAddDataToMap@xlmain8.hlp>HowTo
2 Get more help about maps=xlhowGetMoreHelpOnMaps@xlmain8.hlp>HowTo
1 Creating Drawings and Importing Pictures
2 Graphics on worksheets and charts=xllrgAboutGraphics@xlmain8.hlp>LgCard
2 Create pictures of cells, charts, and other objects=xldecCreatePicturesOfCellsAndObjects@xlmain8.hlp>Ref
2 Creating Shapes, Lines, Freeforms, and Other Drawing Objects
3 Show or hide the Drawing toolbar=xltbcShowOrHideDrawingToolbar@xlmain8.hlp>HowTo
3 Add a circle, square, or other AutoShape=esdccAddAutoShape@xlmain8.hlp>HowTo
3 Change the AutoShape type=esdccChangeOneAutoShapeToAnother@xlmain8.hlp>HowTo
3 About freeforms and curves=ppconCustomShapes@xlmain8.hlp>Ref
3 Add a curve=pphowAddCurve@xlmain8.hlp>HowTo
3 Add a freeform object=pphowAddFreeformObject@xlmain8.hlp>HowTo
3 Add a line=pphowAddLine@xlmain8.hlp>HowTo
3 Add or remove arrowheads on lines=pphowAddOrRemoveArrowheads@xlmain8.hlp>HowTo
3 Add or reroute a connector line=ppdecAddOrReshapeConnectorLine@xlmain8.hlp>Ref
3 Display or hide drawing objects and imported graphics=xlhowDisplayOrHideDrawingObjects@xlmain8.hlp>HowTo
3 Save a drawing object style as the default=pphowSaveAnObjectsStyleAsTheDefault@xlmain8.hlp>HowTo
3 Troubleshoot drawing objects=pptbsTroubleshootObjectDrawingAndHandling@xlmain8.hlp>Ref
3 The AutoShape, Text Box, Picture, WordArt, or Object command isn't on the Format menu.=xlrefICantFindTheFormatObjectCommand@xlmain8.hlp>Ref
2 Formatting Drawing Objects
3 Add, change, or remove a fill in a drawing object=pphowAddOrChangeAFill@xlmain8.hlp>Ref
3 Rotate or flip a drawing object=ppconRotatingAndFlippingObjects@xlmain8.hlp>Ref
3 Change the color of a line or border around a drawing object=ppdecChangeTheColorOfALineArcOrBorder@xlmain8.hlp>HowTo
3 Change the shape of a freeform or curve=pphowChangeTheShapeOfACustomShape@xlmain8.hlp>HowTo
3 Change the style of a drawing object line or border=pphowChangeThicknessOfLineOrBorder@xlmain8.hlp>HowTo
3 Make a dashed line or border around a drawing object=pphowMakeDashedLineOrBorder@xlmain8.hlp>HowTo
3 Remove the line or border around a drawing object=pphowRemoveABorderOrLine@xlmain8.hlp>HowTo
3 Resize or crop an object=ppdecResizeObjects@xlmain8.hlp>Ref
3 Add, change, or remove a shadow on a drawing object=pphowAddChangeOrRemoveAnObjectShadow@xlmain8.hlp>Ref
3 Add, change, or remove the 3-D effect of a drawing object=esdecAdd3DEffectToObject@xlmain8.hlp>Ref
3 Troubleshoot adding borders, fills, shadows, and 3-D effects to drawing objects=pptbsTroubleshootAddingBordersFillsAndShadows@xlmain8.hlp>Ref
2 Adding Text or a Special Text Effect
3 Add text to an AutoShape=ppdecAddTextToASlide@xlmain8.hlp>Ref
3 Change the appearance of text in an AutoShape or text box=pphowChangeOneOrMoreAttributesOfTextAtTheSameTime@xlmain8.hlp>HowTo
3 Move a text box=pptbsICantMoveATextObject@xlmain8.hlp>HowTo
3 Set margins and align text that is attached to an AutoShape or text box=ppdecPositionAlignSpaceTextWithinObjects@xlmain8.hlp>Ref
3 Add or edit a special text effect=pphowInsertWordArt@xlmain8.hlp>Ref
3 What happened to WordArt=ppconWhatHappenedToWordArt@xlmain8.hlp>Ref
2 Grouping, Aligning, and Moving Drawing Objects
3 Group, ungroup, and regroup drawing objects=ppconGroupingObjects@xlmain8.hlp>Ref
3 Stack drawing objects=ppconStackingObjects@xlmain8.hlp>HowTo
3 Align and arrange drawing objects=ppdecAlignObjects@xlmain8.hlp>Ref
3 Move a drawing object or set of objects=pphowMoveAnObjectOrSetOfObjects@xlmain8.hlp>HowTo
3 Move, or "nudge," a drawing object in small increments=pphowNudgeAnObjectInSmallIncrements@xlmain8.hlp>HowTo
3 Prevent objects from moving and sizing with cells=xlhowMoveSizeObjectsWithCells@xlmain8.hlp>HowTo
3 Troubleshoot aligning and arranging drawing objects=pptbsTroubleshootAligningArrangingObjects@xlmain8.hlp>Ref
2 Working with Imported Pictures and Clip Art
3 Ways to insert pictures and clip art in a workbook=ppconInsertingPicturesOnSlides@xlmain8.hlp>Ref
3 Insert and edit a picture or clip art=pphowInsertPicturesIntoAPresentation@xlmain8.hlp>Ref
3 Ungroup and change clip art=xlhowUngroupClipArtToModifyIt@xlmain8.hlp>HowTo
3 Graphics file types Microsoft Excel can use=worefListFilesOfTypeInsertmenuPicture@xlmain8.hlp>Ref
3 Troubleshoot pictures and imported graphics=ppconSolvingGraphicsFilterProblems@xlmain8.hlp>Ref
2 Creating a Movie by Using Microsoft Camcorder
3 Microsoft Camcorder=ofconMicrosoftGDICap@xlmain8.hlp>Ref
1 Managing Lists
3 About using a list as a database=xlconUsingAListAsADatabase@xlmain8.hlp>Ref
3 Guidelines for creating a list on a worksheet=xlconGuidelinesForCreatingAListOnAWorksheet@xlmain8.hlp>Ref
2 Sorting Data in a List
3 Default sort orders=xlrefDefaultSortOrders@xlmain8.hlp>Ref
3 Sort a list=xldecSortAList@xlmain8.hlp>Ref
3 Troubleshoot sorting a list=xltbsTroubleshootSorting@xlmain8.hlp>Ref
2 Finding Rows That Meet Specific Conditions
3 Ways to find values in a list by using filters=xllrgWaysToFindValuesInList@xlmain8.hlp>LgCard
3 Display a subset of rows in a list by using filters=xlhowFilteringAList@xlmain8.hlp>HowTo
3 Display a subset of rows by comparing values=xlhowCreatingACustomFilter@xlmain8.hlp>Ref
3 Remove filters from a list=xldecRemoveAFilterFromAList@xlmain8.hlp>HowTo
3 Automatic filter options=xlrefAutoFilterOptions@xlmain8.hlp>Ref
3 Filter a list by using advanced criteria=xlhowFilterAListUsingComplexCriteria@xlmain8.hlp>HowTo
3 Examples of advanced filter criteria=xlrefExamplesOfCriteriaForAdvancedFilter@xlmain8.hlp>Ref
3 Types of comparison criteria=xlrefTypesOfComparisonCriteria@xlmain8.hlp>Ref
3 Find a value in a list by using the Lookup Wizard=xlhowFindValueInListUsingLookupWizard@xlmain8.hlp>HowTo
2 Using Forms to Enter Data
3 Add to or change a list by using a data form=xldecAddToOrChangeListByUsingDataForm@xlmain8.hlp>Ref
3 Delete a record in a list by using a data form=xlhowDeleteRecordInListByUsingDataForm@xlmain8.hlp>HowTo
3 Find a record in a list by using a data form=xldccFindRecordsInListByUsingDataForm@xlmain8.hlp>HowTo
1 Retrieving Data
2 About using Microsoft Query to retrieve external data=xllrgExampleOfConstructingQuery@xlmain8.hlp>LgCard
2 Databases you can access=xlrefDatabasesYouCanAccessWithMicrosoftQuery@xlmain8.hlp>Ref
2 Troubleshoot retrieving external data=xlhowTroubleshootRetrievingExternalData@xlmain8.hlp>Ref
2 Setting Up Microsoft Query and Data Sources
3 What you need to retrieve external data=xlconWhatYouNeedToConnectToExternalDataSourceUseMicrosoftQuery@xlmain8.hlp>Ref
3 Install Microsoft Query=xlhowSetUpMicrosoftQuery@xlmain8.hlp>HowTo
3 Install an ODBC driver so you can access an external data source=xlhowInstallSupportForExternalDataSource@xlmain8.hlp>HowTo
3 Specify a source to retrieve data from=xlhowSpecifySourceToRetrieveDataFrom@xlmain8.hlp>HowTo
3 I can't create a new data source=qutbcICantSeemToCreateNewDataSource@xlmain8.hlp>Ref
2 Creating and Running Queries
3 Ways to retrieve data from an external database=xldecWaysToRetrieveExternalDataSoThatYouCanAnalyzeItInExcel@xlmain8.hlp>Ref
3 Run a query=xlhowRunExistingQuery@xlmain8.hlp>HowTo
3 Guidelines for constructing a query=xlconConstructingQuerySoThatItReturnsDataYouWant@xlmain8.hlp>Ref
3 Get external data by using the Query Wizard=xlhowGetExternalDataUsingQueryWizard@xlmain8.hlp>HowTo
3 Get external data by using Microsoft Query=xlconGetExternalDataIntoMicrosoftExcelWorksheet@xlmain8.hlp>Ref
3 Get data from a Web source=xlhowGetDataFromInternetSource@xlmain8.hlp>Ref
3 Return only the data in an HTML table or all of the information on a Web page=xlhowReturnDataStoredInHTMLTable@xlmain8.hlp>HowTo
3 Create a template to share external data=quconDistributingReportsThatContainDataFromExternalDatabase@xlmain8.hlp>Ref
3 Create a query that prompts for criteria=quhowWaysToDesignQueryThatPromptsForInformationWhenRun@xlmain8.hlp>Ref
2 Working with External Data on a Worksheet
3 Select where to put an external data range=xlhowSelectWhereToPutExternalDataRange@xlmain8.hlp>HowTo
3 Refresh external data=xlhowUpdateExternalData@xlmain8.hlp>HowTo
3 Control the formatting and layout of an external data range=xldecControlFormattingLayoutOfExternalData@xlmain8.hlp>Ref
3 Control how an external data range is refreshed=xldecControlHowMicrosoftExcelRefreshesExternalData@xlmain8.hlp>Ref
3 Require a password to refresh an external data range=xlhowRequirePasswordToRefreshExternalDataRange@xlmain8.hlp>HowTo
3 Find an external data range on your worksheet=xlhowFindExternalDataRangeOnYourWorksheet@xlmain8.hlp>HowTo
3 Change the query for an external data range=xlrefUseQueryWizardToChangeUnderlyingQuery@xlmain8.hlp>HowTo
3 Change the name of an external data range=xlhowNameExternalDataRange@xlmain8.hlp>HowTo
3 Copy an external data range and its underlying query to another workbook=xlhowCopyExternalDataItsQueryToAnotherWorkbook@xlmain8.hlp>HowTo
3 Remove an external data range from a worksheet=xlhowRemoveExternalDataRangeFromWorksheet@xlmain8.hlp>HowTo
2 Creating Macros to Retrieve External Data
3 What you need to create Visual Basic macros that retrieve external data=xlhowHowMacrosCanAccessListsExternalDatabases@xlmain8.hlp>Ref
3 Install Data Access Objects (DAO) for Visual Basic=xlhowInstallDataAccessObjectsForVisualBasic@xlmain8.hlp>HowTo
3 Use Dynamic Data Exchange (DDE) with Microsoft Query=xlconUsingDynamicDataExchangeWithMicrosoftQuery@xlmain8.hlp>Ref
1 Summarizing Data in Lists and Tables
2 Ways to summarize data=xldecSummarizeData@xlmain8.hlp>Ref
2 Summarize values in a list=xldecSummarizeValuesInListOrDatabase@xlmain8.hlp>Ref
2 Inserting Summary Totals in a List
3 Subtotals: How Microsoft Excel summarizes data=xllrgxsummarzSubtotalsHowMicrosoftExcelSummarizesData@xlmain8.hlp>LgCard
3 Insert subtotal values in a list=xldecSubtotalValuesInList@xlmain8.hlp>Ref
3 Remove subtotals from a list=xlhowRemoveSubtotalsFromList@xlmain8.hlp>HowTo
3 How Microsoft Excel calculates subtotal and grand total values=xlconHowSubtotalAndGrandTotalValuesAreCalculated@xlmain8.hlp>Ref
2 Outlining a Worksheet
3 Summarize data by using subtotals and outlines=xldecSummarizedatabyoutliningaworksheet@xlmain8.hlp>Ref
3 Show or hide detail data in an outline=xlhowShoworhidedetaildatainanoutline@xlmain8.hlp>Ref
3 Display or hide outline symbols without removing the outline=xlhowDisplayorhideoutlinesymbols@xlmain8.hlp>HowTo
3 Ungroup rows or columns in an outline=xlhowUngrouprowsorcolumns@xlmain8.hlp>HowTo
3 Remove an entire outline=xlhowRemoveanoutline@xlmain8.hlp>HowTo
3 Troubleshoot outlining a worksheet=xlhowTroubleshootoutliningaworksheet@xlmain8.hlp>Ref
2 Consolidating Data from Multiple Tables
3 Data consolidation by using 3-D references=xllrgConsolidateDataByUsing3DReferences@xlmain8.hlp>LgCard
3 Consolidate data=xlhowConsolidateData@xlmain8.hlp>Ref
3 Guidelines for specifying source areas for a consolidation=xlconChoosingTheSourceAreaForMyConsolidationTable@xlmain8.hlp>Ref
3 Change a data consolidation=xldecChangeADataConsolidationTable@xlmain8.hlp>Ref
3 Troubleshoot data consolidation=xlhowTroubleshootDataConsolidation@xlmain8.hlp>Ref
2 Summarizing Data by Using a PivotTable
3 PivotTables: Analyzing data interactively=xllrgPivotTablesanalyzingDataInteractively@xlmain8.hlp>LgCard
3 Create a PivotTable=xlnschowPivotTableCommandDataMenu@xlmain8.hlp>HowTo
2 Summarizing Data in a Microsoft Access Report
3 Create a Microsoft Access report based on data from a Microsoft Excel list=xlhowCreatingAReportWithAccessReportWizardInMicrosoftExcel@xlmain8.hlp>HowTo
3 Update a Microsoft Access report when the associated Microsoft Excel data changes=xlhowModifyingAnExistingReport@xlmain8.hlp>HowTo
1 Analyzing Data with PivotTables
3 PivotTables: Analyzing data interactively=xllrgPivotTablesanalyzingDataInteractively@xlmain8.hlp>LgCard
3 Parts of a PivotTable=xllrgPartsOfPivotTable@xlmain8.hlp>LgCard
3 Select data in a PivotTable=xlconExamplesOfHowToSelectDataInPivotTables@xlmain8.hlp>Ref
2 Troubleshoot PivotTables=xlcmdTroubleshootingCustomizeAPivotTable@xlmain8.hlp>Ref
2 Troubleshoot formatting and changing PivotTables=xltbsTroubleshootPivotTableFormatting@xlmain8.hlp>Ref
2 Creating and Deleting a PivotTable
3 Create a PivotTable=xlnschowPivotTableCommandDataMenu@xlmain8.hlp>HowTo
3 Choose a PivotTable data source=xldecChoosePivotTableDataSource@xlmain8.hlp>Ref
3 About creating a PivotTable from a Microsoft Excel list or database=xlhowCreateAPivotTableFromAMicrosoftExcelListOrDatabase@xlmain8.hlp>Ref
3 About creating a PivotTable from another PivotTable=xlhowCreateAPivotTableFromAnotherPivotTable@xlmain8.hlp>Ref
3 About creating a PivotTable to consolidate multiple data ranges=xlhowCreateAPivotTableByCombiningDataFromMultipleConsolidationRanges@xlmain8.hlp>Ref
3 About creating a PivotTable from an external data source=xlhowCreateAPivotTableFromAnExternalDataSource@xlmain8.hlp>Ref
3 Delete a PivotTable=xlhowDeleteAPivotTable@xlmain8.hlp>HowTo
3 Convert a Microsoft Excel version 4.0 crosstab table to a PivotTable=xlhowConvertAMicrosoftExcelVersion40CrosstabTableToAPivotTable@xlmain8.hlp>HowTo
2 Changing the Layout and Format
3 Change the layout of a PivotTable=xltbsChangeTheLayoutOfAPivotTable@xlmain8.hlp>Ref
3 Add or remove a field in a PivotTable=xlhowAddAFieldToAPivotTable@xlmain8.hlp>HowTo
3 Format a PivotTable=xlhowFormatPivotTable@xlmain8.hlp>HowTo
3 Work with PivotTable page fields=xldecUsePageFieldsInAPivotTable@xlmain8.hlp>Ref
3 Group and ungroup data in a PivotTable=xldecGroupItemsInAPivotTable@xlmain8.hlp>Ref
3 Control the amount of detail that appears in a PivotTable=xldecShowOrHidePivotTableDetail@xlmain8.hlp>Ref
3 Prevent access to PivotTable detail=xllrgPreventAccessToPivotTableDetail@xlmain8.hlp>HowTo
3 Sort data in a PivotTable=xldecSortItemsInAPivotTable@xlmain8.hlp>Ref
3 Change the number format for the data area of a PivotTable=xlhowChangeTheNumberFormatForTheDataAreaOfAPivotTable@xlmain8.hlp>HowTo
3 Change how a PivotTable displays errors and empty cells=xlhowChangeHowErrorsEmptyCellsZeroValuesAreShownInPivotTable@xlmain8.hlp>HowTo
3 Rename a PivotTable field or item=xlhowChangeTheNameOfAPivotTableField@xlmain8.hlp>HowTo
2 Summarizing with Totals, Formulas, and Charts
3 Use totals and subtotals in a PivotTable=xldecUseTotalsSubtotalsInPivotTable@xlmain8.hlp>Ref
3 Summarize and calculate data in a PivotTable=xldecUseSummaryFunctionsInAPivotTable@xlmain8.hlp>Ref
3 Summary functions for data analysis=xlrefPivotTableFieldCommandForDataFieldsDataMenu@xlmain8.hlp>Ref
3 Custom calculations for PivotTable data fields=xlcmdUsingCustomCalculationsInAPivotTable@xlmain8.hlp>Ref
3 Create a calculated field in a PivotTable=xlhowCreateCalculatedPivotTableFieldOrItem@xlmain8.hlp>HowTo
3 Create a calculated item in a PivotTable=xlhowCreateCalculatedPivotTableItem@xlmain8.hlp>HowTo
3 Syntax for calculated field and item formulas in PivotTables=xlrefCalculatedFieldItemSyntax@xlmain8.hlp>Ref
3 Change the formula for a calculated field in a PivotTable=xlhowEditFormulaForCalculatedPivotTableFieldOrItem@xlmain8.hlp>HowTo
3 Change the formula for a calculated item in a PivotTable=xltbcChangeFormulaForCalculatedPivotTableItem@xlmain8.hlp>HowTo
3 Delete a calculated field in a PivotTable=xlhowDeleteCalculatedPivotTableField@xlmain8.hlp>HowTo
3 Delete a calculated item in a PivotTable=xlhowDeleteCalculatedPivotTableItem@xlmain8.hlp>HowTo
3 Change the order of calculation for calculated items in a PivotTable=xlhowChangeOrderOfCalculationForCalculatedPivotTableFieldsItems@xlmain8.hlp>HowTo
3 Display a list of the formulas in a PivotTable=xlhowDisplayListOfFormulasInPivotTable@xlmain8.hlp>HowTo
3 How Microsoft Excel calculates PivotTable data=xldecChangeHowPivotTableDataIsCalculated@xlmain8.hlp>Ref
3 Use PivotTable data in a formula outside the PivotTable=xlhowUsePivotTableDataInFormulaOutsidePivotTable@xlmain8.hlp>HowTo
3 Create a chart from a PivotTable=xldecCreateChartFromPivotTable@xlmain8.hlp>Ref
2 Working with External Data
3 About creating a PivotTable from an external data source=xlhowCreateAPivotTableFromAnExternalDataSource@xlmain8.hlp>Ref
3 Refresh a PivotTable or change its source data=xldecChangeSourceDataForPivotTableOrHowItIsRefreshed@xlmain8.hlp>Ref
3 Change how the query for a PivotTable is run=xlhowRunQueryForPivotTableImmediatelyOrInBackground@xlmain8.hlp>HowTo
3 Save memory by retrieving data for page field items individually or all at once=xlhowMakePivotTablePageFieldServerbasedOrLocal>HowTo
3 Prevent PivotTable data from being refreshed when the workbook file is opened=xlhowPreventRefreshOfPivotTable@xlmain8.hlp>HowTo
1 Performing What-If Analysis on Worksheet Data
3 Ways to forecast values with what-if analysis=xllrgXWhatIfDataTables@xlmain8.hlp>LgCard
3 Troubleshoot what-if analysis=xltbsTroubleshootWhatIfProblems@xlmain8.hlp>Ref
3 Project linear and growth trends=xldecProjectFutureValuesPerformRegressionAnalysis@xlmain8.hlp>Ref
2 Projecting Values by Using a Data Table
3 Create a one-variable data table=xlhowCreateOnevariableDataTable@xlmain8.hlp>HowTo
3 Add a formula to an existing one-variable data table=xlhowAddaformulatoanexistingdatatable@xlmain8.hlp>HowTo
3 Convert resulting data table values to constant values=xlhowConvertresultingdatatablevaluestoconstantvalues@xlmain8.hlp>HowTo
3 Create a two-variable data table=xlhowFillinaTwoVariableDataTable@xlmain8.hlp>HowTo
3 Clear resulting values from a data table=xlhowClearresultingvaluesfromadatatable@xlmain8.hlp>HowTo
3 Clear an entire data table=xlhowClearanentiredatatable@xlmain8.hlp>HowTo
2 Solving a One-Variable Problem
3 Find a specific result for a cell by adjusting the value of one other cell=xlhowSeekaspecificsolutiontoaformula@xlmain8.hlp>HowTo
2 Saving Different Solutions to a Problem
3 Create a scenario=xlhowCreateascenario@xlmain8.hlp>HowTo
3 Display a scenario=xlhowDisplayascenario@xlmain8.hlp>HowTo
3 Edit a scenario=xlhowEditascenario@xlmain8.hlp>HowTo
3 Merge scenarios=xlhowMergescenarios@xlmain8.hlp>HowTo
3 Create a scenario summary report=xlhowCreateascenariosummaryreport@xlmain8.hlp>HowTo
3 Prevent changes to a scenario=xlhowProtectascenariofromunwantedchanges@xlmain8.hlp>HowTo
3 Delete a scenario=xlhowDeleteascenario@xlmain8.hlp>HowTo
2 Analyzing Multiple-Variable Problems
3 Define and solve a problem by using Solver=xlhowDefineandsolveaproblemusingSolver@xlmain8.hlp>HowTo
3 Guidelines for designing a model to find values with Solver=xlconGuidelinesForDesigningModelToFindValuesWithSolver@xlmain8.hlp>Ref
3 Install Solver=xlhowInstallSolver@xlmain8.hlp>HowTo
3 Solver sample worksheets=xlconSolverSampleWorksheets@xlmain8.hlp>Ref
3 Load a problem model by using Solver=xlhowLoadaproblemmodelusingSolver@xlmain8.hlp>HowTo
3 Set Solver options=xldecSetSolverOptions@xlmain8.hlp>Ref
3 About solving for a value to maximize another value=xlconSolvingforaValuetoMaximizeAnotherValue@xlmain8.hlp>Ref
3 Step through Solver trial solutions=xlhowStepthroughSolvertrialsolutions@xlmain8.hlp>HowTo
3 Create a report by using Solver=xlhowCreateareportusingSolver@xlmain8.hlp>HowTo
3 Save adjustable cell values in Solver as a scenario=xlhowSavechangingcellvaluesinSolverasascenario@xlmain8.hlp>HowTo
3 Save a problem model by using Solver=xlhowSaveaproblemmodelusingSolver@xlmain8.hlp>HowTo
3 About Solver completion messages=xlrefSolverCompletionMessages@xlmain8.hlp>Ref
3 Algorithm and methods used by Solver=xlrefAlgorithmusedbySolver@xlmain8.hlp>Ref
3 Troubleshoot Solver=xltbsTroubleshootproblemsusingSolver@xlmain8.hlp>Ref
1 Analyzing Statistical Data
3 Ways to analyze statistics=xlconAnalyzingstatistics@xlmain8.hlp>Ref
3 Install and use the Analysis ToolPak=xlhowUsetheAnalysisToolPak@xlmain8.hlp>HowTo
3 Supplemental information about statistical methods and algorithms=xlrefAboutStatisticalMethodsAlgorithms@xlmain8.hlp>Ref
3 Perform an analysis of variance (anova)=xldecPerformAnalysisOfVarianceanova@xlmain8.hlp>Ref
3 Correlation analysis tool and formulas=xlrefCorrelationanalysistool@xlmain8.hlp>Ref
3 Covariance analysis tool and formula=xlrefCovarianceanalysistool@xlmain8.hlp>Ref
3 Descriptive Statistics analysis tool=xlrefDescriptiveStatisticsanalysistool@xlmain8.hlp>Ref
3 Exponential Smoothing analysis tool and formula=xlrefExponentialSmoothinganalysistool@xlmain8.hlp>Ref
3 F-Test: Two-Sample for Variances analysis tool=xlrefFTestTwoSampleForVariancesanalysistool@xlmain8.hlp>Ref
3 Perform a t-Test analysis=xldecPerformTTestAnalysis
3 z-Test: Two-Sample for Means analysis tool=xlrefzTestTwoSampleForMeansanalysistool@xlmain8.hlp>Ref
3 Histogram analysis tool=xlrefHistogramanalysistool@xlmain8.hlp>Ref
3 Moving Average analysis tool and formula=xlrefMovingAverageanalysistool@xlmain8.hlp>Ref
3 Random Number Generation analysis tool=xlrefRandomNumberGenerationanalysistool@xlmain8.hlp>Ref
3 Rank and Percentile analysis tool=xlrefRankAndPercentileanalysistool@xlmain8.hlp>Ref
3 Regression analysis tool=xlrefRegressionanalysistool@xlmain8.hlp>Ref
3 Fourier Analysis tool=xlrefFourierAnalysisanalysistool@xlmain8.hlp>Ref
3 Sampling analysis tool=xlrefSamplinganalysistool@xlmain8.hlp>Ref
3 Data appears only on the first worksheet.=xltbsDataappearsonthefirstworksheetonly
1 Sharing a Workbook with Others
2 Share a workbook with other users=xldecWorkOnShareReviseWorkbooks@xlmain8.hlp>Ref
2 Creating and Managing a Shared Workbook
3 About shared workbooks=xllrgAboutSharingWorkbookWithOtherPeople@xlmain8.hlp>LgCard
3 What you need to know about working in a shared workbook=xlhowWhatYouNeedToKnowBeforeYouWorkWithSharedWorkbook@xlmain8.hlp>Ref
3 Set up a shared workbook=xlhowCreateASharedList@xlmain8.hlp>HowTo
3 Manage conflicting changes to a shared workbook=xldecManageConflictingChangesToSharedWorkbook@xlmain8.hlp>Ref
3 Determine how often to update a shared workbook=xlhowDetermineHowOftenToGetUpdatesToSharedWorkbook@xlmain8.hlp>HowTo
3 Keep personal view and print settings for a shared workbook=xlhowKeepPersonalViewPrintSettingsForSharedWorkbook@xlmain8.hlp>HowTo
3 Limitations of shared workbooks=xlrefListOfFeaturesUnavailableInSharedWorkbooksOrWhenChangeTrackingIsTurnedOn@xlmain8.hlp>Ref
3 Limit what others can see and change in a shared workbook=xlhowLimitAccessToSharedWorkbook@xlmain8.hlp>HowTo
3 Return a protected shared workbook to unrestricted use=xlhowReturnProtectedSharedWorkbookToFullAccess@xlmain8.hlp>HowTo
3 Remove a user from a shared workbook=xlhowDisconnectUserFromSharedWorkbook@xlmain8.hlp>HowTo
3 Remove a workbook from shared use=xlhowEditSharedWorkbookExclusively@xlmain8.hlp>HowTo
2 Merging Workbooks
3 Prepare copies of a workbook to be reviewed and merged=xlhowPrepareCopiesOfWorkbookForReviewMerging@xlmain8.hlp>HowTo
3 Merge changes from multiple copies of the same workbook=xlhowMergeCommentsFromSeveralCopiesOfWorkbook@xlmain8.hlp>HowTo
2 Tracking and Reviewing Changes to a Workbook
3 About adding comments and highlighting changes in a workbook=xllrgAboutWorkingWithCommentsRevisions@xlmain8.hlp>LgCard
3 Maintain the change history for a workbook=xlhowKeepTrackOfChangesToWorkbook  @xlmain8.hlp>HowTo
3 Stop keeping the change history for a workbook=xlhowTurnChangeTrackingOff@xlmain8.hlp>HowTo
3 View information about changes to a workbook=xldecViewChangesToWorkbook@xlmain8.hlp>Ref
3 View the history of all changes to a workbook=xlhowViewCompleteChangeHistoryOfWorkbook@xlmain8.hlp>HowTo
3 Highlight changes as you work=xlhowMarkWorkbookRevisions@xlmain8.hlp>HowTo
3 Review and incorporate changes=xlhowReviewIncorporateRevisions@xlmain8.hlp>HowTo
3 Require that revisions be tracked in a workbook=xlhowAllowOnlyMarkedRevisionsToWorkbook@xlmain8.hlp>HowTo
3 Limitations of change highlighting in Microsoft Excel=xlhowTypesOfRevisionsThatMicrosoftExcelMarksIgnores@xlmain8.hlp>Ref
3 Show or hide change highlighting and details=xlhowShowOrHideRevisionHighlightingDetailsAboutChanges@xlmain8.hlp>HowTo
2 Solving Problems with Sharing, Merging, Revision Highlighting, and Revision History
3 Troubleshoot shared workbooks=xltbsTroubleshootSharedWorkbooks@xlmain8.hlp>Ref
3 Troubleshoot merging workbooks=xltbcTroubleshootMergingWorkbooks@xlmain8.hlp>Ref
3 Troubleshoot change highlighting and the History worksheet=xltbsTroubleshootRevisionHighlighting@xlmain8.hlp>Ref
3 Troubleshoot change history tracking=xltbsTroubleshootRevisionHistoryTracking@xlmain8.hlp>Ref
2 Adding Comments to a Worksheet
3 About adding comments and highlighting changes in a workbook=xllrgAboutWorkingWithCommentsRevisions@xlmain8.hlp>LgCard
3 Add a comment to a cell=xlhowAddATextNoteToACell@xlmain8.hlp>HowTo
3 Change the appearance or position of a comment=xlhowChangeAppearanceOrPositionOfComment@xlmain8.hlp>HowTo
3 Edit a comment=xlhowEditComment@xlmain8.hlp>HowTo
3 Copy only values, formulas, comments, or cell formats=xlhowCopythecellformula@xlmain8.hlp>HowTo
3 Clear contents, formats, or comments from cells=xlhowClearrowsandcolumns@xlmain8.hlp>HowTo
3 Hide or display comments and their indicators=xlhowDisplayOrHideCellNoteIndicators@xlmain8.hlp>HowTo
3 Merge changes from multiple copies of the same workbook=xlhowMergeCommentsFromSeveralCopiesOfWorkbook@xlmain8.hlp>HowTo
3 Review the comments in a workbook=xlhowReviewCommentsInWorkbook@xlmain8.hlp>HowTo
3 Print comments=xldccPrintComments@xlmain8.hlp>HowTo
3 Comments in a PivotTable don't stay with the applicable cells.=xltbsCommentsInPivotTableDontStayInRightCells
2 Protecting a Workbook from Changes
3 Security features in Microsoft Excel=xlrefSecurityFeaturesInMicrosoftExcel@xlmain8.hlp>Ref
3 Control access to workbooks and worksheets=xldecControlChangesToAWorkbook@xlmain8.hlp>Ref
3 Limit what others can see and change in a shared workbook=xlhowLimitAccessToSharedWorkbook@xlmain8.hlp>HowTo
3 Return protected workbooks or worksheets to unrestricted use=xlidxReturnProtectedWorkbooksOrWorksheetsToUnrestrictedUse@xlmain8.hlp>Ref
3 Change or remove a workbook password=xlhowChangeOrDeleteAPassword@xlmain8.hlp>HowTo
3 Troubleshoot security and protection=xltbsTroubleshootSecurityProtection@xlmain8.hlp>Ref
2 Preventing Computer Viruses in Workbooks
3 About viruses and workbook macros=xlmscAboutVirusesWorkbookMacros@xlmain8.hlp>Ref
3 Check workbooks for macros that might contain viruses=xlhowCheckWorkbooksForMacrosThatMightContainViruses@xlmain8.hlp>HowTo
3 Stop checking of workbooks for macros that might contain viruses=xlhowTurnOffCheckingOfWorkbooksForMacrosThatMightContainViruses@xlmain8.hlp>HowTo
1 Validating Cell Entries
2 About defining the valid entries for a cell=xllrgDataValidationHelpingPeopleEnterCorrectData@xlmain8.hlp>LgCard
2 Setting Up Restrictions and Messages
3 Specify the valid entries for cells=xldecRestrictWhatDataIsValidForCell@xlmain8.hlp>Ref
3 Types of data restrictions=xlrefDataValidationTypes@xlmain8.hlp>Ref
3 Display messages that prompt for data or explain incorrect entries=xldecDisplayMessagesPromptingForInputOrExplainingInvalidInput@xlmain8.hlp>Ref
3 Change the definition of valid data or the messages displayed for a cell=xlhowChangeWhatDataIsValidOrMessagesAreDisplayedForCell@xlmain8.hlp>HowTo
3 Copy data restrictions and messages to other cells=xlhowCopyDataValidationRestrictionsMessages@xlmain8.hlp>HowTo
3 Remove data restrictions and messages from a cell=xlhowRemoveDataValidationRestrictionsMessagesFromCell@xlmain8.hlp>HowTo
3 Prevent changes to data restrictions and messages=xlhowPreventChangesToDataValidationRestrictionsMessages@xlmain8.hlp>HowTo
3 Find cells that have data restrictions or messages=xlhowFindCellsThatHaveDataValidationRestrictionsOrMessages@xlmain8.hlp>HowTo
2 Entering Data and Responding to Messages
3 Types of data validation messages=xlhowTypesOfDataValidationMessages@xlmain8.hlp>HowTo
3 Troubleshoot data validation=xltbsTroubleshootDataRestrictionsMessages@xlmain8.hlp>Ref
2 Auditing for Invalid Entries
3 Identify incorrect values in cells=xlhowShowOrHideCirclesAroundInvalidEntriesInCells@xlmain8.hlp>HowTo
3 Hide the circles around incorrect values in cells=xldecHideCirclesAroundIncorrectEntriesInCells@xlmain8.hlp>HowTo
3 Find cells that have data restrictions or messages=xlhowFindCellsThatHaveDataValidationRestrictionsOrMessages@xlmain8.hlp>HowTo
1 Distributing Documents to Others on a Network
2 Give others access to workbooks on my hard disk=ofhowShareFolderWithAnotherPerson@xlmain8.hlp>HowTo
2 Mailing and Routing Workbooks
3 Distribute workbooks to other people=codecSendDocumentsToReviewInElectronicMail@xlmain8.hlp>Ref
3 Create a routing slip=cohowCreateARoutingSlip@xlmain8.hlp>HowTo
3 Edit the routing slip of a routed workbook=cohowEditTheRoutingSlipOfARoutedDocument@xlmain8.hlp>HowTo
3 Troubleshoot sending and routing workbooks in e-mail=wotbsTroubleshootProblemsSendingDocumentsToOthersInElectronicMail@xlmain8.hlp>Ref
2 Using Microsoft Excel with Lotus Notes
3 Insert a workbook as an embedded object in a Lotus Notes document or form=wodecEmbedAWordDocumentInALotusNotesForm@xlmain8.hlp>Ref
3 Update Lotus Notes fields=wohowUpdateLotusNotesFields@xlmain8.hlp>Ref
3 Import a workbook into a Lotus Notes document or form=xlhowImportWorksheetDataIntoARichTextFieldInALotusNotesForm@xlmain8.hlp>HowTo
3 Use data from a workbook in Lotus Notes views=xlhowCreateAFieldInMicrosoftExcelToUseInLotusNotes@xlmain8.hlp>HowTo
3 Use the Lotus NotesFlow Action menu=ofhowLotusNotesFlowMicrosoftprogram@xlmain8.hlp>Ref
3 How Microsoft Excel workbook file properties work with Lotus Notes fields=pprefUsingNotesFXWithMicrosoftPowerPoint@xlmain8.hlp>Ref
2 Using Workbooks in Office Binders
3 Combine and organize related files by using Office Binder=ofconOfficeBinder@xlmain8.hlp>Ref
1 Using Microsoft Excel with the Internet, Your Intranet, or a Local Web
2 About Microsoft Excel and the Internet=xllrgWaysToLinkToOtherWorkbooksWorksheets@xlmain8.hlp>LgCard
2 Working with Hyperlinks
3 Create links to connect data and files=xldecCreateLinksToConnectToDataFiles@xlmain8.hlp>Ref
3 Create a hyperlink=xldecCreateHyperlinkToAnotherDocument@xlmain8.hlp>Ref
3 Jump to another file by using a hyperlink=xldccUseHyperlinkToOpenAnotherDocument@xlmain8.hlp>HowTo
3 Network and Internet addresses for hyperlinks=xlrefNetworkInternetAddressesForHyperlinks@xlmain8.hlp>Ref
3 Troubleshoot hyperlinks=xltbsTroubleshootHyperlinks@xlmain8.hlp>Ref
3 Change the destination of a hyperlink=xlhowChangeDestinationOfHyperlink@xlmain8.hlp>HowTo
3 Set the base address for the hyperlinks in a workbook=ofhowSetHyperlinkBase@xlmain8.hlp>HowTo
3 Change the text or graphic for a hyperlink=xlhowChangeTextOrGraphicForHyperlink@xlmain8.hlp>HowTo
3 Change the appearance of hyperlink text=xlhowChangeAppearanceOfHyperlinkText@xlmain8.hlp>HowTo
3 Copy or move a hyperlink=xlhowCopyOrMoveHyperlink@xlmain8.hlp>HowTo
3 Delete a hyperlink=xlhowDeleteHyperlink@xlmain8.hlp>HowTo
2 Working with Files on the Web
3 Open a workbook=ofdecOpenDocument@xlmain8.hlp>Ref
3 Add an FTP site to the list of Internet sites=ofhowAddFTPSiteToListOfInternetSites@xlmain8.hlp>HowTo
3 Save a workbook to an FTP site=ofhowSaveDocumentToInternet@xlmain8.hlp>HowTo
3 Change the logon name or password used to gain access to an FTP site=ofhowChangeLoginOrPasswordForInternetSite@xlmain8.hlp>Howto
3 Delete an FTP site from the list of Internet sites=ofhowDeleteFTPSiteFromListOfInternetSites@xlmain8.hlp>HowTo
3 Create a link to worksheet data on your intranet or the Internet=xlhowCreateLinkToInternetOrWebData@xlmain8.hlp>HowTo
3 Update a link to intranet or Internet data=xlhowUpdateLinkToInternetOrWebData@xlmain8.hlp>HowTo
3 Get data from a Web source=xlhowGetDataFromInternetSource@xlmain8.hlp>HowTo
2 Navigating and Publishing on the Web
3 Open the start page for your Web=ofhowOpenWorldWideWebStartPage@xlmain8.hlp>HowTo
3 Open the search page for your Web=ofhowOpenSearchPage@xlmain8.hlp>HowTo
3 Open recently visited Web files=ofhowOpenPreviousOrNextDocumentInHistoryList@xlmain8.hlp>HowTo
3 Hide all toolbars except the Web toolbar=ofhowHideAllToolbarsExceptWebToolbar@xlmain8.hlp>HowTo
3 Update the current file from the Web=ofhowRefreshCurrentPage@xlmain8.hlp>HowTo
3 Add the current Web file to your list of favorites=ofhowAddCurrentDocumentToFavorites@xlmain8.hlp>HowTo
3 Change the start page for your Web=ofhowSetStartPage@xlmain8.hlp>HowTo
3 Change the search page for your Web=ofhowAddSearchPage@xlmain8.hlp>HowTo
3 About the Web Find Fast search page=ofconOpenOfficeSearchPageInInternetBrowser@xlmain8.hlp>Ref
3 Publish Microsoft Excel data on a Web=xlhowPublishMicrosoftExcelDataOnWeb@xlmain8.hlp>Ref
1 Sharing Information and Graphics Between Applications
2 Create links to connect data and files=xldecCreateLinksToConnectToDataFiles@xlmain8.hlp>Ref
2 About linked and embedded objects=xlconAboutLinkingEmbedding@xlmain8.hlp>Ref
2 Drag information between programs=coconDraggingAndDroppingBetweenApplications@xlmain8.hlp>HowTo
2 The format of information pasted from the Clipboard=ofhowOtherWaysToPasteInformation@xlmain8.hlp>Ref
2 About using a formula to link data from programs not on your computer=xlconUsingDataFromOtherApplicationsInCalculations@xlmain8.hlp>Ref
2 Create pictures of cells, charts, and other objects=xldecCreatePicturesOfCellsAndObjects@xlmain8.hlp>Ref
2 Troubleshoot linking and sharing data with other programs=xltbsTroubleshootingSharingDataandGraphicswithOtherApplications@xlmain8.hlp>Ref
2 Using the Office Shortcut Bar
3 Microsoft Office Shortcut Bar=ofhowMicrosoftOfficeShortcutBar@xlmain8.hlp>Ref
3 Manage time, contacts, tasks, and messages from the Office Shortcut Bar=ofhowManageTimeContactsTasksEmailFromOfficeShortcutBar@xlmain8.hlp>Ref
2 Exchanging Data Between Microsoft Excel, Word, and PowerPoint
3 Share information between Office programs=ofdecShareInformationBetweenOfficeApplications@xlmain8.hlp>Ref
3 Ways to share information between Microsoft Excel and another Office program=ofrefWaysToShareInformationInMicrosoftOfficeProgram@xlmain8.hlp>Ref
3 Copy Microsoft Excel data to Word or PowerPoint=xldecCopyMicrosoftExcelDataToWordOrPowerPoint@xlmain8.hlp>Ref
3 Copy the result of a formula into a Word document or PowerPoint presentation=xldccCopyResultOfFormulaIntoWordDocumentOrPowerPointPresentation@xlmain8.hlp>HowTo
3 Copy worksheet cells into a Word document or PowerPoint presentation=xldccCopyWorksheetCellsIntoWordDocumentOrPowerPointPresentation@xlmain8.hlp>HowTo
3 Use Microsoft Excel data as a mailing list in Word=xlhowUseMicrosoftExcelDataAsMailMergeDataSourceInWord@xlmain8.hlp>HowTo
3 Copy a Microsoft Excel chart into a Word document or PowerPoint presentation=xldccCopyChartIntoWordDocumentOrPowerPointPresentation@xlmain8.hlp>HowTo
3 Copy a Word table onto a Microsoft Excel worksheet=xlhowCopyWordTableIntoMicrosoftExcelWorksheet@xlmain8.hlp>HowTo
2 Using Microsoft Excel and Microsoft Outlook Together
3 Manage time, contacts, tasks, and messages from the Office Shortcut Bar=ofhowManageTimeContactsTasksEmailFromOfficeShortcutBar@xlmain8.hlp>Ref
3 Add names and addresses from a Microsoft Excel workbook to an Outlook contact list=xlhowAddNamesAddressFromMicrosoftExcelWorkbookToOutlookContactList@xlmain8.hlp>HowTo
3 Add names and addresses from an Outlook contact list to a Microsoft Excel workbook=xlhowAddNamesAddressesFromOutlookContactListToMicrosoftExcelWorkbook@xlmain8.hlp>HowTo
3 Track work on a workbook and find files using Microsoft Outlook=ofrefHowMicrosoftOutlookIntegratesWithMicrosoftOffice@xlmain8.hlp>Ref
2 Exchanging Data Between Microsoft Excel and Microsoft Access
3 Exchange data between Microsoft Excel and Microsoft Access=codecShareInformationbetweenMicrosoftExcelandMicrosoftAccess@xlmain8.hlp>Ref
3 Analyze Microsoft Access data in Microsoft Excel=ofhowImportDataFromMicrosoftAccessIntoMicrosoftExcel@xlmain8.hlp>HowTo
3 Copy Microsoft Access records to a Microsoft Excel worksheet=ofhowCopyMicrosoftAccessRecordsToAnExistingMicrosoftExcelWorksheet@xlmain8.hlp>HowTo
3 Import Microsoft Excel data into Microsoft Access=ofhowImportDataFromMicrosoftExcelIntoMicrosoftAccess@xlmain8.hlp>HowTo
3 Create a Microsoft Access form for a Microsoft Excel list=xlhowCreatingANewAccessFormWizardFormInMicrosoftExcel@xlmain8.hlp>HowTo
3 Enter data in a Microsoft Excel list by using a Microsoft Access form=xlhowUseAnExistingFormForDataEntry@xlmain8.hlp>HowTo
3 Create a Microsoft Access report based on data from a Microsoft Excel list=xlhowCreatingAReportWithAccessReportWizardInMicrosoftExcel@xlmain8.hlp>HowTo
3 Update a Microsoft Access report when the associated Microsoft Excel data changes=xlhowModifyingAnExistingReport@xlmain8.hlp>HowTo
3 Convert a Microsoft Excel list to a Microsoft Access database=xlcmdConvertingYourExcelDataToAccess@xlmain8.hlp>HowTo
3 The View Access Form or View Access Report button on the worksheet doesn't work.=xltbsTheViewAccessFormOrViewAccessReportButtonOnWorksheetDoesntWork@xlmain8.hlp>Ref
3 The format of information pasted from the Clipboard=ofhowOtherWaysToPasteInformation@xlmain8.hlp>Ref
2 Changing the Content, Updating Frequency, or Display of Objects
3 Edit a linked object or an embedded object=cohowEditAnEmbeddedObject@xlmain8.hlp>Ref
3 Control how linked information is updated in Microsoft Excel=xldecControlTheUpdatingOfLinksInExcel@xlmain8.hlp>Ref
3 Reconnect a linked object if the source file is moved or renamed=ofhowReconnectLinkWhenSourceFileMovesOrIsRenamed@xlmain8.hlp>HowTo
3 Update a linked picture of worksheet cells=xlhowUpdateALinkedPicture@xlmain8.hlp>HowTo
3 Change the way a linked object or embedded object is displayed=ofdecChangeWayLinkOrEmbeddedObjectIsDisplayed@xlmain8.hlp>Ref
2 Converting Files Between Programs
3 View or save files from other programs as Microsoft Excel workbooks=xldecImportTextDataIntoMicrosoftExcel@xlmain8.hlp>Ref
3 File format converters supplied with Microsoft Excel=xlmscFileFormatsSuppliedWithMicrosoftExcel@xlmain8.hlp>Ref
3 Using Microsoft Excel 97 files with previous versions of Microsoft Excel or other programs=xlconUsingFilesCreatedWithPreviousVersionsOfMicrosoftExcel
3 Formatting and features not transferred in file conversions=xldecFormattingFeaturesNotTransferredInFileConversions@xlmain8.hlp>Ref
3 Move files between Windows and the Macintosh=cohowMoveFilesBetweenWindowsAndTheMacintosh@xlmain8.hlp>HowTo
3 Troubleshoot converting file formats=xldecTroubleshootConvertingFileFormats@xlmain8.hlp>Ref
1 Automating Tasks
2 Macros: Automating tasks you perform frequently=xldecAutomateTasksYouDoRepeatedly@xlmain8.hlp>Ref
2 Record a macro=xlhowRecordamacro@xlmain8.hlp>HowTo
2 Run a macro=xlhowRunOrStopMacro@xlmain8.hlp>Ref
2 Run a macro from a keyboard shortcut, a graphic object, or a toolbar button=xldecAssignAmacro@xlmain8.hlp>Ref
2 Stop a macro while it is running=xlhowStopMacroWhileItIsRunning@xlmain8.hlp>HowTo
2 Edit a macro=xldccViewEditMacroCode@xlmain8.hlp>HowTo
2 Copy a macro=xlhowCopyamacro@xlmain8.hlp>Ref
1 Customizing Microsoft Excel for the Way You Work
2 Troubleshoot customizing Microsoft Excel=xltbsTroubleshootCustomizingMicrosoftExcel@xlmain8.hlp>Ref
2 Changing What You See on the Screen
3 Show or hide a toolbar=ofhowShowOrHideCommandBar@xlmain8.hlp>HowTo
3 Show or hide toolbar ScreenTips=ofhowItemsYouCanDragOntoCommandBar@xlmain8.hlp>HowTo
3 Move a toolbar=xlhowMoveAndResizeToolbars@xlmain8.hlp>HowTo
3 Resize a toolbar=cohowResizeAToolbar@xlmain8.hlp>HowTo
3 Show or hide the list of recently used workbooks on the File menu=cohowDisplayOrHideRecentlyUsedDocumentsOnTheFileMenu@xlmain8.hlp>HowTo
3 Show all windows on the Windows desktop=ofhowArrangeAllWindowsOnWindowsDesktop@xlmain8.hlp>HowTo
3 Change the color palette used in a workbook=xldecChangeColorsUsedInWorkbook@xlmain8.hlp>Ref
3 Set screen resolution to show more or less on screen=ofhowViewMoreInformationOnScreen@xlmain8.hlp>HowTo
2 Changing Defaults and Settings
2 Accessibility for people with disabilities=woconWordAccessibility@xlmain8.hlp>Ref
2 Set the default working folder that appears in the Open and Save As dialog boxes=oflrgSetWorkingFolderToUseWhenIOpenOrSaveDocuments@xlmain8.hlp>Ref
3 When I start Microsoft Excel, the default working folder is not correct.=oftbcTheFolderITypedInStartInBoxInprogramShortcutIsNotActiveWhenIStartprogram
3 Add a language or keyboard layout=wohowAddLanguageOrKeyboardLayout@xlmain8.hlp>HowTo
3 Install multilanguage support=wohowAddNewFontToYourComputer@xlmain8.hlp>HowTo
2 Customizing Toolbars and Menus
3 About toolbars=ofhowAllAboutCommandBars@xlmain8.hlp>Ref
3 Show or hide a toolbar=ofhowShowOrHideCommandBar@xlmain8.hlp>HowTo
3 Show or hide toolbar ScreenTips=ofhowItemsYouCanDragOntoCommandBar@xlmain8.hlp>HowTo
3 Move a toolbar=xlhowMoveAndResizeToolbars@xlmain8.hlp>HowTo
3 Resize a toolbar=cohowResizeAToolbar@xlmain8.hlp>HowTo
3 Save more than one toolbar configuration=xlhowSaveMoreThanOneToolbarConfiguration@xlmain8.hlp>HowTo
3 Attach a custom toolbar to a workbook=xlhowAttachCustomToolbarToWorkbook@xlmain8.hlp>HowTo
3 Creating Toolbars and Adding Buttons and Menus
4 Create a toolbar=ofhowCreateCustomCommandBar@xlmain8.hlp>HowTo
4 Add a button to a toolbar=cohowAddOrDeleteAToolbarButton@xlmain8.hlp>HowTo
4 Add a built-in menu to a toolbar=ofdccAddOrDeleteMenu@xlmain8.hlp>HowTo
4 Add a custom menu to a toolbar=ofdccCreateCustomMenu@xlmain8.hlp>HowTo
4 Add a command to a menu=ofhowAddCommandToMenu@xlmain8.hlp>HowTo
4 Run a macro from a toolbar button=xlhowAssignamacrotoatoolbarbutton@xlmain8.hlp>HowTo
4 Delete a toolbar button=ofhowDeleteCommandBarButton@xlmain8.hlp>HowTo
4 Delete a custom toolbar=cohowDeleteACustomToolbar@xlmain8.hlp>HowTo
4 Delete a command from a menu=cohowDeleteACustomToolbar@xlmain8.hlp>HowTo
4 Delete a menu from a toolbar=ofhowDeleteCommandBarMenu@xlmain8.hlp>HowTo
3 Changing the Appearance, Name, or Position of Buttons or Menus
4 Change the image or text on a toolbar button or menu command=ofdccChangeCommandBarSounds@xlmain8.hlp>Ref
4 Change the size of toolbar buttons=ofhowMakeCommandBarButtonsMenusLarger@xlmain8.hlp>HowTo
4 Change the width of a drop-down list box on a toolbar=cohowChangeTheWidthOfADropdownListBoxOnAToolbar@xlmain8.hlp>HowTo
4 Display an icon and text or text only on a menu command=rehowDisplayIconTextOrTextOnlyOnMenuCommand@xlmain8.hlp>HowTo
4 Display text or an icon on a toolbar button=ofhowDisplayTextOrIconOnCommandBarButton@xlmain8.hlp>HowTo
4 Group related buttons and menus on a toolbar=cohowSpaceOutButtonsOnAToolbar@xlmain8.hlp>HowTo
4 Move menus=ofhowMoveMenu@xlmain8.hlp>Ref
4 Move or copy a menu command=ofhowMoveOrCopyMenuCommand@xlmain8.hlp>HowTo
4 Move or copy a toolbar button=cohowMoveAndCopyToolbarButtons@xlmain8.hlp>HowTo
4 Rename a menu=ofdccRenameCustomMenu@xlmain8.hlp>HowTo
4 Rename a custom toolbar=ofhowRenameCustomCommandBar@xlmain8.hlp>HowTo
4 Rename a menu command or toolbar button=rehowRenameMenuCommandOrToolbarButton@xlmain8.hlp>HowTo
3 Changing Toolbar and Menu Settings
4 Restore original buttons and menus for a built-in toolbar=cohowRestoreABuiltinToolbar@xlmain8.hlp>HowTo
4 Restore original settings for a built-in menu=ofdccRestoreBuiltinMenu@xlmain8.hlp>HowTo
4 Restore original settings for a built-in toolbar button or menu command=wohowRestoreABuiltinToolbar@xlmain8.hlp>HowTo
4 Turn off toolbar sounds=ofhowTurnOffCommandBarSounds@xlmain8.hlp>HowTo
4 Change toolbar sounds=ofdccChangeCommandBarSounds@xlmain8.hlp>HowTo
2 Controlling What Happens When You Start Microsoft Excel
3 Control what happens when you start Microsoft Excel=xldecControlWhatHappensWhenYouStartMicrosoftExcel@xlmain8.hlp>Ref
3 Automatically start Microsoft Excel when you turn on your computer=ofhowMakeprogramStartEveryTimeIStartWindows@xlmain8.hlp>HowTo
3 Change the program that starts when you open a file=IDH_ofdefAlwaysOpenParticularFilesWithprogram@xlmain8.hlp>HowTo
3 Start Microsoft Excel without running automatic macros=ofhowStartprogramWithoutLoadingAddins@xlmain8.hlp>HowTo
2 Using Add-Ins and Optional Components
3 Use add-in programs of Microsoft Excel=xldecUseAddinComponentsOfMicrosoftExcel@xlmain8.hlp>Ref
3 Add-in programs included with Microsoft Excel=xlrefAddinProgramsIncludedWithMicrosoftExcel@xlmain8.hlp>Ref
1 Reference Information
2 Keyboard Shortcut Reference
3 Use shortcut keys in Microsoft Excel=xlrefUsingshortcutkeys@xlmain8.hlp>Ref
3 Function keys in Microsoft Excel=xlrefFunctionkeys@xlmain8.hlp>Ref
3 Lotus 1-2-3 keyboard equivalents=xlrefLotus123KeyboardEquivalents@xlmain8.hlp>Ref
3 Outline data by using shortcut keys=xlrefOutlinedatausingshortcutkeys@xlmain8.hlp>Ref
3 Print and preview a document by using shortcut keys=corefPrintandpreviewadocumentusingshortcutkeys@xlmain8.hlp>Ref
3 Edit data by using shortcut keys=xlrefEditandmovedatausingshortcutkeys@xlmain8.hlp>Ref
3 Enter data by using shortcut keys=xlrefEnterandformatdatausingshortcutkeys@xlmain8.hlp>Ref
3 Format data by using shortcut keys=xlrefFormatDataByUsingShortcutKeys@xlmain8.hlp>Ref
3 Move and scroll on a worksheet or workbook by using shortcut keys=xlrefMoveDataByUsingShortcutKeys
3 Select data, cells, chart items, or obects by using shortcut keys=xlrefSelectDataCellsChartItemsOrObectsByUsingShortcutKeys@xlmain8.hlp>Ref
3 Transition navigation keys=xlrefTransitionnavigationkeys@xlmain8.hlp>Ref
3 Work with databases, lists, and PivotTables by using shortcut keys=xlrefWorkwithdatabaseslistsandPivotTablesusingshortcutkeys@xlmain8.hlp>Ref
3 Keys for menus=ofhowKeysForMovingAroundInMenus@xlmain8.hlp>Ref
3 Keys for toolbars=ofrefKeysForMovingAroundInCommandBars@xlmain8.hlp>Ref
3 Keys for using the Office Assistant=ofrefKeysForWorkingWithOfficeAssistant@xlmain8.hlp>Ref
3 Keys for windows and dialog boxes=corerefWorkinwindowsanddialogboxes@xlmain8.hlp>Ref
2 Using Microsoft Excel with Bookshelf
3 How Bookshelf integrates with Microsoft Excel=ofconHowBookshelfIntegratesWithOfficePrograms@xlmain8.hlp>Ref
3 Look up information in Bookshelf from Microsoft Excel=ofhowLookUpInformationInMultimediaProgram@xlmain8.hlp>HowTo
3 Copy information from Bookshelf into your workbook=ofhowCopyInformationFromBookshelf@xlmain8.hlp>HowTo
3 Display a Bookshelf definition for a word without leaving your workbook=ofhowDisplayDefinitionForWordInDocument@xlmain8.hlp>HowTo
3 Start Microsoft Bookshelf=ofhowStartMicrosoftBookshelf@xlmain8.hlp>HowTo
2 Using the Pen with Microsoft Excel
3 Use a pen pointing device with Microsoft Excel=ofxldefTrendlineLabel@xlmain8.hlp>Ref
1 Switching from Other Applications
2 Switching from Lotus 1-2-3
3 Switch from Lotus 1-2-3=xldecLotus123Functions@xlmain8.hlp>Ref
3 Differences between Microsoft Excel and Lotus 1-2-3=xlconDifferencesBetweenMicrosoftExcelLotus123@xlmain8.hlp>Ref
3 Differences between Lotus 1-2-3 and Microsoft Excel functions=xldecDifferencesBetweenLotus123MicrosoftExcelFunctions@xlmain8.hlp>Ref
3 Learn how to use Microsoft Excel by using Lotus 1-2-3 Help=xlhowLearnHowToUseMicrosoftExcelByUsingLotus123Help@xlmain8.hlp>HowTo
3 Enter and calculate formulas by using Lotus 1-2-3 formula entry methods=xldecEnteringAndCalculatingLotus123Formulas@xlmain8.hlp>Ref
3 Run a macro created in another spreadsheet program in Microsoft Excel=xldecGuidelinesForRunningLotus123MacrosInMicrosoftExcel@xlmain8.hlp>Ref
3 About linking Lotus 1-2-3 and Microsoft Excel worksheets=xlrefAboutLinkingLotus123MicrosoftExcelWorksheets@xlmain8.hlp>Ref
3 Create a formula to calculate data on a Lotus 1-2-3 worksheet=xlhowCreateFormulaToCalculateDataOnLotus123Worksheet@xlmain8.hlp>HowTo
2 Switching from Quattro Pro
3 Switch from Quattro Pro=xldecSwitchFromQuattroPro@xlmain8.hlp>Ref
3 Open Quattro Pro worksheets in Microsoft Excel=xlrefOpenQuattroProWorksheetsInMicrosoftExcel@xlmain8.hlp>HowTo
3 Limitations of opening and converting Quattro Pro files in Microsoft Excel=xlhowGuidelinesForOpeningQuattroProFilesInMicrosoftExcel@xlmain8.hlp>Ref
3 Run a macro created in another spreadsheet program in Microsoft Excel=xldecGuidelinesForRunningLotus123MacrosInMicrosoftExcel@xlmain8.hlp>Ref
1 Microsoft Excel Visual Basic Reference
2 Visual Basic Reference=!EF("vbaxl8.hlp","",5,"rehowGetOnlineHelpForVisualBasic")
:Include EULA8.CNT
