Home > Excel Help Portal > Excel Worksheets

<<  (Page 3)  Previous              Next  (Page 1)  >>

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.

151. Linking comboboxes with Data Validation For example, John asks "I have a list of countries (USA, Australia, England), and a list of cities. How can I make than when the user selects USA in one cell, in the other one appear only cities from USA (New York, Los Angeles), and also for Australia (Camberra, Perth), etc. ?"The first thing that... Keywords: VBA, Web, Validation, INDIRECT

 
152. How to create an Addin Application Name and Description in Excel 2000 This step-by-step article demonstrates how to create a name and description for an add-in application. In Microsoft Excel, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom... KB#214298. Keywords: Add-In, Comments

 
153. Elapsed Time Counting Techniques Keywords: Criteria, Days, Format, Web, Comments, OFFSET, COUNTIF

 
154. The FORECAST, STEYX, SLOPE and INTERCEPT functions cause different results in Excel 2003 than in earlier versions of Excel When you use the FORECAST, STEYX, SLOPE or INTERCEPT functions in a Microsoft Office Excel 2003 worksheet, you may receive different results than you did when you used these functions in earlier versions of Microsoft... KB#834521. Keywords: INTERCEPT

 
155. Application Error in Module Excel.exe at Offset 0001d05f You may receive an application error message with the following attributes: Event: Application Failure Application: excel.exe Version: 10.0.3506.0 Module: excel.exe Module Version: 10.0.3506.0 Offset:... KB#321312. Keywords: Errors, Error Message, File Name, Files, Parse

 
156. How to Use Excel to Generate Reports for Mailbox Resources The Exchange Administrator program of Exchange 2000 can export mailbox or public folder resource reports to a .csv file. This article describes how to generate reports for your mailbox resources by using Microsoft Excel to work with an imported... KB#328827. Keywords: Sorting, Export, File Name, Window

 
157. Justify Command Does Not Insert Spaces Between Text from Each Cell When you select text in separate cells, if there is not a space between the last word in a cell, and the first word in the following selected cell(s), the space is not inserted when you use the Justify command (on the Edit menu, point to Fill... KB#252730. Keywords: Search

 
158. How to Change the Font in a Comment This article explains how to change the font (style, size, and color) for the text of a comment in Microsoft Excel... KB#166254. Keywords: Colors, Fonts, Format

 
159. Articles about troubleshooting errors in worksheets in Excel It can be challenging to find the cause of error messages in Microsoft Excel worksheets. This article lists many Microsoft Knowledge Base articles about troubleshooting error messages in Excel... KB#293412. Keywords: Arrays, Errors, Formulas, Window

 
160. Logical Expressions Keywords: VBA, Web, Comments

 
161. Keep Excel in focus Jose Luis asks "When I call Help without using the assistant (F1) Excel resizes itself to allow the Help window and the spreadsheet to be visible at the same time. Is there anything I can do to prevent this ? I want Excel to stay maximized and so the help file."To modify this behavior there's one... Keywords: VBA, Registry, Web, Window

 
162. Inputbox to accept specific data This macro will continue to ask the user for a number between 1 and 10 or will stop if he/she... Keywords: Macro, VBA, Web, Validation

 
163. Dialing Phone Numbers the Windows 95 Dialer and Windows3.11 Cardfile Simple VBA macro that uses Shell and SendKeys commands to dial a phone number using the Windows95 dialer applet or Window 3.11 Cardfile Autodialer. You can use the Shell command in VBA to start the Dialer Windows application and dial a phone number with your computer's modem. The combination of the... Keywords: Download, Format, Macro, VBA, Window

 
164. How to use Find to Search Multiple Worksheets in Excel 2000 This step-by-step article shows you how to search for data in more than one sheet in a workbook without searching each sheet individually. This is helpful if you want to find data and do not know which sheet the data is on. Search Multiple... KB#286142. Keywords: Search

 
165. Make the Header Row stay visible as you scroll through data set up you window so that the header row is the top row in the window. Then, put your cell pointer in column A, in the row just below the headers. From the menu, choose Window - Freeze Panes. Anything visible in the window above and to the left of the cell pointer will remain visible as you scroll... Keywords: VBA, Web, Window

 
166. Freeze pane for select rows and columns Row 1 and Column A should be frozen 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... Keywords: VBA, Web

 
167. Paint Job, Coverage Example Keywords: Web, Comments, VLOOKUP, ROUNDUP

 
168. Protecting specified data using VBA Regards"Well, this can be solved using some events. One, using the Workbook_Open event, or two, using the Sheet_Activate event, like this:In the workbook... Keywords: VBA, Web, Window

 
169. Freeze the Headers so they are always visible as the cell pointer scrolls deeper into the worksheet 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: Printing, VBA, Web, Window

 
170. Conversion of Feet and Inches to Decimal Values Two Visual Basic for Applications User Defined Functions, one to convert from decimal inches to feet, inches and fractions. The second function converts from feet and inches to decimal inches. You can create these User Defined Functions: CFeet converts from decimal inches to feet, inches and... Keywords: Download, Format, User Defined Function, VBA, Comments

 
171. Custom Dialog Example This is an example of a simple Visual Basic for Applications procedure that displays a custom dialog box and updates a data base. You can create a custom dialog that updates a database with a Visual Basic for Applications procedure. The dialog can add new records, and edit or delete existing... Keywords: Download, Format, VBA, Comments

 
172. Input Validation Excel's OnEntry property provides a way to validate data entered in a worksheet cell. You can set a worksheet's OnEntry property in an Auto_Open macro. When data is entered in a cell on the worksheet, the macro specified in the OnEntry property will run. If the data is not valid, the OnEntry... Keywords: Download, Format, Errors, Macro, OnEntry, Error Message, Validation

 
173. Answer to Challenge of the Month Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of Tickling Keys, Inc. All contents Copyright 1998-2004 by MrExcel... Keywords: Add-In

 
174. Use SUMIF instead of D... functions When you need to analyze a list of data then you can set up criteria ranges and use database functions like DSUM, DAVERAGE or DCOUNT - OR, take a shortcut and use SUMIF and COUNTIF. These functions have built in criteria ranges, so you save time. =SUMIF(C16:C:45,"10.2",G16:G45) will sum all the... Keywords: Criteria, DAVERAGE, DCOUNT, COUNTIF

 
175. Feet and Inches Tutorial Conversion of Feet and Inches to Decimal Values You can create these User Defined Functions: CFeet converts from decimal inches to feet, inches and fractions of inch. The second parameter of CFeet specifies the smallest fraction of inch for rounding. If omitted, fractions are rounded to 9999th's of... Keywords: Search

 
176. Help Search - Search Mr Excel Tips and Articles Excel is a registered trademark of the Microsoft Corporation. All contents Copyright 1998-2002 by MrExcel... Keywords: Search

 
177. Training - Advanced Excel Training from Mr Excel Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of Tickling Keys, Inc. All contents Copyright 1998-2003 by MrExcel... Keywords: Search

 
178. Plotting Zero and Missing (Empty) Values You can use menu choices Tools, Options and set the Empty cells plotted as values as shown below. When you choose Empty cells plotted as Not Plotted (leave gaps), you chart appears... Keywords: Charts

 

<< (Page 3)  Previous              Next  (Page 1) >>