Make your own free website on Tripod.com

MS Excel How-to & Knowledge Base Articles

Microsoft Excel Knowledge Base Articles

Click the links below to jump to the relevant section, if you are unable to find the article you need, try searching Microsoft Knowledge Base

  Links
Sample Formulas, Functions, Macros, VBA Codes | General Information | Knowledge Base How-to Articles


Knowledge Base How-to Articles

How to Activate a Perpetual License in Office XP Program

How to Add a Digital Signature to a Custom Macro Project in an Office XP Program

How to Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000

How to Add Text to the X or Y Axis on a Chart

How to Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000

How to Add the Workbook Path to the Header and Footer in Exce

How to Add Totals to a Stacked Column Chart in Excel 2000

How to Analyze a Questionnaire or Survey with a PivotTable in Excel 2000

How to AutoFilter Records Based on Cell Formatting in Excel 2000

How to Automate Embedded Office ActiveX Documents with C++ .NET

How to Automate Excel From C++ .NET and MFC To Fill or Obtain Data In a Range Using Arrays

How to Automate Excel Text to Speech in Another Office Progra

How to Binding for Office Automation Servers with Visual C# .NET

How to Build an Office COM Add-in by Using Visual Basic .NET

How to Build an Office COM Add-in by Using Visual C# .NET

How to Bypass the Text Import Wizard When You Import Files in Excel 2000

How to Calculate Ages Before 1/1/1900 in Excel 2000

How to Calculate Compound Interest for an Intra-Year Period in Excel 2000

How to Calculate the nth Root of a Number in Excel 2000

How to Calculate the Number of Months Between Two Dates in Excel 2000

How to Call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office

How to Change Default Colors in Excel 2000

How to Change Default Font and Font Size in Excel 200

How to Change Default Font and Font Size in Excel 2000

How to Change the Chart Type of a Series in a Combination Chart in Excel 2000

How to Change the Color Palette for Workbooks in Excel 200

How to Change the Company Name and User Name in an Office XP Progra

How to Change the Font in a Comment in Excel 2000

How to Change the ODBC Data Source for a PivotTable in Excel 200

How to Change the Voice That Is Used for Text to Speech in Exce

How to Check and Manage the Status of Links in Excel 200

How to Check the Version of Office X

How to Clear the Most Recently Used Files List in an Office XP Program by Modifying the Windows Registry

How to Clear the Most Recently Used List in Office Programs

How to Compare Two Cells Ignoring Leading and Trailing Spaces

How to Configure a Policy Setting to Disable Password Protection for Microsoft Access 2002, Microsoft Excel 2002, and Microsoft Word 2002

How to Configure a Policy Setting to Disable the "Office on the Web" Command in Office XP

How to Configure a System Policy to Control the Recently Used File List in an Office XP Program

How to Consolidate Multiple Worksheets to a Single Sheet in Excel 2000

How to Convert an Add-in File into a Workbook in Excel 2000

How to Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000

How to Convert Text to Numbers in Microsoft Excel 2002

How to Count Unique Elements in a Cell Range in Excel

How to Create a Column Chart with Two Y-Axes in Excel 2000

How to Create a Form Letter by Using Information from an Excel 2002 Worksheet in Word 2002

How to Create a Normal Chart from a PivotTable in Excel 2000

How to Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000

How to Create a Smart Tag DLL in ATL For Use in Office XP

How to Create a Smart Tag DLL in Visual Basic for Use in Office XP

How to Create a Threaded Discussion in Microsoft Office Application

How to Create an Add-in Application Name and Description in Excel 2000

How to Create an Add-In File in Excel 2000

How to Create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000

How to Create an Excel Macro by Using Automation from Visual Basic .NET

How to Create an Office XP Smart Tag DLL by Using Visual Basic .NET

How to Create an Office XP Smart Tag DLL by Using Visual C# .NET

How to Create Functions to Calculate Light Years in Excel 2000

How to Create Multiple Views and Create and Print a Report in Exce

How to Create Multiple Views, Create and Print a Report in Excel 2000

How to Create PivotTables from Multiple Consolidation Ranges in Excel 2000

How to Create Two Pie Charts in One in Excel 2000

How to Custom Sort or Prevent Auto Sort in PivotTable in Excel 2000

How to Customize the My Places Bar in the "Open" and "Save As" Dialog Boxes

How to Deploy the Office XP Web Components in an Office Progra

How to Determine the Order in Which Shapes Are Added to Diagrams in Office Programs

How to Develop Database-Driven Smart Tags for Office XP by Using Visual Basic for Windows

How to Disable FrontPage 2002 Commands by Using a GPO and a WSH Scrip

How to Disable the Web Toolbar Components in Office XP Programs by Using a System Policy

How to Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC

How to Display All Menu Commands in Office XP Programs

How to Display Data as Percentage of the Total in a PivotTable in Excel 2000

How to Display More Digits in Trendline Equation Coefficients in Exce

How to Display or Hide the Ask a Question Box in Microsoft Office

How to Embed and Automate an Excel Worksheet by Using C++ .NET and MFC

How to Export an XML Spreadsheet File into Generic XML in Excel 200

How to Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Exce

How to Export Lotus 1-2-3 Linked Files to Excel 2000

How to Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000

How to Force Excel to Always Reference the Same Cell in Excel 2000

How to Get Windows Status Information from Windows API in Excel 2000

How to Handle Corrupted Excel Files by Saving Them in the SYLK Forma

How to Handle Events for Excel by Using Visual Basic .NET

