KB Articles

Knowledge base articles from microsoft support site.

  1. How to Activate a Perpetual License in Office XP Program
  2. How to Add a Digital Signature to a Custom Macro Project in an Office XP Program
  3. How to Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000
  4. How to Add Text to the X or Y Axis on a Chart
  5. How to Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000
  6. How to Add the Workbook Path to the Header and Footer in Exce
  7. How to Add Totals to a Stacked Column Chart in Excel 2000
  8. How to Analyze a Questionnaire or Survey with a PivotTable in Excel 2000
  9. How to AutoFilter Records Based on Cell Formatting in Excel 2000
  10. How to Automate Embedded Office ActiveX Documents with C++ .NET
  11. How to Automate Excel From C++ .NET and MFC To Fill or Obtain Data In a Range Using Arrays
  12. How to Automate Excel Text to Speech in Another Office Progra
  13. How to Binding for Office Automation Servers with Visual C# .NET
  14. How to Build an Office COM Add-in by Using Visual Basic .NET
  15. How to Build an Office COM Add-in by Using Visual C# .NET
  16. How to Bypass the Text Import Wizard When You Import Files in Excel 2000
  17. How to Calculate Ages Before 1/1/1900 in Excel 2000
  18. How to Calculate Compound Interest for an Intra-Year Period in Excel 2000
  19. How to Calculate the nth Root of a Number in Excel 2000
  20. How to Calculate the Number of Months Between Two Dates in Excel 2000
  21. How to Call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office
  22. How to Change Default Colors in Excel 2000
  23. How to Change Default Font and Font Size in Excel 200
  24. How to Change Default Font and Font Size in Excel 2000
  25. How to Change the Chart Type of a Series in a Combination Chart in Excel 2000
  26. How to Change the Color Palette for Workbooks in Excel 200
  27. How to Change the Company Name and User Name in an Office XP Progra
  28. How to Change the Font in a Comment in Excel 2000
  29. How to Change the ODBC Data Source for a PivotTable in Excel 200
  30. How to Change the Voice That Is Used for Text to Speech in Exce
  31. How to Check and Manage the Status of Links in Excel 200
  32. How to Check the Version of Office X
  33. How to Clear the Most Recently Used Files List in an Office XP Program by Modifying the Windows Registry
  34. How to Clear the Most Recently Used List in Office Programs
  35. How to Compare Two Cells Ignoring Leading and Trailing Spaces
  36. How to Configure a Policy Setting to Disable Password Protection for Microsoft Access 2002, Microsoft Excel 2002, and Microsoft Word 2002
  37. How to Configure a Policy Setting to Disable the “Office on the Web” Command in Office XP
  38. How to Configure a System Policy to Control the Recently Used File List in an Office XP Program
  39. How to Consolidate Multiple Worksheets to a Single Sheet in Excel 2000
  40. How to Convert an Add-in File into a Workbook in Excel 2000
  41. How to Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000
  42. How to Convert Text to Numbers in Microsoft Excel 2002
  43. How to Count Unique Elements in a Cell Range in Excel
  44. How to Create a Column Chart with Two Y-Axes in Excel 2000
  45. How to Create a Form Letter by Using Information from an Excel 2002 Worksheet in Word 2002
  46. How to Create a Normal Chart from a PivotTable in Excel 2000
  47. How to Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000
  48. How to Create a Smart Tag DLL in ATL For Use in Office XP
  49. How to Create a Smart Tag DLL in Visual Basic for Use in Office XP
  50. How to Create a Threaded Discussion in Microsoft Office Application
  51. How to Create an Add-in Application Name and Description in Excel 2000
  52. How to Create an Add-In File in Excel 2000
  53. How to Create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000
  54. How to Create an Excel Macro by Using Automation from Visual Basic .NET
  55. How to Create an Office XP Smart Tag DLL by Using Visual Basic .NET
  56. How to Create an Office XP Smart Tag DLL by Using Visual C# .NET
  57. How to Create Functions to Calculate Light Years in Excel 2000
  58. How to Create Multiple Views and Create and Print a Report in Exce
  59. How to Create Multiple Views, Create and Print a Report in Excel 2000
  60. How to Create PivotTables from Multiple Consolidation Ranges in Excel 2000
  61. How to Create Two Pie Charts in One in Excel 2000
  62. How to Custom Sort or Prevent Auto Sort in PivotTable in Excel 2000
  63. How to Customize the My Places Bar in the “Open” and “Save As” Dialog Boxes
  64. How to Deploy the Office XP Web Components in an Office Progra
  65. How to Determine the Order in Which Shapes Are Added to Diagrams in Office Programs
  66. How to Develop Database-Driven Smart Tags for Office XP by Using Visual Basic for Windows
  67. How to Disable FrontPage 2002 Commands by Using a GPO and a WSH Scrip
  68. How to Disable the Web Toolbar Components in Office XP Programs by Using a System Policy
  69. How to Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC
  70. How to Display All Menu Commands in Office XP Programs
  71. How to Display Data as Percentage of the Total in a PivotTable in Excel 2000
  72. How to Display More Digits in Trendline Equation Coefficients in Exce
  73. How to Display or Hide the Ask a Question Box in Microsoft Office
  74. How to Embed and Automate an Excel Worksheet by Using C++ .NET and MFC
  75. How to Export an XML Spreadsheet File into Generic XML in Excel 200
  76. How to Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Exce
  77. How to Export Lotus 1-2-3 Linked Files to Excel 2000
  78. How to Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000
  79. How to Force Excel to Always Reference the Same Cell in Excel 2000
  80. How to Get Windows Status Information from Windows API in Excel 2000
  81. How to Handle Corrupted Excel Files by Saving Them in the SYLK Forma
  82. How to Handle Events for Excel by Using Visual Basic .NET
  83. How to Handle Events for Excel by Using Visual C# .NET
  84. How to Handle Events for Excel by Using Visual C++ .NET
  85. How to Hide Gridlines in a Selected Area of a Worksheet in Excel 2000
  86. How to Hide Records with Duplicate Cell Entries in Excel 2000
  87. How to How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 200
  88. How to Identify and Remove PLDT, CAR, and SGV Macro Viruses in Excel 2000
  89. How to Import Data into SQL Server from Exce
  90. How to Include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000
  91. How to Index Data in a PivotTable in Excel 2000
  92. How to Insert a Picture into the Header or Footer in Microsoft Excel 2002
  93. How to Install or Repair Microsoft Excel Features in Excel 2000
  94. How to Link to a Particular Worksheet from a Web Page in Excel 2000
  95. How to Make Paste Options Disappear After You Paste in Excel 200
  96. How to Manage Office XP Templates in Office Program
  97. How to Modify a Particular Time with the TIME and MOD Functions in Excel 2000
  98. How to Obtain and Install the Excel 2000 SR-1 Eurotool Add-In Update
  99. How to Obtain and Install the Excel 2000 SYLK File Security Update in Excel 2000
  100. How to Open a Document Linked to Password-Protected Sheet in Excel 2000
  101. How to Open Documents from FTP Site and Save Documents to FTP Site with an Office XP Program
  102. How to Optimize PivotTable Performance in Excel 2000
  103. How to Perform a Two-Dimensional Lookup in Excel 2000
  104. How to Plot Values Against a Recommended Range in Excel 2000
  105. How to Preserve Formulas If You Save a Document As a Text File in Excel 2000
  106. How to Prevent Excel from Automatically Opening Files in the Startup Folder in Excel 200
  107. How to Query and Display Excel Data by Using ASP.NET, ADO.NET and Visual Basic .NET
  108. How to Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET
  109. How to Rank Duplicate Values Sequentially in Excel 2000
  110. How to Remove Entries from Add-Ins Dialog Box
  111. How to Remove Password Protection from Worksheets, Workbooks, and Shared Workbooks in Excel 2000
  112. How to Remove Template Listings in Excel
  113. How to Rename a Chart by Using the Name Box in Excel 2000
  114. How to Reset Personal Menus in Office XP and Office 2000 Programs
  115. How to Retrieve the Names of Macros from an Excel Workbook by Using Visual Basic 6.0
  116. How to Run Office Macros by Using Automation from Visual C# .NET
  117. How to Save a Workbook as a Web Page in Excel 2002
  118. How to Save Files in Other Formats in Excel 2000
  119. How to Save Files in Other Formats in Excel 2002
  120. How to Send Form Results to a Microsoft Excel Worksheet Using FrontPage 2000
  121. How to Set a Print Area by Using a Defined Name in Excel 2000
  122. How to Set Up and Use the RTD Function in Excel 2002
  123. How to Simulate a PivotTable with No Summarization in Excel 2000
  124. How to Sort Cells Without Sorting Linked Cells in Excel 2000
  125. How to Sort More Than Three Columns in Excel 2000
  126. How to Specify Dynamic Web Query Parameters in Excel 2000
  127. How to Specify Trusted Sources for Digital Certificates in Excel 2002, PowerPoint 2002, and Word 2002
  128. How to Suppress #DIV/0! Error Value in Division in Excel 2000
  129. How to Suppress the Printing of Errors in Workbook Cells in Excel 2002
  130. How to Transfer Data to an Excel Workbook by Using Visual Basic .NET
  131. How to Transfer Data to an Excel Workbook by Using Visual C# .NE
  132. How to Transfer Data to Excel by Using SQL Server Data Transformation Service
  133. How to Transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET
  134. How to Transfer XML Data to Microsoft Excel 2002 by Using Visual C# .NET
  135. How to Transform a DataSet to Spreadsheet XML for Excel by Using Visual Basic .NET and ASP .NET
  136. How to Troubleshoot Custom Smart Tags in Office XP
  137. How to Troubleshoot Speech Recognition Problems in Word 2002
  138. How to Turn AutoComplete On or Off in Excel 2000
  139. How to Turn Off Function Argument ToolTips in Excel 2002
  140. How to Turn Off the Message for Updating Links in a Workbook in Excel
  141. How to Use a Web Data Source for a PivotTable in Excel 2000
  142. How to Use Addresses from an Access 2002 Database Create Labels in Word 2002
  143. How to Use Addresses from an Excel 2002 Worksheet to Create Labels in Word 2002
  144. How to Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
  145. How to Use Advanced Filter to Exclude Records in Excel 2000
  146. How to Use Automation to Create Office Command Bars and Controls by Using Visual C++ .NET
  147. How to Use AutoSave in Excel 2000
  148. How to Use Custom Toolbars from Excel 5.0 in Excel 2000
  149. How to Use Dates and Times in Excel 2000
  150. How to Use Draw Border Tools and Draw Border Grid Tools to Apply and Remove Cell Borders in Excel
  151. How to Use Excel Startup Folders in Excel 2000
  152. How to Use Excel Startup Folders in Excel 2002
  153. How to Use Find to Search Multiple Worksheets in Excel 2000
  154. How to Use Functions in Formulas in Excel 2000
  155. How to Use Global and Local References in Formulas in Excel 2000
  156. How to Use Keyboard Shortcuts to Select Border Styles in Excel
  157. How to Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000
  158. How to Use Microsoft Map to Display Postal Code Centers in Excel 2000
  159. How to Use Microsoft Map to Display Specific States and Nations in Excel 2000
  160. How to Use Natural Language Formulas in Excel 2000
  161. How to Use NETWORKDAYS with Multiple Holidays in Excel 2000
  162. How to Use New “Find and Replace” Dialog Box in Excel 2002
  163. How to Use Only Selected Parts of AutoFormat in Excel 2000
  164. How to Use RAND() to Generate Randomly Distributed Integers in Excel 2000
  165. How to Use Shared Workbooks with Different Versions of Excel, Including Excel 2000
  166. How to Use Small Business Financial Manager in Excel 2002
  167. How to Use Speech Recognition to Select Cells, Rows, and Columns in Excel
  168. How to Use STDEV or STDEVP with a PivotTable in Excel 2000
  169. How to Use SUM Function on Only Odd or Even Rows in Excel 2000
  170. How to Use Text-to-Speech in Excel 2002
  171. How to Use the “Most Recently Used” Category in the Function Wizard in Excel 2000
  172. How to Use the “Send To” Menu Command to Send Worksheets and Workbooks as E-Mail in Excel
  173. How to Use the AutoCorrect Options Smart Tag in Excel 2002
  174. How to Use the AutoRepublish Feature in Excel 2002
  175. How to Use the Chart Wizard in Excel 2000
  176. How to Use the Error Checking Options Button in Excel 2002
  177. How to Use the Excel Formula Evaluator in Excel 2002
  178. How to Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000
  179. How to Use the Forms Controls on a Worksheet in Excel 2000
  180. How to Use the Forms Controls on a Worksheet in Excel 2002
  181. How to Use the GetPivotData Worksheet Function in Excel 2000
  182. How to Use the Histogram Add-in in Excel 2000
  183. How to Use the HTML Filter in Word 2000
  184. How to Use the INDEX and LINEST Functions to Solve for New X-Values in Excel 2000
  185. How to Use the Keyboard to Change the Active Cell in Excel 2000
  186. How to Use the Microsoft Office Application Recovery Tool in Office XP Program
  187. How to Use the Paste Options Buttons in Excel 2002
  188. How to Use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000
  189. How to Use the Template Wizard with Data Tracking Add-In in Excel 2000
  190. How to Use the Undo Feature with Inserted Objects in Office XP Program
  191. How to Use Visual Basic .NET for Binding for Office Automation Servers
  192. How to Use Visual C# .NET to Automate a Running Instance of an Office Program
  193. How to Use Wildcard Characters in Microsoft Excel 2000 Parameter Queries
  194. How to View the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly
  195. How to Work with an HTML Table That Contains Merged Cells in Excel 2000
  196. How to Work with Serial Number Dates and Julian Dates in Microsoft Excel 2000
  197. XL: How to Add a New Category to Function Category List
  198. XL: How to Add Data to a Drop-Down or List Box
  199. XL: How to Add MS Excel 5.0 Dialog Sheet to a Workbook
  200. XL: How to Add New Data to a Data Map Chart
  201. XL: How to Add the Workbook Path to the Footer
  202. XL: How to Add Totals to a Stacked Column Chart
  203. XL: How to Analyze Questionnaire or Survey with a PivotTable
  204. XL: How to Append an Excel Worksheet to a Database Using DAO
  205. XL: How to Assign a Macro to an Option Button
  206. XL: How to AutoFilter Records Based on Cell Formatting
  207. XL: How to Avoid “Save Changes?” When You Close a Workbook
  208. XL: How to Bypass the Text Import Wizard When You Import File
  209. XL: How to Calculate Compound Interest
  210. XL: How to Calculate Compound Interest for an IntraYear Period
  211. XL: How to Calculate the Number of Days in a Month
  212. XL: How to Call a Macro Repeatedly on a Fixed Time Interval
  213. XL: How to Change Arabic Page Numbers to Roman Numerals
  214. XL: How to Change Chart Type of a Series in Combination Chart
  215. XL: How to Change Connection Information for a Query
  216. XL: How to Change Default Font and Font Size in Microsoft Excel
  217. XL: How to Change the Alternate Startup Folder (Directory)
  218. XL: How to Change the Case of Text
  219. XL: How to Check Number of Records Returned in an AutoFilter
  220. XL: How to Check Spelling for Worksheet Objects Only
  221. XL: How to Close All Workbooks but One with Visual Basic Macro
  222. XL: How to Combine Cells of Information in Excel
  223. XL: How to Compare Data in Two Columns for Duplicates
  224. XL: How to Compute the Average Growth Rate of an Investment
  225. XL: How to Compute the Periodic Annual Interest Rate in Microsoft Excel
  226. XL: How to Concatenate DDE to MSQuery Statements
  227. XL: How to Consolidate Multiple Worksheets to a Single Sheet
  228. XL: How to Continue a Visual Basic Statement from One Line to the Next
  229. XL: How to Control the AutoFilter with a Macro
  230. XL: How to Convert a Numeric Value into English Words
  231. XL: How to Convert Text to Numbers
  232. XL: How to Copy Files from Cabinets on DMF-Formatted Disk
  233. XL: How to Copy One of Each Record Type to Another Worksheet
  234. XL: How to Copy Text to TextBoxes Using the Characters Method
  235. XL: How to Copy the Text Within a Text Box to a Cell
  236. XL: How to Correct Rounding Errors in Floating-Point Arithmetic
  237. XL: How to Count Blank Cells in a Specified Range
  238. XL: How to Count Cells That Contain Formulas, Text, or Numbers
  239. XL: How to Count Rows Displayed After Data Has Been Filtered
  240. XL: How to Count the Occurrences of a Number or Text in a Range
  241. XL: How to Create a Bell Curve Chart
  242. XL: How to Create a Biorhythm Chart
  243. XL: How to Create a Bullet List in Microsoft Excel
  244. XL: How to Create a Chart with Discontiguous Ranges
  245. XL: How to Create a Column Chart with Two Y Axe
  246. XL: How to Create a Conditional Format to Hide Errors
  247. XL: How to Create a Dynamic Named Range
  248. XL: How to Create a Formula to Correctly Evaluate Blank Cells
  249. XL: How to Create a Gantt Chart Using Hours as the Scale
  250. XL: How to Create a Gantt Chart Using Hours as the Scale
  251. XL: How to Create a Macro That Counts Comments
  252. XL: How to Create a Macro That Counts Text Notes (Cell Notes)
  253. XL: How to Create a Macro That Opens Multiple Selected Files
  254. XL: How to Create a Map with Microsoft Data Map
  255. XL: How to Create a Monthly Calendar
  256. XL: How to Create a Single Stacked Column or Bar Chart
  257. XL: How to Create a Spiral Chart
  258. XL: How to Create a User-Defined Chart Format
  259. XL: How to Create a User-Defined Chart Format
  260. XL: How to Create Add-in Application Name and Descriptio
  261. XL: How to Create an Auto_Open Macro to Show Data Form Dialog Box
  262. XL: How to Create an Index with Microsoft Query
  263. XL: How to Create and Use an Auto_Close Procedure
  264. XL: How to Create and Use One-Input Data Tables in Microsoft Excel
  265. XL: How to Create and Use Two-Input Data Tables in Microsoft Excel
  266. XL: How to Create Application-Level Event Handlers
  267. XL: How to Create Data Validation Circles for Printing
  268. XL: How to Create Functions to Calculate Light Years
  269. XL: How to Create MS Access Database from MS Excel Using DAO
  270. XL: How to Create Multiple Views and Create and Print a Report
  271. XL: How to Create PivotTables from Multiple Consolidation Ranges
  272. XL: How to Create Yes and No Buttons for a Custom Message Box
  273. XL: How to Delete and Restore a Menu That Has a Submenu
  274. XL: How to Determine How Many Pages Will Be Printed
  275. XL: How to Determine How Many Pages Will Be Printed
  276. XL: How to Determine If a File Is Read-Only
  277. XL: How to Determine If a Variable Is an Array
  278. XL: How to Determine If a Workbook or a Worksheet Is Protected
  279. XL: How to Determine Top/Bottom Used Cells in a Sparse Array
  280. XL: How to Display a Progress Bar with a User Form
  281. XL: How to Display Data as Percentage of Total in Pivot Tabl
  282. XL: How to Display Only Certain States/Nations in Microsoft Map
  283. XL: How to Display Postal Code Centers in Microsoft Map
  284. XL: How to Display the “What’s New in Excel” Windo
  285. XL: How to Display the Current Date and Time with Text
  286. XL: How to Display the File Name of a Worksheet Without Using a Macro
  287. XL: How to Display the Open and Save As Dialog Boxes
  288. XL: How to Display Top 10 Records with a Macro
  289. XL: How to Enable AutoSave
  290. XL: How to Enter a Second Line in a Message Box
  291. XL: How to Extract an Exact Match of Text from a Database
  292. XL: How to Find and Replace Tildes and Wildcard Characters
  293. XL: How to Find Resources on Microsoft Excel Solver
  294. XL: How to Find Secant, Cosecant, or Cotangent of an Angle
  295. XL: How to Find Technical Information About Microsoft Excel
  296. XL: How to Find the Percentage of Change Between Values
  297. XL: How to Find Visual Basic for Applications Help
  298. XL: How to Force Macro Code to Wait for Outside Procedure
  299. XL: How to Get Prime Numbers or Factors
  300. XL: How to Hide Records with Duplicate Cell Entries
  301. XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro
  302. XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro
  303. XL: How to Identify and Remove PLDT/CAR/SGV Macro Viruses
  304. XL: How to Index Data in a PivotTable
  305. XL: How to Insert a Graphic File in Microsoft Excel Workshee
  306. XL: How to Lock Individual Cells in a Workshee
  307. XL: How to Make Spinner Whose Minimum Value Is Less Than Zero
  308. XL: How to Make Sure That Only Numbers Are Entered in a Column
  309. XL: How to Manage Multiple Windows in Excel
  310. XL: How to Minimize Metadata in Microsoft Excel Workbooks
  311. XL: How to Modify the Number of Undo Levels
  312. XL: How to Obtain the SQL Statement for a PivotTable
  313. XL: How to Open a Copy of a Template in MS Excel 7.0, 97
  314. XL: How to Parse Data Using the Text To Columns Command
  315. XL: How to Parse Data Using the Text To Columns Command
  316. XL: How to Perform a Case-Sensitive Lookup
  317. XL: How to Play a Sound Note Using Visual Basic for Applications
  318. XL: How to Play Sounds Using Visual Basic for Applications
  319. XL: How to Populate an Array with a Discontiguous Range
  320. XL: How to Preserve Formulas When Saving as a Text File
  321. XL: How to Prevent File Corruption
  322. XL: How to Programmatically Disable Microsoft Excel Control Menu Commands
  323. XL: How to Programmatically Print All Embedded Charts on a Worksheet
  324. XL: How to Programmatically Reset a Workbook to Default Styles
  325. XL: How to Programmatically Save a File to a Network Drive
  326. XL: How to Programmatically Save a File to a Network Drive
  327. XL: How to Put Folder Contents into a Worksheet
  328. XL: How to Rank Duplicate Values Sequentially
  329. XL: How To Recover MS Excel File If Unwanted Changes Are Made
  330. XL: How to Remove Duplicate Records or Create List of Unique Records
  331. XL: How to Remove Gridlines from a Section of a Worksheet
  332. XL: How to Remove User-Defined Functions from Function Wizard
  333. XL: How To Retrieve a QueryDef from MS Access Using DAO
  334. XL: How to Retrieve a Table from Access into Excel Using DAO
  335. XL: How to Retrieve Records into Specific Columns Using DAO
  336. XL: How To Retrieve the Results of a Parameter Query Using DAO
  337. XL: How to Return Data from a Dialog Box to a Worksheet
  338. XL: How to Return the First or Last Match in an Array
  339. XL: How to Return the Nth Word from a String
  340. XL: How to Reverse the Axis on a Bar Chart
  341. XL: How to Run a Macro When Certain Cells Change
  342. XL: How to Run a Macro When Certain Cells Change
  343. XL: How to Run a WordBasic Macro from an MS Excel Macro
  344. XL: How to Save Personal Macro Workbook When Excel Is Open
  345. XL: How to Scroll Window Views from Object to Object
  346. XL: How to Select Cells/Ranges Using Visual Basic Procedures
  347. XL: How to Select Ranges Using Visual Basic for Applications (Novice Examples)
  348. XL: How to Select the Current Region Minus the First Row
  349. XL: How to Set Page Setup Attributes for More Than One Sheet
  350. XL: How to Set Page Setup Attributes for More Than One Sheet
  351. XL: How to Set Print Area to Range with Defined Name
  352. XL: How to Set Print Areas and Print Titles on a Worksheet
  353. XL: How to Set the Descriptive Name of an Add-in File
  354. XL: How To Share a Custom AutoFill List
  355. XL: How to Show Quotation Marks in Function Results and Macros
  356. XL: How to Simulate a PivotTable with No Summarization
  357. XL: How to Solve for New X-Values Using INDEX and LINEST
  358. XL: How to Sum a Range of Cells Based on a Number Format
  359. XL: How to Sum and Format a Range of Hours, Minutes, or Seconds
  360. XL: How to Sum Either Odd or Even Rows Onl
  361. XL: How to Sum Ranges Using Visual Basic for Applications
  362. XL: How to Suppress “Save Changes?” Prompt When You Close a Workbook
  363. XL: How to Troubleshoot Startup Problems in Microsoft Excel
  364. XL: How to Use “On Error” to Handle Errors in a Macro
  365. XL: How to Use a Custom Function in Another Workbook
  366. XL: How to Use a Logical AND or OR in a SUM+IF Statement in Excel
  367. XL: How to Use a Macro to Enter Cell Note Text in a Text Box
  368. XL: How to Use a Toolbar Button to Open a File Indirectl
  369. XL: How to Use a VBA Macro to Sum Only Visible Cells
  370. XL: How to Use Advanced Filter to Exclude Records
  371. XL: How to Use Conditional Formatting to Shade Every Other Row
  372. XL: How to Use DAO in Excel Without Referencing DAO Library
  373. XL: How to Use DAO to Append the Records in Two Tables
  374. XL: How to Use DAO to Create a New Microsoft Excel Workbook
  375. XL: How to Use Dynamic Arrays in a Macro
  376. XL: How to Use File DSNs and DSN-less Connections
  377. XL: How to Use Grouping for Fields in a PivotTable
  378. XL: How to Use Grouping for Fields in a PivotTable
  379. XL: How to Use INDEX and MATCH Worksheet Functions with Multiple Criteria
  380. XL: How to Use Input Boxes with Visual Basic for Applications
  381. XL: How to Use Looping Structures in Visual Basic for Applications
  382. XL: How to Use Microsoft Excel Data Tables to Analyze Information in a Database
  383. XL: How to Use STDDEV or STDDEVP with a PivotTable
  384. XL: How to Use System, User, and File Data Sources
  385. XL: How to Use the Conditional Sum Wizard in Microsoft Excel
  386. XL: How to Use the DataEntryMode Property
  387. XL: How to Use the Forms Controls on a Worksheet
  388. XL: How to Use the FREQUENCY Function
  389. XL: How to Use the Histogram Add-i
  390. XL: How to Use the INDIRECT Function to Create References
  391. XL: How to Use the INDIRECT Function to Create References
  392. XL: How to Use the Left, Right, Mid, and Len Functions in Visual Basic
  393. XL: How to Use the MultiPage Control in a UserForm
  394. XL: How to Use the TabStrip Control in a UserForm
  395. XL: How to Use the Template Wizard with Data Tracking Add-I
  396. XL: How to Use the Virus Search Add-in for Microsoft Excel (WE1280)
  397. XL: How to Use Visual Basic for Applications in Excel
  398. XL: How to Use VLOOKUP or HLOOKUP to Find an Exact Match
  399. XL: How to Work with Random Access Files
  400. XL2000: Files Corrupted on Save: How to Troubleshoot Source of Problem
  401. XL2000: How to a Make Spinner with a Minimum Value Less Than Zero
  402. XL2000: How to Add a Microsoft Excel 5.0 Dialog Sheet to a Workbook
  403. XL2000: How to Add a New Category to Function Category List
  404. XL2000: How to Add the Workbook Path to the Footer
  405. XL2000: How To Add the Workbook Path to the Title Ba
  406. XL2000: How to Assign a Macro to an ActiveX Worksheet Control
  407. XL2000: How to Attach a Custom Toolbar to a Specific Workbook
  408. XL2000: How to Automatically Set Min and Max Scale for Y-Axis
  409. XL2000: How to Avoid Saving Password in Text File When You Get External Data
  410. XL2000: How to Break Links Between a Chart and a Worksheet
  411. XL2000: How to Call a Macro Repeatedly on a Fixed Time Interval
  412. XL2000: How to Change the Date or Time Format in a Header or Footer
  413. XL2000: How to Change the Font in a Cell Comment
  414. XL2000: How to Change the Paper Source Using the SendKeys Command
  415. XL2000: How to Change the Taper Style for All Series in a Chart
  416. XL2000: How to Check Spelling for Worksheet Objects Only
  417. XL2000: How to Close All Workbooks But One with a Visual Basic Macro
  418. XL2000: How to Compare Data in Two Columns for Duplicates
  419. XL2000: How to Continue a Visual Basic Statement from One Line to the Next
  420. XL2000: How to Control the Appearance of the Mouse Pointer While a Macro Runs
  421. XL2000: How to Control the AutoFilter with a Macro
  422. XL2000: How to Control the Placement of Objects
  423. XL2000: How to Convert a Numeric Value into English Words
  424. XL2000: How to Convert All Files on a Server to Microsoft Excel
  425. XL2000: How to Copy One of Each Record Type to Another Worksheet
  426. XL2000: How to Copy Text to Text Boxes Using the Characters Method
  427. XL2000: How to Copy the Text Within a Text Box to a Cell
  428. XL2000: How to Count Rows Displayed After Data Has Been Filtered
  429. XL2000: How to Create a Chart with Non-Contiguous Ranges
  430. XL2000: How to Create a Dynamic Named Range
  431. XL2000: How to Create a Group of Mutually Exclusive ToggleButton Controls
  432. XL2000: How to Create a Macro That Opens Multiple Selected Files
  433. XL2000: How to Create a Monthly Calendar
  434. XL2000: How to Create a Startup Screen with a UserForm
  435. XL2000: How to Create a Template for a Toolbox Control
  436. XL2000: How to Create and Use a Workbook_BeforeClose Procedure
  437. XL2000: How to Create PivotTable from Word
  438. XL2000: How to Create Unique Random Integers Between Two Numbers
  439. XL2000: How to Create Yes and No Buttons for a Custom Message Box
  440. XL2000: How to Customize a Custom Toolbar Button
  441. XL2000: How to Delete a Collection of Code Objects from a VBAProject
  442. XL2000: How to Delete Cells with a For Each…Next Loop
  443. XL2000: How to Determine If a File Is Read-Only
  444. XL2000: How to Determine If a Variable Is an Array
  445. XL2000: How to Determine If a Workbook or a Worksheet Is Protected
  446. XL2000: How to Determine If the Active Cell Contains a Comment
  447. XL2000: How to Determine the Key Pressed Along with Mouse Button
  448. XL2000: How to Determine Which DLLs Are Registered
  449. XL2000: How to Determine Which Items Are Selected in a List Box
  450. XL2000: How to Display a ComboBox List When a UserForm Is Displayed
  451. XL2000: How to Display a Custom Function in Step 2 of the Function Wizard
  452. XL2000: How to Display a Custom Office Assistant Balloon
  453. XL2000: How to Display a UserForm Whose Name Is in a Variable
  454. XL2000: How to Display the Open and Save As Dialog Boxes
  455. XL2000: How to Display Top 10 Records with a Macro
  456. XL2000: How to Dynamically Resize a User Form
  457. XL2000: How to Enter a Second Line in a Message Box
  458. XL2000: How to Fill List Box Control with Multiple Ranges
  459. XL2000: How to Find Open Programs That Are DDE-Capable
  460. XL2000: How to Force Macro Code to Wait for Outside Procedure
  461. XL2000: How to Get Prime Numbers or Factors
  462. XL2000: How to Hide and Restore a Built-In Menu
  463. XL2000: How to Hide Button Controls with Visual Basic for Applications
  464. XL2000: How to Make a Macro That Automatically Starts When You Open a Workbook
  465. XL2000: How to Manually Recalculate a Single Cell or Range
  466. XL2000: How to Move Between Custom UserForms with Command Buttons
  467. XL2000: How to Obtain the SQL Statement for a PivotTable
  468. XL2000: How to Open a Copy of a Template in Microsoft Excel 2000
  469. XL2000: How to Pass Variables in Visual Basic for Applications Macros
  470. XL2000: How to Place a Check Mark Next to a Custom Menu Item
  471. XL2000: How to Play Sounds Using Visual Basic for Applications
  472. XL2000: How to Populate an Array with a Discontiguous Range
  473. XL2000: How to Populate One List Box Based on Another List Box
  474. XL2000: How to Prevent the Automatic Creation of Hyperlinks
  475. XL2000: How to Programmatically Change the Project Name Property
  476. XL2000: How to Programmatically Convert Column Position Numbers to Column Letters
  477. XL2000: How to Programmatically Copy All Range Names
  478. XL2000: How to Programmatically Create a Chart Without Selecting a Range of Cells
  479. XL2000: How to Programmatically Create a Collection
  480. XL2000: How to Programmatically Create a Reference
  481. XL2000: How to Programmatically Delete and Restore a Menu That Contains a Submenu
  482. XL2000: How to Programmatically Delete Defined Names with Links
  483. XL2000: How to Programmatically Disable Keyboard Functionality
  484. XL2000: How to Programmatically Disable Microsoft Excel Control Menu Commands
  485. XL2000: How to Programmatically Display All Files in a Folder
  486. XL2000: How to Programmatically Find the Nth Word in a Text String
  487. XL2000: How to Programmatically Format Names of Months in All-Capital Letters
  488. XL2000: How to Programmatically Increment a Date With a Spinner
  489. XL2000: How to Programmatically Insert Blank Rows in a Worksheet
  490. XL2000: How to Programmatically Insert Data from a List Box into the Active Cell
  491. XL2000: How to Programmatically Make Sure That Only Numbers Are Entered in a Column
  492. XL2000: How to Programmatically Measure the Visible Range in Points
  493. XL2000: How to Programmatically Modify Hyperlink Addresses on a Worksheet
  494. XL2000: How to Programmatically Perform a Web Query
  495. XL2000: How to Programmatically Reset a Workbook to Default Styles
  496. XL2000: How to Programmatically Save All Open Workbooks
  497. XL2000: How to Programmatically Select Every Nth Row in a Range
  498. XL2000: How to Programmatically Select the Current Data Area Without Selecting the First Row
  499. XL2000: How to Programmatically Subtract or Sum Two Ranges of Data
  500. XL2000: How to Programmatically Sum Only the Visible Cells in a Range
  501. XL2000: How to Programmatically Suppress an Error Value Returned by a Formula
  502. XL2000: How to Record a Macro Using Relative Cell References
  503. XL2000: How to Reduce the Chances of Macro Virus Infectio
  504. XL2000: How to Reference a Cell in the Header or Footer
  505. XL2000: How to Remove All Items from a ListBox or ComboBox
  506. XL2000: How to Remove Individual AutoFilter Drop-Down Lists
  507. XL2000: How to Remove Links from a Worksheet
  508. XL2000: How to Remove the Control Menu and Program Window Controls
  509. XL2000: How to Return Data from a Dialog Box to a Worksheet
  510. XL2000: How to Return Multiple Values from a Custom Function
  511. XL2000: How to Return the Address of the Cell with the Largest or Smallest Value
  512. XL2000: How to Return the Source of a Hyperlink in a Cel
  513. XL2000: How to Return Values from a List Box That Displays Multiple Columns
  514. XL2000: How to Run a WordBasic Macro from a Microsoft Excel Macro
  515. XL2000: How to Secure Visual Basic Code in Excel
  516. XL2000: How to Select Cells/Ranges Using Visual Basic Procedure
  517. XL2000: How to Select Ranges Using Visual Basic for Applications (Novice Examples)
  518. XL2000: How to Send Form Mail That Uses Excel Data
  519. XL2000: How to Set the Default Command Button on a UserForm
  520. XL2000: How to Set the Descriptive Name of an Add-in File
  521. XL2000: How To Share a Custom AutoFill List
  522. XL2000: How to Show Quotation Marks in Function Results and Macros
  523. XL2000: How to Simulate a Paused Visual Basic Procedure
  524. XL2000: How to Simulate Combination List-Edit Control for UserForms
  525. XL2000: How to Sum a Range of Cells Based on a Number Format
  526. XL2000: How to Temporarily Hide a UserForm
  527. XL2000: How to Trap Events for an Embedded Chart
  528. XL2000: How to Turn off Shortcut Menus
  529. XL2000: How to Use “On Error” to Handle Errors in a Macro
  530. XL2000: How to Use a Custom Function in Another Workbook
  531. XL2000: How to use a Macro to Enter Cell Note Text in a Text Box
  532. XL2000: How to Use a UserForm for Entering Data
  533. XL2000: How to Use a Visual Basic Macro to Open and Retrieve a File on the Internet
  534. XL2000: How to Use a Visual Basic Macro to Sort Arrays in Excel
  535. XL2000: How to Use ADO to Return Data to a ListBox or ComboBox
  536. XL2000: How to Use Application.Match to Locate Date Values on a Worksheet
  537. XL2000: How to Use DAO to Create a New Microsoft Excel Workbook
  538. XL2000: How to Use Data Access Objects to Join Tables of Different Formats
  539. XL2000: How to Use Data Validation to Prevent Duplicate Entries
  540. XL2000: How to Use Dynamic Arrays in a Macro
  541. XL2000: How to Use EnableEvents to Disable Event Handling
  542. XL2000: How to Use Input Boxes with Visual Basic for Applications
  543. XL2000: How to Use Macros to Set Row Height and Column Width
  544. XL2000: How to Use the ApplyCustomType Method to Format Charts
  545. XL2000: How to Use the Imp Operator for Binary Comparison
  546. XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events
  547. XL2000: How to Use the RefEdit Control with a UserForm
  548. XL2000: How to Use the SelectionChange Event to Make the Active Row Bold
  549. XL2000: How to Use the TabStrip Control on a UserForm
  550. XL2000: How to Use the TextColumn Property
  551. XL2000: How to Use Visual Basic Code to Total Rows and Columns in an Array
  552. XL2000: How to Use Visual Basic Constants in Text Strings
  553. XL2000: How to Use Visual Basic to Create a Dynamic Chart
  554. XL2000: How to Use Visual Basic to Play an AVI File
  555. XL2000: How to Verify the Value of a CheckBox on a UserForm
  556. XL2001: How to Use Dates and Times in Microsoft Excel
  557. XL2002: How to Automate Smart Tags by Using Visual Basic for Applications
  558. XL2002: How to Delete Cells with a For Each…Next Loop
  559. XL2002: How to Determine If Your Workbook Contains Links to External Data
  560. XL2002: How to Mark an Automation Add-In Function as Volatile
  561. XL2002: How to Prevent the Automatic Creation of Hyperlinks
  562. XL2002: How to Programmatically Reset a Workbook to Default Styles
  563. XL2002: How to Programmatically Turn Off the Clipboard Warning Message
  564. XL2002: How to Recover a Lost Worksheet or Lost Version of a Workshee
  565. XL2002: How to Remove Smart Tags from a Workbook
  566. XL2002: How to Select Cells/Ranges Using Visual Basic Procedures
  567. XL2002: How to Select Ranges Using Visual Basic for Applications (Novice Examples)
  568. XL2002: How to Suppress #DIV/0! Error Value in Division
  569. XL2002: How to Use Auto Fill Options Smart Tags
  570. XL2002: How to Use the “Insert Options” Button in Excel 2002
  571. XL97: How to Assign a Macro to an ActiveX Worksheet Control
  572. XL97: How to Change the Depth of a 3-D Surface Chart
  573. XL97: How to Change the Font in a Cell Comment
  574. XL97: How to Change the Font in a Commen
  575. XL97: How to Change the Taper Style for All Series in a Chart
  576. XL97: How to Control the Placement of Objects
  577. XL97: How to Convert All Files on a Server to Microsoft Excel
  578. XL97: How to Convert an Add-in File into a Workbook
  579. XL97: How to Create a Conditional Format to Hide Errors
  580. XL97: How To Create a Dynamic Chart Using Visual Basic
  581. XL97: How to Create a GIF File from a Microsoft Excel Chart
  582. XL97: How To Create a Group of Mutually Exclusive ToggleButtons
  583. XL97: How to Create a Pie Of Pie Chart or a Bar Of Pie Chart
  584. XL97: How to Create a Report Templat
  585. XL97: How to Create a Startup Screen with a UserForm
  586. XL97: How to Create a Template for a Toolbox Control
  587. XL97: How to Create an Add-in File in Microsoft Excel 97
  588. XL97: How to Create Application Level Event Handlers
  589. XL97: How to Create PivotTable from Word
  590. XL97: How to Create Web Query (.iqy) Files
  591. XL97: How to Customize a Custom Toolbar Button
  592. XL97: How to Delete Cells with a For Each…Next Loop
  593. XL97: How to Delete, Restore, and Edit Menu Items Manually
  594. XL97: How to Determine If the Active Cell Contains a Comment
  595. XL97: How to Determine the Key Pressed Along with Mouse Button
  596. XL97: How to Determine Which Items Are Selected in a ListBox
  597. XL97: How to Disable Shortcut Menus
  598. XL97: How to Display a ComboBox List When UserForm Is Displayed
  599. XL97: How to Display a Custom Office Assistant Balloon
  600. XL97: How to Display a Progress Bar with a User Form
  601. XL97: How to Display a UserForm Whose Name Is in a Variable
  602. XL97: How to Display Custom Function in Function Wizard Step 2
  603. XL97: How to Dynamically Resize a User Form
  604. XL97: How to Fill ListBox Control with Multiple Ranges
  605. XL97: How to Import Web Page Tables into Microsoft Excel
  606. XL97: How to Link to a Particular Worksheet from a Web Page
  607. XL97: How to Modify the Number of Undo Levels
  608. XL97: How to Move Between Custom UserForms with CommandButtons
  609. XL97: How to Obtain and Install the Excel 97 SYLK File Security Update
  610. XL97: How to Obtain the Excel 97 Auto Recalculation Patch
  611. XL97: How to Place a Checkmark Next to a Menu Item
  612. XL97: How to Plot Values Against a Recommended Range
  613. XL97: How to Populate One ListBox Based On Another ListBox
  614. XL97: How to Programmatically Change the Format of a User Input After Data Entry
  615. XL97: How to Programmatically Change the Project Name Property
  616. XL97: How to Programmatically Create a Collection
  617. XL97: How to Programmatically Create a Reference
  618. XL97: How to Programmatically Perform a Web Query
  619. XL97: How to Programmatically Reset a Workbook to Default Styles
  620. XL97: How to Programmatically Save a Worksheet as HTML
  621. XL97: How to Record a Macro Using Relative Cell References
  622. XL97: How to Remove All Items from a ListBox or ComboBox
  623. XL97: How to Remove Individual AutoFilter Drop-Down Lists
  624. XL97: How to Rename a Chart Using Name Box
  625. XL97: How to Restore a Built-In Menu
  626. XL97: How to Restrict Numeric Entry to Only One Cell in a Range
  627. XL97: How to Save Files in Other Formats
  628. XL97: How to Simulate a Paused Visual Basic Procedure
  629. XL97: How to Sort Cells Without Sorting Linked Cells
  630. XL97: How to Specify Dynamic Web Query Parameters
  631. XL97: How to Temporarily Hide a UserForm
  632. XL97: How to Trap Events for an Embedded Chart
  633. XL97: How to Turn Off Automatic Font Scaling in All Charts
  634. XL97: How to Use a Toolbar Settings File from a Network Share
  635. XL97: How to Use a UserForm for Entering Data
  636. XL97: How to Use a Web Data Source for a PivotTable
  637. XL97: How to Use Custom Toolbars in Excel5.xlb
  638. XL97: How to Use Data Validation to Prevent Duplicate Entries
  639. XL97: How to Use EnableEvents to Disable Event Handling
  640. XL97: How to Use Excel Startup Folders
  641. XL97: How to Use FileSearch to Fill a Listbox with File Names
  642. XL97: How to Use Natural Language Formulas
  643. XL97: How to Use the ApplyCustomType Method to Format Charts
  644. XL97: How to Use the EFFECT and NOMINAL Functions to Calculate Loan or Mortgage Interest with Intrayear Compounding
  645. XL97: How to Use the GetOpenFilename Method
  646. XL97: How to Use the GetPivotData Worksheet Function
  647. XL97: How to Use the Internet Assistant Wizard
  648. XL97: How to Use the PivotTable AutoShow Feature
  649. XL97: How to Use the PivotTable AutoSort Feature
  650. XL97: How to Use the Query Before and AfterRefresh Events
  651. XL97: How to Use the TextColumn Property
  652. XL97: How to Use Wildcards in Parameter Queries
  653. XL97: How to Verify the Value of a CheckBox on a UserForm
  654. XL97: How to View Sample Chart with the Keyboard
  655. XL98: How to Add the Workbook Path to the Footer
  656. XL98: How to Delete Cells with a For Each…Next Loop
  657. XL98: How to Programmatically Reset a Workbook to Default Styles
  658. XL98: How to Select Chart Subtype by Using Keyboard
  659. XL98: How to Use the Virus Search Add-in for Microsoft Excel 98

Leave a Comment

You must be logged in to post a comment.