Home > Excel Help Portal > Customizing Excel

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

Customizing Excel

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

1. How to send Form Results to a Microsoft Excel Worksheet Using FrontPage 2000 You can create a form in Microsoft FrontPage 2000 and have the results from the form written to a Microsoft Excel 2000 workbook. This article gives an example of how to create the workbook and form, and then how to connect them.Microsoft... KB#308692. Keywords: Text Box, Errors, Error Message, File Name, Files, Web

 
2. How to determine the Order in Which Shapes Are Added to Diagrams in Office Programs This step-by-step article describes the order in which shapes are added to diagrams. When you add a new shape to a conceptual diagram in Microsoft Office XP, the decision about how and where the shape is added depends on the type of diagram.... KB#293184. Keywords: Text Box, AutoFormat, Colors, Styles

 
3. Easy instructions to create a user form Excel 97 introduced new User Forms. In English, teach me how to create and use a list box. Mr. Excel recently completed a custom application for one of our readers. In this Excel App, the user would enter 150 data points for a specific part number on sheet 1. At the click of a button, this part... Keywords: Text Box, Errors, Combo Box, VBA, Macro, UserForm, Web, Window

 
4. Latest Information About How to Use Microsoft Office with the Norton AntiVirus Microsoft Office PlugIn The Norton AntiVirus plug-in for Microsoft Office scans documents for macro virus infections in Office products. This plug-in may cause performance issues, the inability to open files within Office, or the inability to install some... KB#329820. Keywords: Third-Party, Macro, Files, Web

 
5. Office 2000 Correct Flipped Pictures Addin When you open a file in Microsoft Word 2000, Microsoft PowerPoint 2000 or Microsoft Excel 2000, all your pictures appear the way that you want. However, when you open your file in an Office XP program or share your file with an Office XP user,... KB#823734. Keywords: Add-In, Download, OLE, Errors, Files, Registry, Links, Scenarios

 
6. How to Use Visual Basic Constants in Text Strings Microsoft Visual Basic for Applications includes a number of intrinsic constants that you can use in macro code to insert certain formatting characters, such as tabs, line feeds, and carriage returns. This article contains information about... KB#211774. Keywords: Text Box, Format, Macro, VBA, Web

 
7. How to Temporarily Hide a UserForm In versions of Microsoft Excel earlier than Excel 97, if you use the Hide method to hide a custom dialog box, Excel does not hide the dialog box until the macro that contains the Hide method is finished running. In Excel 2000, if you use the... KB#213744. Keywords: Text Box, Command Button, VBA, Macro, UserForm, Web

 
8. How to Use a UserForm for Entering Data In Microsoft Excel, you can create a custom UserForm that provides a simple interface for entering data. This article includes steps for creating a custom UserForm and a sample Microsoft Visual Basic for Applications macro that places the data... KB#213749. Keywords: Text Box, Command Button, VBA, Macro, Object, UserForm, Web

 
9. Cannot see data that you copy from Excel 2002 in FrontPage 2002 preview When you copy a range of data from Excel 2002 and then paste it into a Web page in Front Page 2002, not all copied data appears in the table in the Front Page Preview view. The columns that are adjacent to the hidden column do not appear in... KB#811207. Keywords: Dates, Format, File Name, Files, Web

 
10. How to Move Between Custom UserForms with Command Buttons When you create a project with multiple UserForms, you can use command buttons to move between the UserForms. This article explains how to create two UserForms and includes a sample Visual Basic for Applications macro that moves between the... KB#213747. Keywords: Text Box, Command Button, VBA, Macro, UserForm, Web

 
11. How to configure a System Policy to Control the Recently Used File List in an Office XP Program In the Office XP programs listed at the beginning of this article, you can control whether the user sees a list of recently used documents on the File menu and how many file names are displayed in the list. This list is technically referred to as... KB#307949. Keywords: Files, Registry, Templates

 
12. How to Insert Scanned Images in Microsoft Office 2003 Programs In the programs that are listed in the Applies to section of this article, you can use a scanner to insert images in a document. This article describes two methods that you can use to insert images in a document, and when to use each method. back... KB#827100. Keywords: Camera, Printing, Web

 
13. How to insert a Picture into the Header or the Footer in Excel 2003 This article describes how to insert a picture into the header or the footer of an Excel 2003 worksheet. back to the top How to Insert a Picture in the Header or the Footer In Excel 2003, a new permits you to insert pictures into the header or... KB#826918. Keywords: Graphic, Ratio, Format

 
14. Running an Excel Macro from a Command Button on the Spreadsheet You've written the perfect macro using Excel VBA. Rather than having to remember a shortcut key, you would like to add a button to the worksheet to invoke the macro. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied,... Keywords: AutoShapes, ActiveX, Fonts, Format, Command Button, Macro, VBA, Toolbar, Web

 
15. How to Check Spelling for Worksheet Objects Only In Microsoft Excel, you can check spelling for just the objects on a worksheet. You can do this manually or with Microsoft Visual Basic for Applications... KB#142531. Keywords: AutoShapes, VBA, Macro, Object, Web

 
16. Drawings in Files That Are Created in Versions of Excel Before Excel 97 Are Not Displayed Correctly Embedded metafiles in Excel 2000 spreadsheets may not be displayed properly on a Windows 2000-based system. The layering may appear jumbled, hiding parts of the drawings. If the problem objects are manually ungrouped, large areas of... KB#321244. Keywords: Metafiles, Dates, File Name

 
17. How to Create a Masked Password Dialog Box in Visual Basic for Applications In Microsoft Excel, you can create a custom dialog box to prompt a user for information by using text boxes, buttons, or other dialog box controls. Typically, when you type text in a text box, the text appears as you type. However, you can use... KB#830258. Keywords: Text Box, Password, Command Button, VBA, Object

 
18. How to Check Spelling for Worksheet Objects Only In Microsoft Excel, you can check spelling for just the objects on a worksheet. You can do this manually or with Microsoft Visual Basic for Applications... KB#213608. Keywords: AutoShapes, VBA, Macro, Object, Web

 
19. How to handle Corrupted Excel Files by Saving Them in the SYLK Format This step-by-step article describes how to use the SYLK format to save corrupted files. If you suspect that you have a corrupted Microsoft Excel file and you can open the file, you can use the method in this article to filter the file. This... KB#300639. Keywords: Graphic, Format, Corrupted, Files

 
20. Some Text Box Hyperlinks Do Not Work After You Save a Workbook As a Web Page When you save an Excel workbook as a Web Page, text boxes that contain a hyperlink may not work when you view the Web page in your Web... KB#826091. Keywords: Text Box, Registry, Hyperlinks, Web

 
21. Excel -- Data Entry Data Entry Tips Enter Data Quickly -- Keyboard Enter Data Quickly -- Mouse Enter Data in a List Enter the current Date Enter the current Time Copy Value from cell above Copy Formula (exact) from cell above Copy Formula (relational reference) from cell above Ctrl + Enter Use Excel's built-in Data... Keywords: Text Box, Formulas

 
22. Dragging a Drawing Object into Clip Gallery Creates a GIF Graphic This article describes how to create new .gif files in Clip Gallery by dragging vector-based images, AutoShapes, or groups of AutoShapes from PowerPoint, Word, or Excel into Clip Gallery. Note that if you drag these objects from Microsoft... KB#218541. Keywords: AutoShapes, Object, Files

 
23. Format Controls Are Not Available in the Command and Options Dialog Box When you save a workbook in Microsoft Office Excel 2003 as a Web page with interactivity, the worksheet controls on the Workbook's toolbar and on the Format tab in the Command and Options dialog box may be unavailable. You can see this symptom if... KB#813975. Keywords: Format, Errors, Password, Toolbar, Web

 
24. Screen Flickers Constantly After Pasting Excel Chart When you paste a Microsoft Excel chart into a Microsoft Word document, the chart resizes constantly, causing the display to flicker. Both programs may stop responding... KB#150491. Keywords: Charts, Text Box, Format, Links

 
25. Lines Drawn Incorrectly on Imported Graphics When you insert a graphic file into a Microsoft Office program, the graphic may not be displayed properly. Specifically, dashed or dotted lines in the graphic may not be drawn... KB#151068. Keywords: Graphic

 
26. Using Custom Chart Markers in XY Chart When you have an XY chart with many data points, the standard chart markers can become too large to show your data. Here is a simple procedure to replace the standard XY chart markers with a smaller marker. The first method uses a drawing object. As shown in the example below, a small circle... Keywords: Charts, SERIES, Graphic, Download, Object

 
27. Excel -- Conditional Formatting 3. Leave the first drop-down box set to Cell Value Is 4. In the second drop-down box, choose one of the operators. In this... Keywords: Download, Borders, Colors, Conditional Formating, Fonts, Patterns

 
28. Rotating Text With an AutoShape If you use Excel's AutoShapes, you've probably discovered a limitation: If you add text to an AutoShape, the text is not rotated when the AutoShape is rotated.Method 1 Here's one way to circumvent that problem: Create your AutoShape, add text, and format it to your liking. Ctrl+Click the AutoShape... Keywords: Charts, AutoShapes, Graphic, Format, Formulas, Printing

 
29. Working with Userform controls Use the .SetFocus command:Me.TextBox3.SetFocus 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... Keywords: Text Box, Command Button, VBA, Web

 
30. Excel -- Conditional Formatting -- Multiple Cells download a sample file 3. From the first drop-down list, choose Formula Is 4. In the text box, enter a formula that refers to the active cell in the selection. In this example, the formula is: =$B275 Use an absolute reference to column B ($B), to ensure that... Keywords: Download, Colors, Format, Formulas

 
31. Displaying a value in an AutoShape You want to make a particular value really stand out? Use an AutoShape. First, click the AutoShapes button on the Drawing toolbar, select the shape you want to use by clicking it, and click in the formula bar. Then enter a cell reference such as the following: =$B$14 Press Enter. In the example... Keywords: Charts, AutoShapes, Graphic, Format, Formulas, Printing

 
32. Progress Meters A Progress bar is a good way of letting you know that your code is still working, especially if you have disabled screen... Keywords: AutoShapes, Links, VBA

 
33. Dividing a graphic The two examples both show the allotted share of resources using a graphic.......The above simply splits the note into sections. Masking parts of the... Keywords: Charts, SERIES, Graphic, Links, VBA

 

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