How to Handle Events for Excel by Using Visual C# .NET

How to Handle Events for Excel by Using Visual C++ .NET

How to Hide Gridlines in a Selected Area of a Worksheet in Excel 2000

How to Hide Records with Duplicate Cell Entries in Excel 2000

How to How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 200

How to Identify and Remove PLDT, CAR, and SGV Macro Viruses in Excel 2000

How to Import Data into SQL Server from Exce

How to Include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000

How to Index Data in a PivotTable in Excel 2000

How to Insert a Picture into the Header or Footer in Microsoft Excel 2002

How to Install or Repair Microsoft Excel Features in Excel 2000

How to Link to a Particular Worksheet from a Web Page in Excel 2000

How to Make Paste Options Disappear After You Paste in Excel 200

How to Manage Office XP Templates in Office Program

How to Modify a Particular Time with the TIME and MOD Functions in Excel 2000

How to Obtain and Install the Excel 2000 SR-1 Eurotool Add-In Update

How to Obtain and Install the Excel 2000 SYLK File Security Update in Excel 2000

How to Open a Document Linked to Password-Protected Sheet in Excel 2000

How to Open Documents from FTP Site and Save Documents to FTP Site with an Office XP Program

How to Optimize PivotTable Performance in Excel 2000

How to Perform a Two-Dimensional Lookup in Excel 2000

How to Plot Values Against a Recommended Range in Excel 2000

How to Preserve Formulas If You Save a Document As a Text File in Excel 2000

How to Prevent Excel from Automatically Opening Files in the Startup Folder in Excel 200

How to Query and Display Excel Data by Using ASP.NET, ADO.NET and Visual Basic .NET

How to Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET

How to Rank Duplicate Values Sequentially in Excel 2000

How to Remove Entries from Add-Ins Dialog Box

How to Remove Password Protection from Worksheets, Workbooks, and Shared Workbooks in Excel 2000

How to Remove Template Listings in Excel

How to Rename a Chart by Using the Name Box in Excel 2000

How to Reset Personal Menus in Office XP and Office 2000 Programs

How to Retrieve the Names of Macros from an Excel Workbook by Using Visual Basic 6.0

How to Run Office Macros by Using Automation from Visual C# .NET

How to Save a Workbook as a Web Page in Excel 2002

How to Save Files in Other Formats in Excel 2000

How to Save Files in Other Formats in Excel 2002

How to Send Form Results to a Microsoft Excel Worksheet Using FrontPage 2000

How to Set a Print Area by Using a Defined Name in Excel 2000

How to Set Up and Use the RTD Function in Excel 2002

How to Simulate a PivotTable with No Summarization in Excel 2000

How to Sort Cells Without Sorting Linked Cells in Excel 2000

How to Sort More Than Three Columns in Excel 2000

How to Specify Dynamic Web Query Parameters in Excel 2000

How to Specify Trusted Sources for Digital Certificates in Excel 2002, PowerPoint 2002, and Word 2002

How to Suppress #DIV/0! Error Value in Division in Excel 2000

How to Suppress the Printing of Errors in Workbook Cells in Excel 2002

How to Transfer Data to an Excel Workbook by Using Visual Basic .NET

How to Transfer Data to an Excel Workbook by Using Visual C# .NE

How to Transfer Data to Excel by Using SQL Server Data Transformation Service

How to Transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET

How to Transfer XML Data to Microsoft Excel 2002 by Using Visual C# .NET

How to Transform a DataSet to Spreadsheet XML for Excel by Using Visual Basic .NET and ASP .NET

How to Troubleshoot Custom Smart Tags in Office XP

How to Troubleshoot Speech Recognition Problems in Word 2002

How to Turn AutoComplete On or Off in Excel 2000

How to Turn Off Function Argument ToolTips in Excel 2002

How to Turn Off the Message for Updating Links in a Workbook in Excel

How to Use a Web Data Source for a PivotTable in Excel 2000

How to Use Addresses from an Access 2002 Database Create Labels in Word 2002

How to Use Addresses from an Excel 2002 Worksheet to Create Labels in Word 2002

How to Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET

How to Use Advanced Filter to Exclude Records in Excel 2000

How to Use Automation to Create Office Command Bars and Controls by Using Visual C++ .NET

How to Use AutoSave in Excel 2000

How to Use Custom Toolbars from Excel 5.0 in Excel 2000

How to Use Dates and Times in Excel 2000

How to Use Draw Border Tools and Draw Border Grid Tools to Apply and Remove Cell Borders in Excel

How to Use Excel Startup Folders in Excel 2000

How to Use Excel Startup Folders in Excel 2002

How to Use Find to Search Multiple Worksheets in Excel 2000

How to Use Functions in Formulas in Excel 2000

How to Use Global and Local References in Formulas in Excel 2000

How to Use Keyboard Shortcuts to Select Border Styles in Excel

How to Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000

How to Use Microsoft Map to Display Postal Code Centers in Excel 2000

How to Use Microsoft Map to Display Specific States and Nations in Excel 2000

How to Use Natural Language Formulas in Excel 2000

How to Use NETWORKDAYS with Multiple Holidays in Excel 2000

How to Use New "Find and Replace" Dialog Box in Excel 2002

How to Use Only Selected Parts of AutoFormat in Excel 2000

How to Use RAND() to Generate Randomly Distributed Integers in Excel 2000

How to Use Shared Workbooks with Different Versions of Excel, Including Excel 2000

