Home > Excel Help Portal > Excel Worksheets

<<  (Page 2)  Previous              Next  (Page 4)  >>

Excel Worksheets

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to use Microsoft
Excel worksheets.

101. How to Populate One ListBox Based On Another ListBox This article contains an example of using the selected item in one ListBox control on a UserForm to determine the list that will populate a second ListBox... KB#161518. Keywords: VBA, UserForm, Web, Window

 
102. How to Add New Data to a Data Map Chart In Microsoft Excel, you can add additional columns of data or new rows of data to an existing data map. However, when you insert the new data, you need to include the matching column of geographic... KB#147737. Keywords: Charts, Discontiguous

 
103. How to Display a ComboBox List When a UserForm Is Displayed When a UserForm is displayed, you can display the list for a ComboBox control by using the Activate event for the UserForm. This article includes an example that uses the DropDown method of a ComboBox and the Activate method of a UserForm... KB#213718. Keywords: VBA, UserForm, Web, Window

 
104. How to Make a Macro That Automatically Starts When You Open a Workbook One way to automatically run a macro when you open a workbook is to use the Workbook_Open event in Microsoft Excel. Workbook_Open is a built-in workbook event that runs its macro code each time you manually open the workbook. The following... KB#265113. Keywords: VBA, Macro, Object, Web, Window

 
105. How to Simulate Combination ListEdit Control for UserForms When you use a UserForm in Microsoft Excel 2000, there is no control that is equivalent to the combination list-edit control for custom dialog boxes in versions of Excel before Excel 97. You can simulate the behavior of a combination list-edit box... KB#211896. Keywords: Text Box, VBA, UserForm, Web, Window

 
106. How to Programmatically Make Sure That Only Numbers Are Entered in a Column This article contains a sample Microsoft Visual Basic for Applications Sub procedure (macro) that you can use to ensure that only a certain type of data entry occurs. The macro in this article requires a user to enter only numbers in a specific... KB#213358. Keywords: VBA, Macro, Web, Validation

 
107. How to use a Macro to Enter Cell Note Text in a Text Box This article describes how to put the text of a cell's comment (cell note) into a text box. A macro that does this may be especially helpful because you do not have the ability to manually copy text from the comment dialog box and paste it into a... KB#213623. Keywords: Text Box, VBA, Macro, Web, Cell Note

 
108. Cannot Delete Entries from AddIns Dialog Box When you click Add-Ins on the Tools menu, you may be unable to delete an item from the Add-Ins available list in the Add-Ins dialog... KB#211956. Keywords: Add-In, Third-Party, Registry, Window

 
109. How to Recover a Lost Worksheet or Lost Version of a Worksheet If you mistakenly delete, lose, save over the top of, or do not save an Excel 2002 worksheet, you may be able to recover it. Excel 2002 has an AutoRecover feature that automatically saves worksheets in the case of accidental loss of power or... KB#324521. Keywords: File Name, Files

 
110. How to Determine If the Active Cell Contains a Comment This article discusses ways to programmatically determine whether a cell contains a comment and discusses compatibility issues with earlier versions of Microsoft... KB#259292. Keywords: VBA, Macro, Object, Web, Comments

 
111. How to Scroll Window Views from Object to Object By using Microsoft Visual Basic for Applications code, you can scroll from object to object on a sheet without changing the current cell selection. The ActiveWindow methods, ScrollColumn and ScrollRow, control the position of the current Window... KB#147190. Keywords: Errors, VBA, Macro, Object, Web, Window

 
112. How to Display the "What's New in Excel" Window When you run Microsoft Excel version 7.0 for the first time, the What's New in Microsoft Excel 95 window is displayed. Although this window doesn't appear the next time you run Microsoft Excel, you can display the What's New in Microsoft Excel... KB#137524. Keywords: Setup, Setup Program, Window

 
113. How to Create a Startup Screen with a UserForm In Microsoft Excel 97, you can use a custom UserForm and a Visual Basic for Applications macro to create a startup screen (splash screen). This article describes how to create a custom splash screen for a specific... KB#158848. Keywords: Startup, VBA, Macro, Object, UserForm, Web

 
114. Updating Distribution Lists Linda sent in today's question: One of my Outlook contacts is incorrectly set to send e-mail to the wrong address. I can change it, but the mail sent to the MyTeam distribution list still goes to the old address. Why?Interesting problem. I wonder why Microsoft does not update the distribution lists... Keywords: VBA, Web, Window

 
115. How to Create a Startup Screen with a UserForm In Microsoft Excel 2000, you can use a custom UserForm and a Visual Basic for Applications macro to create a startup screen (splash screen). This article describes how to create a custom splash screen for a specific... KB#213774. Keywords: Startup, VBA, Macro, UserForm, Web

 
116. UserDefined Clip Art from Earlier Versions Is Unavailable When you open Microsoft Clip Organizer for the first time, you cannot locate custom clip art that you imported into earlier versions of Microsoft Clip Gallery. You cannot find these clips either by browsing or by keyword... KB#281858. Keywords: Search

 
117. How to Parse Data Using the Text To Columns Command This article contains information about how to parse data in Microsoft Excel by using the Text To Columns... KB#142149. Keywords: Parse

 
118. How to Create a Macro That Counts Comments In Microsoft Excel, you can insert notes (comments) when you do not want to display comments on your worksheet or when you want to print comments on a separate sheet. The More Information section of this article contains sample Microsoft... KB#213638. Keywords: Printing, VBA, Macro, Web, Comments

 
119. How to Recover a Lost Workbook or a Lost Version of a Workbook If you delete, lose, save over, or do not save an Excel 2003 workbook, you may be able to recover it. Excel 2003 has an AutoRecover feature that automatically saves workbooks when you have an accidental loss of power or similar... KB#827298. Keywords: File Name, Files

 
120. How to use Functions in Formulas in Excel 2000 This step-by-step article explains how to use functions in formulas in Excel 2000. A formula is an equation that performs operations on worksheet data. Formulas can perform mathematical operations, such as addition and multiplication, or they... KB#304423. Keywords: Formulas, Toolbar

 
121. Data Validation dropdowns disappear after freeze panes Caroline from the U.K. came up with this problem. I have a forecasting worksheet that has been in use for several weeks without a problem. The worksheet has Data Validations with dropdown boxes in columns C & D. I changed some fonts and repositioned the frozen window so that the user can see... Keywords: Forecasting, Fonts, Errors, VBA, Error Message, Web, Validation, Window

 
122. How to Create a Single Stacked Column or Bar Chart In Microsoft Excel, you can create a single stacked column or bar... KB#151353. Keywords: Bar Chart, Charts, Legend, SERIES, Format

 
123. How to Create and Use a Workbook_BeforeClose Procedure You can run a Microsoft Visual Basic for Applications macro ( Sub procedure) every time a particular workbook is closed, by attaching the procedure to the BeforeClose event of the workbook. This article contains sample code that illustrates how to... KB#213639. Keywords: Format, VBA, Macro, Object, Web

 
124. How to Manage Multiple Windows in Excel In Microsoft Excel, you can open multiple windows into a workbook (document). By doing so, you can gain access to different areas of your workbook... KB#254791. Keywords: Window

 
125. How to Create Addin Application Name and Description In the versions of Microsoft Excel listed above, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom menus, toolbars, and procedures. To create a name and description for your... KB#108425. Keywords: Add-In, Comments

 
126. Names Keywords: Formulas, Web, Comments

 
127. An Additional "Object" Workbook Opens and Excel Appears to Stop Responding When you double-click a Microsoft Excel workbook, a blank workbook that is named Object may open with the workbook that you double-clicked. If you quit Excel, and then double-click a workbook, Excel appears to stop responding (hang). The... KB#811344. Keywords: Download, Toolbar, Internet Explorer, Web, Window

 
128. Office 2003 documents take longer than expected to open in Internet Explorer Fixes the problem that occurs when Office documents, Word documents, Excel workbooks, or PowerPoint presentations, take longer than expected to open in the Internet Explorer browser... KB#837255. Keywords: Registry, HTML, Internet Explorer, Window

 
129. How to use the Error Checking Options Button in Excel 2002 This article explains the functionality of the Error Checking Options button in Microsoft Excel. Error Checking Options The Error Checking Options button is displayed when the formula in an Excel worksheet cell triggers an error. In addition to... KB#291361. Keywords: AutoCorrect, Errors, Formulas, Formula Auditing, Smart Tag

 
130. How to Copy Column Widths In Microsoft Excel, you can copy the column width when you copy data from one range of cells to another by selecting the entire column when you copy it. You can also copy column widths separately from your... KB#61269. Keywords: Column Width

 
131. How to Parse Data Using the Text To Columns Command This article contains information about how to parse data in Microsoft Excel by using the Text To Columns... KB#214261. Keywords: Parse

 
132. How to Attach a Custom Toolbar to a Specific Workbook When you create a custom toolbar in Microsoft Excel, you may want the toolbar to be visible when a particular workbook is open. This article explains how to configure the workbook to display the toolbar when the workbook is... KB#304419. Keywords: Errors, VBA, Toolbar, Web

 
133. Run a macro when any cell changes Several readers have asked questions which require Excel to run a section of macro every time a value changes. First, the improved method available only in XL97: Excel 97 has some new event handlers that allow a macro to be run every time a cell changes. Let's say that anytime a value greater than... Keywords: Format, Macro, OnEntry, VBA, Web

 
134. Return to Previously Selected Sheet nxtsheets(nxtsheets(0)) =... Keywords: Links, VBA, Toolbar, Hyperlinks, Web, Comments

 
135. Workspace Doesn't Retain Window Size When you open a workspace (*.xlw) file in Microsoft Excel, the window state is not retained. Instead, the windows appear in the restored... KB#160264. Keywords: VBA, Macro, Web, Window

 
136. Pasted Text is Inexplicably automatically parsed MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: VBA, Web, Parse

 
137. Event handler to play midi file Dan from Wauconda posed this week's question. I have a worksheet that calculates a value. If the cell value is 100 I need a midi file to be played. This tip makes use of the event handlers discussed here on December 23rd. If you are not familiar with event handlers, please review that tip first.... Keywords: VBA, Macro, Object, Web

 
138. Excel -- Comments -- Tips Tips Change the User Name Change Comment Shape Add a Picture to a Comment Change the default Font Size Alternative to Cell Comments You can change the font size of new comments by changing the settings in your Control Panel. (Instructions for Windows XP) Add a comment to a Data Validation Input... Keywords: Borders, Colors, Fonts, Printing, Comments, Validation

 
139. The 'Mail Recipient (as Attachment)' Option Is Missing Even when Microsoft Outlook is set as your default e-mail program, one or more of the following syptoms may occur: The menu item Mail Recipient (As Attachment) is missing on the File, Send To menu of Office 2000 programs. The menu item... KB#249786. Keywords: API

 
140. SAVE file problems Keywords: Errors, Error Message, File Name, Save A File, Web, Comments

 
141. How to Remove Entries from AddIns Dialog Box When you click Add-Ins on the Tools menu, you cannot delete an add-in from the list of Add-Ins available in the Add-Ins dialog... KB#161439. Keywords: Add-In, Files, Registry

 
142. How to Import and Export Works Spreadsheets to Excel 97 This article discusses how to convert spreadsheet documents between the versions of Works listed at the beginning of this article and Microsoft Excel... KB#163109. Keywords: Export, Startup, Files, Window

 
143. Charting 101 - Making Your First Chart in Microsoft Excel The first step to making our chart is to select the range of data to be charted. Excel is pretty good about detecting header rows and columns in a selected range, especially if the upper left cell is kept blank. I know it's hard for us compulsive types to leave a header cell blank, where our... Keywords: Charts, Discontiguous

 
144. Cell Comments -- Example Coding used on this page can be found in http://www.mvps.org/dmcritchie/code/comment.txt and in http://www.mvps.org/dmcritchie/code/join.txt The following spreadsheet was generated by the CommentTestGeneration Macro which simply served to create some test data with text and comments. The range... Keywords: Printing, Macro, Web, Comments, PROPER

 
145. Incorrect Range of Values Displayed on XAxis of XY (Scatter) or Bubble Chart When you create a chart in Microsoft Excel 2000, or open a chart that you created in an earlier version of Excel, and hide a row on the worksheet, the scale of values displayed on the x-axis of the chart changes to an incorrect... KB#237884. Keywords: Charts, Discontiguous

 
146. How to Center Numbers and Have Decimals Line Up in Excel In Microsoft Excel, you can center your data in a column on a worksheet so that the decimals appear to line... KB#44737. Keywords: Custom Number Formats, Column Width

 
147. How to use the Keyboard to Change the Active Cell in Excel 2000 This step-by-step article describes how to use the keyboard to change the active cell in an Excel worksheet. Press CTRL+PERIOD This method is an undocumented navigation keystroke. To do this, follow these steps: Select a range of cells.... KB#200724. Keywords: RIGHT, LEFT

 
148. Excel Crash on Mouse-over of object Bill writes: I have a document that has become very unstable. Every time that my mouse gets near one of the red comment triangles, Excel will crash.After looking at Bill's worksheet, I found a somewhat innocuous macro that was causing the problem. In an effort to clear out some pictures and command... Keywords: Macro, VBA, Web, Comments

 
149. Errors For some background information, please see HELP (F1) for ISERROR. ISERR Value refers to any error value except #N/A. ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). ###### The ##### indicates that the number value for the cell as formatted is too... Keywords: Dates, Format, Errors, Formulas, Macro, Toolbar, Comments, INDEX

 
150. How to change the Font in a Comment in Excel 2000 This article explains how to change the font (style, size, and color) for the text of a comment in Microsoft Excel. To add a comment to the active cell, click Comment on the Insert menu, and then type your text in the yellow comment box. How to... KB#211883. Keywords: Fonts, Format

 

<< (Page 2)  Previous              Next  (Page 4) >>