Excel Documentation
Here's a list of the most common knowledge base
(KB) articles that apply to Microsoft Excel
by Mark Henri
- Boundaries
- 156942 - MS Technical Support Developer Consult Line
- 156942 - Policy: Support Boundaries for Excel
- 156942 - Policy: Supporting Village Software Templates for MS Excel
- 156942 - XL: Visual Basic Examples Using DDE
- Calculation
- 156942 - Auto/Manual Calculation
- 156942 - Descriptions of Error Values Returned by Functions
- 156942 - Hide Formula Errors [IF(ISERROR())] (see also Q280094)
- 156942 - HLOOKUP, VLOOKUP, LOOKUP
- 156942 - How to Compute the Periodic Annual Interest Rate (annualized compounded growth rate)
- 156942 - How to use INDEX & MATCH Functions w/Multiple Criteria
- 156942 - List of Available Worksheet Functions
- 156942 - Solver Company www.frontsys.com
- 156942 - SUMIF() (Formula for Cumulative Category Total)
- 156942 - SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- 156942 - Using a Logical AND or OR in a SUM+IF Statement in Excel
- 156942 - Using Iterations and Maximum Change in Calculations (Circular reference)
- 156942 - When to Use a SUM(IF()) Array Formula
- 156942 - Worksheet May Not Recalculate Completely if F9 Pressed (Circular reference)
- Charts
- 156942 - Adding Series to XY (Scatter) Chart with Second X Axis (see also Q214292)
- 156942 - Chart Display Options
- 156942 - Creating a Chart with Stacked and Unstacked Columns
- 156942 - Creating Charts with Multiple Groups of Stacked Bars
- 156942 - Dates Made Consecutive when Charting (large gaps between bars)
- 156942 - Excel 2000: How to Use the Chart Wizard
- 156942 - How to Add Text to the X or Y Axis on a Chart (& general formatting of axes)
- 156942 - How to Add Totals to a Stacked Column Chart
- 156942 - How to Change Chart Type of Series in Combination Chart [XL2000]
- 156942 - How to Create a Column Chart with Two Y Axes [XL2000]
- 156942 - Invalid External Reference Error When Creating Chart
- 156942 - Text Labels for XY Scatter Charts
- Data & Formats
- 156942 - Can't Use Find/Replace on Text with Leading Apostrophe
- 156942 - Converting Multiple Rows/Columns to Columns/Rows (using OFFSET)
- 156942 - Filtering/Extracting a Record That Contains Text String (advanced filter)
- 156942 - Finding/Replacing Tildes and Wildcard Characters
- 156942 - How to Change the Case of Text
- 156942 - How to Combine Cells of Information (Concatenate)
- 156942 - How to Convert Text to Number
- 156942 - How to Insert Special Characters (Excel Most Frequently Asked Questions)
- 156942 - How to Override Automatic Cell Formatting (When Opening CSV File)
- 156942 - How to Parse Data Using the Text To Columns Command (see also Q142149)
- 156942 - How to Parse Names Without Data Text To Columns (see also Q214261)
- 156942 - How to Remove Duplicate Records or Create Unique Records
- 156942 - How to Unhide Rows or Columns
- 156942 - How to Use Data Validation to Prevent Duplicate Entries
- 156942 - How to Use Microsoft Excel as Data Source for Word Mail Merge
- 156942 - Last Digits Changed to Zeroes When You Type Long Numbers
- 156942 - Parsing Names in a Worksheet [into separate cells: LEFT(), MID(), RIGHT()]
- 156942 - Performing a Lookup with Unsorted Data (lookups, Index/Match, Offset/Match)
- 156942 - Placing a Carriage Return (in a Cell)
- 156942 - Rounding Up or Down to a Defined Precision Limit (Ceiling, Roundup, Rounddown)
- 156942 - Wrap Text (or) Text is Wrapped Incorrectly When Typed in a Cell
- Dates & Times
- 156942 - Displaying the Current Date and Time with Text
- 156942 - How to Convert a Numeric Value Into English Words [Macro]
- 156942 - How to Use Dates and Times in Microsoft Excel
- 156942 - Working with Time Periods That Exceed 24 Hours
- Files
- 156942 - Bypassing the Text Import Wizard When You Import Files
- 156942 - Errors Opening Workbook from Windows Explorer [XL97]
- 156942 - Excel Opens Without Displaying Workbook ("Cannot find the file …")
- 156942 - Files Corrupted on Save: How to Troubleshoot Source of Problem
- 156942 - Handling Corrupted Excel Files by Saving in SYLK Format
- 156942 - How to Remove Protection from Worksheets and Workbooks
- 156942 - How to troubleshoot errors saving Excel files [XL2000]
- 156942 - Linking to Data in a Damaged File
- 156942 - List of Supported File Formats in MS Excel 2000 (see Q291051 for XP)
- 156942 - Methods for Recovering Data From Damaged Workbooks [XL2000]
- 156942 - Summary of Methods to Recover Data from Corrupted Files
- 156942 - Word Could Not Re-establish a DDE Connection
- Links
- 156942 - Delete Links Wizard Available [XL97]
- 156942 - Delete Links Wizard Available on MSL [XL2000 - idea] (include disclaimer)
- 156942 - How to Create a Link (to a Worksheet on Another Computer)
- 156942 - How to Force Excel to Always Reference the Same Cell (INDIRECT)
- 156942 - How to Remove Links From a Worksheet
- 156942 - Links in Excel
- 156942 - Macros to Delete Formula Links
- Macro
- 156942 - How to Send Form Mail That Uses Excel Data
- Miscellaneous
- 156942 - Activation vs. Registration
- 156942 - Add-Ins That Are No Longer Included with Microsoft Excel [XL2002]
- 156942 - Columns and Rows Are Labeled Numerically (R1C1; see also Q231045)
- 156942 - Convert Quatro Pro (WB3) files to Excel
- 156942 - Corrupt EXCEL.XLB File May Cause General Protection Fault
- 156942 - Disk Space Requirements for MS Office 2000
- 156942 - Enable Microsoft Office XP Shortcut Bar to Run Automatically
- 156942 - Eraser Utility to Remove Remaining Office 97 Files (Q239938 for 2000)
- 156942 - Error When Sorting a Range Containing Merged Cells
- 156942 - Errors When Trusted Resources for Add-ins is Removed (Macro Security)
- 156942 - Excel articles Available by E-Mail: Functionality
- 156942 - Excel Articles Available by E-Mail: User Interface
- 156942 - How to Contact the Microsoft Wish Program
- 156942 - How to Install or Repair Microsoft Excel Features [XL2000]
- 156942 - How to Modify the Number of Undo Levels [XL2000]
- 156942 - How to Perform Clean-Boot Troubleshooting for Windows 98
- 156942 - How to Select Cells/Ranges Using Visual Basic Procedures (& macro resources info)
- 156942 - How to Troubleshoot Startup Problems in Microsoft Excel
- 156942 - How to Turn AutoComplete On or Off
- 156942 - How to Uninstall Small Business Financial Manager (SBFM.XLA)
- 156942 - How to Use the Forms Controls on a Worksheet
- 156942 - Ignore Other Application - Unable to open from email
- 156942 - Macro to Delete Every Other Row
- 156942 - Microsoft Excel 2000 Specifications
- 156942 - Off97: Products That Qualify for the Office Upgrade
- 156942 - Products That Qualify for the Microsoft Office Upgrade (XL2000)
- 156942 - Products That Qualify for the Microsoft Office XP Upgrade
- 156942 - Registry Keys Used by Microsoft Excel 97 for Windows
- 156942 - Template Wizard Add-In, Get it Here (It was omitted from Office XP)
- 156942 - Using the Office 2000 Clipboard
- Printing
- 156942 - Before Calling a Mentor: Printing/Video/Fonts/Multimedia (Basic troubleshooting)
- 156942 - How to Set Print Area to Range with Defined Name
- 156942 - Troubleshooting Font Problems when Printing
- Startup
- 156942 - How to Troubleshoot Startup Problems in Microsoft Excel
- 156942 - Startup Switches for Microsoft Excel 2000
- 156942 - Startup Switches for Microsoft Excel 97
- Virus
- 156942 - How to Identify and Remove PLDT/CAR/SGV Macro Viruses
- 156942 - How to Use the Virus Search Add-in (WE1280)
- 156942 - Information About Known Macro Viruses in Microsoft Excel
- 156942 - Q&A About Excel Macro/Laroux Macro Virus
- 156942 - Too Many Different Cell Formats [Note: Good description of cell formats]
created on 14.04.2006 16:38:25