How to Use Small Business Financial Manager in Excel 2002

How to Use Speech Recognition to Select Cells, Rows, and Columns in Excel

How to Use STDEV or STDEVP with a PivotTable in Excel 2000

How to Use SUM Function on Only Odd or Even Rows in Excel 2000

How to Use Text-to-Speech in Excel 2002

How to Use the "Most Recently Used" Category in the Function Wizard in Excel 2000

How to Use the "Send To" Menu Command to Send Worksheets and Workbooks as E-Mail in Excel

How to Use the AutoCorrect Options Smart Tag in Excel 2002

How to Use the AutoRepublish Feature in Excel 2002

How to Use the Chart Wizard in Excel 2000

How to Use the Error Checking Options Button in Excel 2002

How to Use the Excel Formula Evaluator in Excel 2002

How to Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000

How to Use the Forms Controls on a Worksheet in Excel 2000

How to Use the Forms Controls on a Worksheet in Excel 2002

How to Use the GetPivotData Worksheet Function in Excel 2000

How to Use the Histogram Add-in in Excel 2000

How to Use the HTML Filter in Word 2000

How to Use the INDEX and LINEST Functions to Solve for New X-Values in Excel 2000

How to Use the Keyboard to Change the Active Cell in Excel 2000

How to Use the Microsoft Office Application Recovery Tool in Office XP Program

How to Use the Paste Options Buttons in Excel 2002

How to Use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000

How to Use the Template Wizard with Data Tracking Add-In in Excel 2000

How to Use the Undo Feature with Inserted Objects in Office XP Program

How to Use Visual Basic .NET for Binding for Office Automation Servers

How to Use Visual C# .NET to Automate a Running Instance of an Office Program

How to Use Wildcard Characters in Microsoft Excel 2000 Parameter Queries

How to View the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly

How to Work with an HTML Table That Contains Merged Cells in Excel 2000

How to Work with Serial Number Dates and Julian Dates in Microsoft Excel 2000

XL: How to Add a New Category to Function Category List

XL: How to Add Data to a Drop-Down or List Box

XL: How to Add MS Excel 5.0 Dialog Sheet to a Workbook

XL: How to Add New Data to a Data Map Chart

XL: How to Add the Workbook Path to the Footer

XL: How to Add Totals to a Stacked Column Chart

XL: How to Analyze Questionnaire or Survey with a PivotTable

XL: How to Append an Excel Worksheet to a Database Using DAO

XL: How to Assign a Macro to an Option Button

XL: How to AutoFilter Records Based on Cell Formatting

XL: How to Avoid "Save Changes?" When You Close a Workbook

XL: How to Bypass the Text Import Wizard When You Import File

XL: How to Calculate Compound Interest

XL: How to Calculate Compound Interest for an IntraYear Period

XL: How to Calculate the Number of Days in a Month

XL: How to Call a Macro Repeatedly on a Fixed Time Interval

XL: How to Change Arabic Page Numbers to Roman Numerals

XL: How to Change Chart Type of a Series in Combination Chart

XL: How to Change Connection Information for a Query

XL: How to Change Default Font and Font Size in Microsoft Excel

XL: How to Change the Alternate Startup Folder (Directory)

XL: How to Change the Case of Text

XL: How to Check Number of Records Returned in an AutoFilter

XL: How to Check Spelling for Worksheet Objects Only

XL: How to Close All Workbooks but One with Visual Basic Macro

XL: How to Combine Cells of Information in Excel

XL: How to Compare Data in Two Columns for Duplicates

XL: How to Compute the Average Growth Rate of an Investment

XL: How to Compute the Periodic Annual Interest Rate in Microsoft Excel

XL: How to Concatenate DDE to MSQuery Statements

XL: How to Consolidate Multiple Worksheets to a Single Sheet

XL: How to Continue a Visual Basic Statement from One Line to the Next

XL: How to Control the AutoFilter with a Macro

XL: How to Convert a Numeric Value into English Words

XL: How to Convert Text to Numbers

XL: How to Copy Files from Cabinets on DMF-Formatted Disk

XL: How to Copy One of Each Record Type to Another Worksheet

XL: How to Copy Text to TextBoxes Using the Characters Method

XL: How to Copy the Text Within a Text Box to a Cell

XL: How to Correct Rounding Errors in Floating-Point Arithmetic

XL: How to Count Blank Cells in a Specified Range

XL: How to Count Cells That Contain Formulas, Text, or Numbers

XL: How to Count Rows Displayed After Data Has Been Filtered

XL: How to Count the Occurrences of a Number or Text in a Range

XL: How to Create a Bell Curve Chart

XL: How to Create a Biorhythm Chart

XL: How to Create a Bullet List in Microsoft Excel

XL: How to Create a Chart with Discontiguous Ranges

XL: How to Create a Column Chart with Two Y Axe

XL: How to Create a Conditional Format to Hide Errors

XL: How to Create a Dynamic Named Range

XL: How to Create a Formula to Correctly Evaluate Blank Cells

XL: How to Create a Gantt Chart Using Hours as the Scale

XL: How to Create a Gantt Chart Using Hours as the Scale

XL: How to Create a Macro That Counts Comments

XL: How to Create a Macro That Counts Text Notes (Cell Notes)

XL: How to Create a Macro That Opens Multiple Selected Files

XL: How to Create a Map with Microsoft Data Map

XL: How to Create a Monthly Calendar

XL: How to Create a Single Stacked Column or Bar Chart

XL: How to Create a Spiral Chart

XL: How to Create a User-Defined Chart Format

XL: How to Create a User-Defined Chart Format

XL: How to Create Add-in Application Name and Descriptio

XL: How to Create an Auto_Open Macro to Show Data Form Dialog Box

XL: How to Create an Index with Microsoft Query

XL: How to Create and Use an Auto_Close Procedure

XL: How to Create and Use One-Input Data Tables in Microsoft Excel

XL: How to Create and Use Two-Input Data Tables in Microsoft Excel

XL: How to Create Application-Level Event Handlers

XL: How to Create Data Validation Circles for Printing

XL: How to Create Functions to Calculate Light Years

XL: How to Create MS Access Database from MS Excel Using DAO

XL: How to Create Multiple Views and Create and Print a Report

XL: How to Create PivotTables from Multiple Consolidation Ranges

XL: How to Create Yes and No Buttons for a Custom Message Box

XL: How to Delete and Restore a Menu That Has a Submenu

XL: How to Determine How Many Pages Will Be Printed

XL: How to Determine How Many Pages Will Be Printed

XL: How to Determine If a File Is Read-Only

XL: How to Determine If a Variable Is an Array

XL: How to Determine If a Workbook or a Worksheet Is Protected

XL: How to Determine Top/Bottom Used Cells in a Sparse Array

XL: How to Display a Progress Bar with a User Form

XL: How to Display Data as Percentage of Total in Pivot Tabl

XL: How to Display Only Certain States/Nations in Microsoft Map

XL: How to Display Postal Code Centers in Microsoft Map

XL: How to Display the "What's New in Excel" Windo

XL: How to Display the Current Date and Time with Text

XL: How to Display the File Name of a Worksheet Without Using a Macro

XL: How to Display the Open and Save As Dialog Boxes

XL: How to Display Top 10 Records with a Macro

XL: How to Enable AutoSave

XL: How to Enter a Second Line in a Message Box

XL: How to Extract an Exact Match of Text from a Database

XL: How to Find and Replace Tildes and Wildcard Characters

XL: How to Find Resources on Microsoft Excel Solver

XL: How to Find Secant, Cosecant, or Cotangent of an Angle

XL: How to Find Technical Information About Microsoft Excel

XL: How to Find the Percentage of Change Between Values

XL: How to Find Visual Basic for Applications Help

XL: How to Force Macro Code to Wait for Outside Procedure

XL: How to Get Prime Numbers or Factors

XL: How to Hide Records with Duplicate Cell Entries

XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro

XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro

XL: How to Identify and Remove PLDT/CAR/SGV Macro Viruses

XL: How to Index Data in a PivotTable

XL: How to Insert a Graphic File in Microsoft Excel Workshee

XL: How to Lock Individual Cells in a Workshee

XL: How to Make Spinner Whose Minimum Value Is Less Than Zero

XL: How to Make Sure That Only Numbers Are Entered in a Column

XL: How to Manage Multiple Windows in Excel

XL: How to Minimize Metadata in Microsoft Excel Workbooks

XL: How to Modify the Number of Undo Levels

XL: How to Obtain the SQL Statement for a PivotTable

XL: How to Open a Copy of a Template in MS Excel 7.0, 97

XL: How to Parse Data Using the Text To Columns Command

XL: How to Parse Data Using the Text To Columns Command

XL: How to Perform a Case-Sensitive Lookup

XL: How to Play a Sound Note Using Visual Basic for Applications

XL: How to Play Sounds Using Visual Basic for Applications

XL: How to Populate an Array with a Discontiguous Range

XL: How to Preserve Formulas When Saving as a Text File

XL: How to Prevent File Corruption

XL: How to Programmatically Disable Microsoft Excel Control Menu Commands

XL: How to Programmatically Print All Embedded Charts on a Worksheet

XL: How to Programmatically Reset a Workbook to Default Styles

XL: How to Programmatically Save a File to a Network Drive

XL: How to Programmatically Save a File to a Network Drive

XL: How to Put Folder Contents into a Worksheet

XL: How to Rank Duplicate Values Sequentially

XL: How To Recover MS Excel File If Unwanted Changes Are Made

XL: How to Remove Duplicate Records or Create List of Unique Records

XL: How to Remove Gridlines from a Section of a Worksheet

XL: How to Remove User-Defined Functions from Function Wizard

XL: How To Retrieve a QueryDef from MS Access Using DAO

XL: How to Retrieve a Table from Access into Excel Using DAO

XL: How to Retrieve Records into Specific Columns Using DAO

XL: How To Retrieve the Results of a Parameter Query Using DAO

XL: How to Return Data from a Dialog Box to a Worksheet

XL: How to Return the First or Last Match in an Array

XL: How to Return the Nth Word from a String

XL: How to Reverse the Axis on a Bar Chart

XL: How to Run a Macro When Certain Cells Change

XL: How to Run a Macro When Certain Cells Change

XL: How to Run a WordBasic Macro from an MS Excel Macro

XL: How to Save Personal Macro Workbook When Excel Is Open

XL: How to Scroll Window Views from Object to Object

XL: How to Select Cells/Ranges Using Visual Basic Procedures

XL: How to Select Ranges Using Visual Basic for Applications (Novice Examples)

XL: How to Select the Current Region Minus the First Row

XL: How to Set Page Setup Attributes for More Than One Sheet

XL: How to Set Page Setup Attributes for More Than One Sheet

XL: How to Set Print Area to Range with Defined Name

XL: How to Set Print Areas and Print Titles on a Worksheet

XL: How to Set the Descriptive Name of an Add-in File

XL: How To Share a Custom AutoFill List

XL: How to Show Quotation Marks in Function Results and Macros

XL: How to Simulate a PivotTable with No Summarization

XL: How to Solve for New X-Values Using INDEX and LINEST

XL: How to Sum a Range of Cells Based on a Number Format

XL: How to Sum and Format a Range of Hours, Minutes, or Seconds

XL: How to Sum Either Odd or Even Rows Onl

XL: How to Sum Ranges Using Visual Basic for Applications

XL: How to Suppress "Save Changes?" Prompt When You Close a Workbook

XL: How to Troubleshoot Startup Problems in Microsoft Excel

XL: How to Use "On Error" to Handle Errors in a Macro

XL: How to Use a Custom Function in Another Workbook

XL: How to Use a Logical AND or OR in a SUM+IF Statement in Excel

XL: How to Use a Macro to Enter Cell Note Text in a Text Box

XL: How to Use a Toolbar Button to Open a File Indirectl

XL: How to Use a VBA Macro to Sum Only Visible Cells

XL: How to Use Advanced Filter to Exclude Records

XL: How to Use Conditional Formatting to Shade Every Other Row

XL: How to Use DAO in Excel Without Referencing DAO Library

XL: How to Use DAO to Append the Records in Two Tables

XL: How to Use DAO to Create a New Microsoft Excel Workbook

XL: How to Use Dynamic Arrays in a Macro

XL: How to Use File DSNs and DSN-less Connections

XL: How to Use Grouping for Fields in a PivotTable

XL: How to Use Grouping for Fields in a PivotTable

XL: How to Use INDEX and MATCH Worksheet Functions with Multiple Criteria

XL: How to Use Input Boxes with Visual Basic for Applications

XL: How to Use Looping Structures in Visual Basic for Applications

XL: How to Use Microsoft Excel Data Tables to Analyze Information in a Database

XL: How to Use STDDEV or STDDEVP with a PivotTable

XL: How to Use System, User, and File Data Sources

XL: How to Use the Conditional Sum Wizard in Microsoft Excel

XL: How to Use the DataEntryMode Property

XL: How to Use the Forms Controls on a Worksheet

XL: How to Use the FREQUENCY Function

XL: How to Use the Histogram Add-i

XL: How to Use the INDIRECT Function to Create References

XL: How to Use the INDIRECT Function to Create References

XL: How to Use the Left, Right, Mid, and Len Functions in Visual Basic

XL: How to Use the MultiPage Control in a UserForm

XL: How to Use the TabStrip Control in a UserForm

XL: How to Use the Template Wizard with Data Tracking Add-I

XL: How to Use the Virus Search Add-in for Microsoft Excel (WE1280)

XL: How to Use Visual Basic for Applications in Excel

XL: How to Use VLOOKUP or HLOOKUP to Find an Exact Match

XL: How to Work with Random Access Files

XL2000: Files Corrupted on Save: How to Troubleshoot Source of Problem

XL2000: How to a Make Spinner with a Minimum Value Less Than Zero

XL2000: How to Add a Microsoft Excel 5.0 Dialog Sheet to a Workbook

XL2000: How to Add a New Category to Function Category List

XL2000: How to Add the Workbook Path to the Footer

XL2000: How To Add the Workbook Path to the Title Ba

XL2000: How to Assign a Macro to an ActiveX Worksheet Control

XL2000: How to Attach a Custom Toolbar to a Specific Workbook

XL2000: How to Automatically Set Min and Max Scale for Y-Axis

XL2000: How to Avoid Saving Password in Text File When You Get External Data

XL2000: How to Break Links Between a Chart and a Worksheet

XL2000: How to Call a Macro Repeatedly on a Fixed Time Interval

XL2000: How to Change the Date or Time Format in a Header or Footer

XL2000: How to Change the Font in a Cell Comment

XL2000: How to Change the Paper Source Using the SendKeys Command

XL2000: How to Change the Taper Style for All Series in a Chart

XL2000: How to Check Spelling for Worksheet Objects Only

XL2000: How to Close All Workbooks But One with a Visual Basic Macro

XL2000: How to Compare Data in Two Columns for Duplicates

XL2000: How to Continue a Visual Basic Statement from One Line to the Next

XL2000: How to Control the Appearance of the Mouse Pointer While a Macro Runs

XL2000: How to Control the AutoFilter with a Macro

XL2000: How to Control the Placement of Objects

XL2000: How to Convert a Numeric Value into English Words

XL2000: How to Convert All Files on a Server to Microsoft Excel

XL2000: How to Copy One of Each Record Type to Another Worksheet

XL2000: How to Copy Text to Text Boxes Using the Characters Method

XL2000: How to Copy the Text Within a Text Box to a Cell

XL2000: How to Count Rows Displayed After Data Has Been Filtered

XL2000: How to Create a Chart with Non-Contiguous Ranges

XL2000: How to Create a Dynamic Named Range

XL2000: How to Create a Group of Mutually Exclusive ToggleButton Controls

XL2000: How to Create a Macro That Opens Multiple Selected Files

XL2000: How to Create a Monthly Calendar

XL2000: How to Create a Startup Screen with a UserForm

XL2000: How to Create a Template for a Toolbox Control

XL2000: How to Create and Use a Workbook_BeforeClose Procedure

XL2000: How to Create PivotTable from Word

XL2000: How to Create Unique Random Integers Between Two Numbers

XL2000: How to Create Yes and No Buttons for a Custom Message Box

XL2000: How to Customize a Custom Toolbar Button

XL2000: How to Delete a Collection of Code Objects from a VBAProject

XL2000: How to Delete Cells with a For Each...Next Loop

XL2000: How to Determine If a File Is Read-Only

XL2000: How to Determine If a Variable Is an Array

XL2000: How to Determine If a Workbook or a Worksheet Is Protected

XL2000: How to Determine If the Active Cell Contains a Comment

XL2000: How to Determine the Key Pressed Along with Mouse Button

XL2000: How to Determine Which DLLs Are Registered

XL2000: How to Determine Which Items Are Selected in a List Box

XL2000: How to Display a ComboBox List When a UserForm Is Displayed

XL2000: How to Display a Custom Function in Step 2 of the Function Wizard

XL2000: How to Display a Custom Office Assistant Balloon

XL2000: How to Display a UserForm Whose Name Is in a Variable

XL2000: How to Display the Open and Save As Dialog Boxes

XL2000: How to Display Top 10 Records with a Macro

XL2000: How to Dynamically Resize a User Form

XL2000: How to Enter a Second Line in a Message Box

XL2000: How to Fill List Box Control with Multiple Ranges

XL2000: How to Find Open Programs That Are DDE-Capable

XL2000: How to Force Macro Code to Wait for Outside Procedure

XL2000: How to Get Prime Numbers or Factors

XL2000: How to Hide and Restore a Built-In Menu

XL2000: How to Hide Button Controls with Visual Basic for Applications

XL2000: How to Make a Macro That Automatically Starts When You Open a Workbook

XL2000: How to Manually Recalculate a Single Cell or Range

XL2000: How to Move Between Custom UserForms with Command Buttons

XL2000: How to Obtain the SQL Statement for a PivotTable

XL2000: How to Open a Copy of a Template in Microsoft Excel 2000

XL2000: How to Pass Variables in Visual Basic for Applications Macros

XL2000: How to Place a Check Mark Next to a Custom Menu Item

XL2000: How to Play Sounds Using Visual Basic for Applications

XL2000: How to Populate an Array with a Discontiguous Range

XL2000: How to Populate One List Box Based on Another List Box

XL2000: How to Prevent the Automatic Creation of Hyperlinks

XL2000: How to Programmatically Change the Project Name Property

XL2000: How to Programmatically Convert Column Position Numbers to Column Letters

XL2000: How to Programmatically Copy All Range Names

XL2000: How to Programmatically Create a Chart Without Selecting a Range of Cells

XL2000: How to Programmatically Create a Collection

XL2000: How to Programmatically Create a Reference

XL2000: How to Programmatically Delete and Restore a Menu That Contains a Submenu

XL2000: How to Programmatically Delete Defined Names with Links

XL2000: How to Programmatically Disable Keyboard Functionality

XL2000: How to Programmatically Disable Microsoft Excel Control Menu Commands

XL2000: How to Programmatically Display All Files in a Folder

XL2000: How to Programmatically Find the Nth Word in a Text String

XL2000: How to Programmatically Format Names of Months in All-Capital Letters

XL2000: How to Programmatically Increment a Date With a Spinner

XL2000: How to Programmatically Insert Blank Rows in a Worksheet

XL2000: How to Programmatically Insert Data from a List Box into the Active Cell

XL2000: How to Programmatically Make Sure That Only Numbers Are Entered in a Column

XL2000: How to Programmatically Measure the Visible Range in Points

XL2000: How to Programmatically Modify Hyperlink Addresses on a Worksheet

XL2000: How to Programmatically Perform a Web Query

XL2000: How to Programmatically Reset a Workbook to Default Styles

XL2000: How to Programmatically Save All Open Workbooks

XL2000: How to Programmatically Select Every Nth Row in a Range

XL2000: How to Programmatically Select the Current Data Area Without Selecting the First Row

XL2000: How to Programmatically Subtract or Sum Two Ranges of Data

XL2000: How to Programmatically Sum Only the Visible Cells in a Range

XL2000: How to Programmatically Suppress an Error Value Returned by a Formula

XL2000: How to Record a Macro Using Relative Cell References

XL2000: How to Reduce the Chances of Macro Virus Infectio

XL2000: How to Reference a Cell in the Header or Footer

XL2000: How to Remove All Items from a ListBox or ComboBox

XL2000: How to Remove Individual AutoFilter Drop-Down Lists

XL2000: How to Remove Links from a Worksheet

XL2000: How to Remove the Control Menu and Program Window Controls

XL2000: How to Return Data from a Dialog Box to a Worksheet

XL2000: How to Return Multiple Values from a Custom Function

XL2000: How to Return the Address of the Cell with the Largest or Smallest Value

XL2000: How to Return the Source of a Hyperlink in a Cel

XL2000: How to Return Values from a List Box That Displays Multiple Columns

XL2000: How to Run a WordBasic Macro from a Microsoft Excel Macro

XL2000: How to Secure Visual Basic Code in Excel

XL2000: How to Select Cells/Ranges Using Visual Basic Procedure

XL2000: How to Select Ranges Using Visual Basic for Applications (Novice Examples)

XL2000: How to Send Form Mail That Uses Excel Data

XL2000: How to Set the Default Command Button on a UserForm

XL2000: How to Set the Descriptive Name of an Add-in File

XL2000: How To Share a Custom AutoFill List

XL2000: How to Show Quotation Marks in Function Results and Macros

XL2000: How to Simulate a Paused Visual Basic Procedure

XL2000: How to Simulate Combination List-Edit Control for UserForms

XL2000: How to Sum a Range of Cells Based on a Number Format

XL2000: How to Temporarily Hide a UserForm

XL2000: How to Trap Events for an Embedded Chart

XL2000: How to Turn off Shortcut Menus

XL2000: How to Use "On Error" to Handle Errors in a Macro

XL2000: How to Use a Custom Function in Another Workbook

XL2000: How to use a Macro to Enter Cell Note Text in a Text Box

XL2000: How to Use a UserForm for Entering Data

XL2000: How to Use a Visual Basic Macro to Open and Retrieve a File on the Internet

XL2000: How to Use a Visual Basic Macro to Sort Arrays in Excel

XL2000: How to Use ADO to Return Data to a ListBox or ComboBox

XL2000: How to Use Application.Match to Locate Date Values on a Worksheet

XL2000: How to Use DAO to Create a New Microsoft Excel Workbook

XL2000: How to Use Data Access Objects to Join Tables of Different Formats

XL2000: How to Use Data Validation to Prevent Duplicate Entries

XL2000: How to Use Dynamic Arrays in a Macro

XL2000: How to Use EnableEvents to Disable Event Handling

XL2000: How to Use Input Boxes with Visual Basic for Applications

XL2000: How to Use Macros to Set Row Height and Column Width

XL2000: How to Use the ApplyCustomType Method to Format Charts

XL2000: How to Use the Imp Operator for Binary Comparison

XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events

XL2000: How to Use the RefEdit Control with a UserForm

XL2000: How to Use the SelectionChange Event to Make the Active Row Bold

XL2000: How to Use the TabStrip Control on a UserForm

XL2000: How to Use the TextColumn Property

XL2000: How to Use Visual Basic Code to Total Rows and Columns in an Array

XL2000: How to Use Visual Basic Constants in Text Strings

XL2000: How to Use Visual Basic to Create a Dynamic Chart

XL2000: How to Use Visual Basic to Play an AVI File

XL2000: How to Verify the Value of a CheckBox on a UserForm

XL2001: How to Use Dates and Times in Microsoft Excel

XL2002: How to Automate Smart Tags by Using Visual Basic for Applications

XL2002: How to Delete Cells with a For Each...Next Loop

XL2002: How to Determine If Your Workbook Contains Links to External Data

XL2002: How to Mark an Automation Add-In Function as Volatile

XL2002: How to Prevent the Automatic Creation of Hyperlinks

XL2002: How to Programmatically Reset a Workbook to Default Styles

XL2002: How to Programmatically Turn Off the Clipboard Warning Message

XL2002: How to Recover a Lost Worksheet or Lost Version of a Workshee

XL2002: How to Remove Smart Tags from a Workbook

XL2002: How to Select Cells/Ranges Using Visual Basic Procedures

XL2002: How to Select Ranges Using Visual Basic for Applications (Novice Examples)

XL2002: How to Suppress #DIV/0! Error Value in Division

XL2002: How to Use Auto Fill Options Smart Tags

XL2002: How to Use the "Insert Options" Button in Excel 2002

XL97: How to Assign a Macro to an ActiveX Worksheet Control

XL97: How to Change the Depth of a 3-D Surface Chart

XL97: How to Change the Font in a Cell Comment

XL97: How to Change the Font in a Commen

XL97: How to Change the Taper Style for All Series in a Chart

XL97: How to Control the Placement of Objects

XL97: How to Convert All Files on a Server to Microsoft Excel

XL97: How to Convert an Add-in File into a Workbook

XL97: How to Create a Conditional Format to Hide Errors

XL97: How To Create a Dynamic Chart Using Visual Basic

XL97: How to Create a GIF File from a Microsoft Excel Chart

XL97: How To Create a Group of Mutually Exclusive ToggleButtons

XL97: How to Create a Pie Of Pie Chart or a Bar Of Pie Chart

XL97: How to Create a Report Templat

XL97: How to Create a Startup Screen with a UserForm

XL97: How to Create a Template for a Toolbox Control

XL97: How to Create an Add-in File in Microsoft Excel 97

XL97: How to Create Application Level Event Handlers

XL97: How to Create PivotTable from Word

XL97: How to Create Web Query (.iqy) Files

XL97: How to Customize a Custom Toolbar Button

XL97: How to Delete Cells with a For Each...Next Loop

XL97: How to Delete, Restore, and Edit Menu Items Manually

XL97: How to Determine If the Active Cell Contains a Comment

XL97: How to Determine the Key Pressed Along with Mouse Button

XL97: How to Determine Which Items Are Selected in a ListBox

XL97: How to Disable Shortcut Menus

XL97: How to Display a ComboBox List When UserForm Is Displayed

XL97: How to Display a Custom Office Assistant Balloon

XL97: How to Display a Progress Bar with a User Form

XL97: How to Display a UserForm Whose Name Is in a Variable

XL97: How to Display Custom Function in Function Wizard Step 2

XL97: How to Dynamically Resize a User Form

XL97: How to Fill ListBox Control with Multiple Ranges

XL97: How to Import Web Page Tables into Microsoft Excel

XL97: How to Link to a Particular Worksheet from a Web Page

XL97: How to Modify the Number of Undo Levels

XL97: How to Move Between Custom UserForms with CommandButtons

XL97: How to Obtain and Install the Excel 97 SYLK File Security Update

XL97: How to Obtain the Excel 97 Auto Recalculation Patch

XL97: How to Place a Checkmark Next to a Menu Item

XL97: How to Plot Values Against a Recommended Range

XL97: How to Populate One ListBox Based On Another ListBox

XL97: How to Programmatically Change the Format of a User Input After Data Entry

XL97: How to Programmatically Change the Project Name Property

XL97: How to Programmatically Create a Collection

XL97: How to Programmatically Create a Reference

XL97: How to Programmatically Perform a Web Query

XL97: How to Programmatically Reset a Workbook to Default Styles

XL97: How to Programmatically Save a Worksheet as HTML

XL97: How to Record a Macro Using Relative Cell References

XL97: How to Remove All Items from a ListBox or ComboBox

XL97: How to Remove Individual AutoFilter Drop-Down Lists

XL97: How to Rename a Chart Using Name Box

XL97: How to Restore a Built-In Menu

XL97: How to Restrict Numeric Entry to Only One Cell in a Range

XL97: How to Save Files in Other Formats

XL97: How to Simulate a Paused Visual Basic Procedure

XL97: How to Sort Cells Without Sorting Linked Cells

XL97: How to Specify Dynamic Web Query Parameters

XL97: How to Temporarily Hide a UserForm

XL97: How to Trap Events for an Embedded Chart

XL97: How to Turn Off Automatic Font Scaling in All Charts

XL97: How to Use a Toolbar Settings File from a Network Share

XL97: How to Use a UserForm for Entering Data

XL97: How to Use a Web Data Source for a PivotTable

XL97: How to Use Custom Toolbars in Excel5.xlb

XL97: How to Use Data Validation to Prevent Duplicate Entries

XL97: How to Use EnableEvents to Disable Event Handling

XL97: How to Use Excel Startup Folders

XL97: How to Use FileSearch to Fill a Listbox with File Names

XL97: How to Use Natural Language Formulas

XL97: How to Use the ApplyCustomType Method to Format Charts

XL97: How to Use the EFFECT and NOMINAL Functions to Calculate Loan or Mortgage Interest with Intrayear Compounding

XL97: How to Use the GetOpenFilename Method

XL97: How to Use the GetPivotData Worksheet Function

XL97: How to Use the Internet Assistant Wizard

XL97: How to Use the PivotTable AutoShow Feature

XL97: How to Use the PivotTable AutoSort Feature

XL97: How to Use the Query Before and AfterRefresh Events

XL97: How to Use the TextColumn Property

XL97: How to Use Wildcards in Parameter Queries

XL97: How to Verify the Value of a CheckBox on a UserForm

XL97: How to View Sample Chart with the Keyboard

XL98: How to Add the Workbook Path to the Footer

XL98: How to Delete Cells with a For Each...Next Loop

XL98: How to Programmatically Reset a Workbook to Default Styles

XL98: How to Select Chart Subtype by Using Keyboard

XL98: How to Use the Virus Search Add-in for Microsoft Excel 98

 

Microsoft Resources

MS Excel Home

/ Excel Home Page

MS Excel Frequently Asked Questions

/ Excel 2000
/ Excel 97
/ Excel 95

MS Excel Tips and Tricks

/ Undiscovered Tips
/ Office Tips and Tricks
/ Tips and Tricks (2)

MS Excel Downloads

/ Excel Downloads

MS Excel Support Centers

/ Excel 2000 Support Centre
/ Excel 2002 Support Centre
/ Excel Assistance Centre

MS Excel VBA

/ VBA 101

MS Excel Resources

MS Excel Sites

/ The Spreadsheet Page
/ Excel Web Source
/ David McRitchie: My Excel Pages
/ XL Logic
/ OzGrid Business Applications
/ Ask Mr Excel
/ Small Business Spreadsheet Factory
/ John's Finance Page

MS Excel: Spreadsheet Modelling

/ PriceWaterhouse Coopers: Spreadsheet Modelling Best Practice
/ Guidelines For Writing Spreadsheets

MS Excel For Accountants

/ Spreadsheets For Auditors and Accountants
/ Free Excel Spreadsheets
/ Analysis Model
/ Excel Templates
/ Spreadsheet Programs
/ CashFlow
/ Excel Spreadsheets For Finance
/ Mathtools.net

MS Excel: Links

/ Spreadsheet Style Links
/ Mathtools.net
/ AccountingWeb Resources
/ XL Logic Links
/ OzGrid Links
/ Add-ins.Com Links
/ VBA Links

MS Excel Tutorials

/ Spreadsheet Tutorials
/ Tutorials by John F Lacher CPA

MS Excel Add-ins

/ Excel Addin ASAP Utilities

MS Excel Functions

/ Excel Function Dictionary Download

MS Excel Examples

/ Byg Software:  Excel Examples

MS Excel Tips and Tricks

/ Microsoft Excel Tips
/ Payne Consulting Excel Tips
/ Excel Tips

MS Excel VBA

/ VBA Pro
/ Erlands Excel & VBA Tips
/ OzGrid VBA
/ Visual Basic Users
/ Excel VBA Examples
/ Excel-VBA-Access

MS Excel Password-Recovery

/ Excel Password Recovery
/ Excel Password Recovery Software

MS Excel Newsletter

/ Excel Tips

Copyright © 2004-2006 Windows Guides. Site Map