Home > Excel Help Portal > Setting Up Excel

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

Setting Up Excel

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

1. Date & Time Entered as: Displays As Generates Format Actual value Actual Date (US) Formula -- =GetFormula(cell) To add one month to a date (i.e. 01/28/2001 through 01/31/2001 becomes 02/28/2001) x = DateAdd("m", 1, x - 1) 'yyyy Year, q Quarter, m Month, y Day of year, d Day, w Weekday, ww Week, h Hour, n... Keywords: Add-In, Analysis ToolPak, Charts, SERIES, Advanced Filter, Query, Dates, Days, Holidays, Months, Networkdays, Years, API, Colors, Custom Number Formats, Fonts, Styles, Symbol, Arrays, Errors, Formulas, Sounds, Page Setup, VBA, Macro, User Defined Function, Templates, HTML, Links, Web, Comments, Window, TEXT, NOW, MOD, DATEVALUE, TIME, COUNTIF, DATEDIF, ROUNDDOWN, MID, TODAY, DB, WEEKDAY, CHOOSE, WEEKNUM, EDATE, TIMEVALUE, MROUND, FLOOR, CEILING, ROUNDUP, MIN, MAX, LEN, CELL, CODE, COUNTA

 
2. Slow Response, Memory Problems, and Speeding up Excel Don't use this feature if you don't need it. Results reported in XL2000, from XL97 would be similar If you are saving as Microsoft Excel 97-2000 & 5.0/95 Workbook *.xls you will see the following Microsoft Excel 5.0/7.0 saving XXXXXXX.xls on your status bar where you normally see Ready toward the... Keywords: Add-In, Charts, Dates, Days, API, DLL, Export, Microsoft Access, Colors, Custom Number Formats, Fonts, Patterns, Styles, Arrays, Errors, Formulas, Links, Password, Speech, Startup, Page Setup, Printing, VBA, Macro, Object, VBE, AutoSave, CD-ROM, Circular References, Error Message, Files, Registry, Templates, Toolbar, Text Files, Hyperlinks, Internet Explorer, Web, Comments, Window, INFO, CELL, OFFSET, TODAY, INDIRECT, NOW, RAND, MAX, FIND, MID

 
3. Outlook Express 5.0 through 6.0 Okay, now what about my cousin who invariably sends me email with no subject lines, includes HTML, virus hoaxes. I'll try the harmless one she just sent with newspaper clippings. This one has IncrediMail or at least it has an advertisement for same and it has an external paperclip on the selection... Keywords: Sorting, Days, Months, Download, Statistics, Colors, Errors, Links, Password, Sounds, Clipboard, Setup, Files, Registry, Toolbar, HTML, Internet Explorer, Web, Comments, Window, LEFT, SIGN, RIGHT

 
4. Toolbars, Custom Buttons and Menus Sample Screen shot for Excel 2000 A view with individual toolbars identified in Excel 2000 is not included here because of the space it would occupy on this page and the size of the download. But you can see it and additional toolbars for both Excel 2000 and and Excel 95 ) on Figure 3, another... Keywords: Add-In, Sorting, Download, OLE, Borders, Colors, Fonts, Format, Patterns, Styles, Errors, Formulas, Links, Speech, Startup, Page Setup, Printing, Clipboard, VBA, Macro, Files, Templates, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, FIND

 
5. Office 2000, my experience in installing - Progress report Title:    Office 2000, my experience in installing - Progress report Location:   ofc2000.htm Author:    David McRitchie    msn.com"DMcRitchie@   also DMcRitchie@msn.com  Document Creation Date:   July 12, 1999 FWIW, Word says I last updated this document (mm/dd/yyyy) on 07/25/1999 9:40 AM. Last... Keywords: Add-In, Sorting, Days, Download, DDE, Export, Sales, Format, Errors, Sounds, Printing, Macro, VBA, Setup, CD-ROM, Files, Toolbar, Text Files, HTML, Links, Web, Comments, Window

 
6. Fill-Handle, Replication and use of the Mouse Equivalent Examples With the data in cell A3, to be copied down to cell A30: Select cell A3 Point to the fill handle (the black square in the lower right corner of the selection) When the pointer changes to a black cross, drag down to A30 abc The items in bold were replicated (propagated) down... Keywords: SERIES, AutoFilter, Dates, Days, Months, Borders, Fonts, Format, Errors, Formulas, Links, Startup, Page Setup, Printing, VBA, Macro, Object, VBE, Files, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window, ROW, OFFSET, LARGE, INDIRECT, CELL, MID

 
7. Posting to Newsgroups From: chpearson@gvi.net (Chip Pearson) Date: 1998/01/08 Newsgroups: microsoft.public.excel.misc, microsoft.public.excel.worksheetfunctions, microsoft.public.excel.programming Turning MIME off in Netscape Netscape Navigator 3.0 Options -- Mail & News preferences -- composition -- allow 8-bit turn... Keywords: Query, Sorting, Days, Months, Download, Fonts, Format, Errors, Formulas, Links, Macro, VBA, Setup, Error Message, HTML, Web, Comments, Window, RAND, IS

 
8. Things you should have that are Free There are some very clear issues here; Advertising, Pop-Ups, Limited support, etc. Read the documentation first and then decide. If you are away from home don't forget to take a wireless card and/or a cable modem card, your friends may have cable even if you don't. On the Second tab of FTP_WS LE... Keywords: Sorting, Days, Download, Colors, Fonts, Links, Password, Startup, Printing, Macro, Object, VBA, Setup, Files, Text Files, HTML, Internet Explorer, Web, Comments, Window

 
9. Considerations for ServerSide Automation of Office Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with... KB#257757. Keywords: Charts, ActiveX, DDE, OLE, Third-Party, XML, Format, Errors, Printing, Clipboard, Macro, Object, VBA, Setup, Files, Registry, HTML, Internet Explorer, Links, Web

 
10. Pathname in headings, footers, and cells This page contains some VBA macros. If you need assistance to install a or use a macro please refer to instructions on my my Getting Started with Macros page, or for more complicated situtations to my Formula page. Coding Example using a VBA macro: Leo Heuser =fname("filename") The following is... Keywords: Sorting, Dates, Statistics, Colors, Fonts, Format, Styles, Errors, Formulas, Startup, Page Setup, Printing, VBA, Macro, Object, VBE, File Name, Templates, Toolbar, Web, Comments, Window, CELL, LEFT, INFO, SUBSTITUTE, MID, RIGHT, NOW, COLUMN

 
11. Cell Comments XL2HTMLX (extended) version which adds the grey shaded Column and Row headers. IExplorer is then invoked for a review and the example (coding) can be copied from view source into a permanent web page. As the actual purpose is to generate as little code as possible you will have to right justify any... Keywords: AutoShapes, Graphic, Text Box, Borders, Colors, Fonts, Format, Outline, Errors, Formulas, Links, Printing, VBA, Macro, Object, VBE, Setup, HTML, Internet Explorer, Web, Cell Note, Comments, Validation, Window

 
12. Excel Newsgroups ©2001 Google When looking at your results be sure to look also at: Before Deja suddenly disappeared on Feb 12, 2001 lots of strange things had happened. A move of servers in 1999 dumped all but the last three days and they slowly recovered back to about March of 1999 by the time it was announced... Keywords: Charts, Sorting, Wildcard, Dates, Days, Years, DDE, OLE, Statistics, Format, Errors, Formulas, Links, Password, Startup, Printing, Macro, UDF, Setup, Files, Macintosh , Templates, HTML, Internet Explorer, Web, Comments

 
13. Speech Recognition Frequently Asked Questions You can use the speech recognition feature to speak to your computer through a microphone. If your computer meets the system requirements, you can dictate text by using any of the products that are listed in the Applies to section of this... KB#826853. Keywords: API, Third-Party, Colors, Format, Errors, Sounds, Speech, Setup, Files, Registry, Toolbar, Web, LEFT, RIGHT

 
14. How to Minimize Metadata in Microsoft Excel Workbooks This article explains various methods that you can use to minimize the amount of metadata in your workbooks. When you create, open, or save a workbook in Microsoft Excel, the workbook may contain content that you do not want to share with others... KB#223789. Keywords: OLE, Statistics, Colors, Fonts, Format, Styles, Formulas, Links, Page Setup, Printing, Macro, Object, VBA, Files, Templates, Hyperlinks, Web, Comments

 
15. Lastcell, Reset Last Used Cell If you place some data in a remote location of your spreadsheet and later delete that data Excel retains a memory of the last cell in use even though it is no longer in use. To find the last cell in use. This is the convergence of the highest row in use and the highest column in use (or the memory... Keywords: Borders, Colors, Format, Arrays, Errors, Formulas, Sounds, Printing, VBA, Macro, Setup, Files, Toolbar, Text Files, Hyperlinks, Web, Comments, INDIRECT, LOOKUP, INDEX, OFFSET, ROW

 
16. How to Create MS Access Database from MS Excel Using DAO In some cases, you may want to create a Microsoft Access database from a Microsoft Excel for Windows 95 version 7.0 workbook, but are not able to use Access Links. While the preferred method of moving a Microsoft Excel workbook into Microsoft... KB#151566. Keywords: Charts, Sorting, Microsoft Access, Format, Errors, Links, VBA, Object, Setup, Error Message, Web

 
17. How to Deploy the Office 2003 Web Components in an Office 2003 Program When a user who does not have the Microsoft Office 2003 Web Components installed on their computer accesses a Web page that contains an Office 2003 Web Component, he or she may receive a message that is similar to the following: To use this Web... KB#828950. Keywords: Charts, Download, ActiveX, PivotTables, Object, Setup, File Name, Files, Registry, HTML, Internet Explorer, Links, Web

 
18. How to build an Office COM Addin by Using Visual Basic .NET Microsoft Office 2000 and later support a new, uniform design architecture for building application add-ins to enhance and to control Office applications. These add-ins are called COM add-ins. This step-by-step article discusses Office COM add-ins... KB#302896. Keywords: Add-In, ActiveX, Styles, Arrays, Errors, Startup, Class, VBA, Object, Setup, Error Message, Registry, Templates, Toolbar, Links, Web, Window

 
19. You receive runtime error 429 when you automate Office applications Discusses the run-time error 429 ActiveX component can't create object that can occur when you automate Office 2003 applications and provides information on how to diagnose and resolve common problems that may cause this... KB#828550. Keywords: Dates, Download, ActiveX, OLE, Format, Errors, Object, VBA, Setup, Corrupted, Files, Registry, Templates, Internet Explorer, Web

 
20. SNAKECOLS, How to snake columns to use fewer pages Creating a Table from something like a column of address labels (#snkAddr) Simple example to take a single column, such as labels with Name; Street Address; City, State, Zipcode and convert to a table. On a second sheet, then use fill-handle for 3 lines per set start with: A1:... Keywords: Add-In, Format, Formulas, Printing, VBA, Macro, Files, HTML, Web, Comments, OFFSET, INDIRECT, INDEX, TRIM

 
21. How to deploy the Office XP Web Components in an Office Program When a user who does not have the Office XP Web Components installed on their computer accesses a Web page that contains an Office XP Web Component, he or she may receive a message similar to the following: To use this Web page interactively, you... KB#288732. Keywords: Charts, Download, ActiveX, Microsoft Access, PivotTables, Object, Setup, File Name, Files, Registry, HTML, Internet Explorer, Links, Web

 
22. Logos and Graphics into headers/footers Excel does not provide for including graphics directly into the headers and footers. You have a couple of alternatives though. Use a font character (though of limited use works in both headings and footings). Dedicate first row to contain logos, and place the column headings in the second row... Keywords: Charts, Graphic, Borders, Colors, Fonts, Format, Gridlines, Outline, Patterns, Formulas, Page Setup, Printing, Clipboard, Macro, Object, Files, HTML, Web, Comments

 
23. Collections Dim wkBook As Workbook Dim wkSheet As Worksheet Dim x As Long, cSht As Long For Each wkBook In Workbooks x = x + 1: cSht = 0 Cells(1, x) = wkBook.Name For Each wkSheet In wkBook.Worksheets cSht = cSht + 1 Cells(cSht + 1, x) = "'" & wkSheet.Name Next wkSheet Next wkBook Dim wkBook As Workbook Dim... Keywords: Charts, Sorting, Fonts, Format, Arrays, Errors, Links, Defined Name, Printing, VBA, Macro, Object, File Name, Files, Hyperlinks, Web, Comments, Validation

 
24. How to Transfer Data from an ADO Recordset to Excel with Automation You can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel. The approach that you can use depends on the version of Excel you are automating. Excel 97, Excel 2000, and Excel 2002 have a... KB#246335. Keywords: Dates, ActiveX, DAO, OLE, Format, Arrays, Errors, Class, VBA, Object, Setup, Links

 
25. How to Find Technical Information About Microsoft Excel When you use Microsoft Excel, you may have questions regarding how to perform a task or how to troubleshoot a problem. This article discusses resources that you can use to find answers to your questions. The following resources contain useful... KB#146197. Keywords: Solver, Text Box, Criteria, Query, Sales, Formulas, VBA, Setup, Files, Setup Program, Toolbar, Web

 
26. Excel 2000 SR1 Eurotool Addin Update Admin To help you deploy the Excel 2000 SR-1 Eurotool Add-in Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting file available in the... KB#295685. Keywords: Add-In, Dates, Download, Setup, File Name, Files

 
27. Internet Explorer Cannot Open an Excel AddIn (*.xla) File When you navigate to a Microsoft Excel Add-in (*.xla) file from a Web page while running Internet Explorer, the add-in fails to load and Internet Explorer displays a warning that the page you are looking for is currently unavailable. The... KB#268016. Keywords: Add-In, ActiveX, OLE, Startup, Class, VBA, Setup, Files, Registry, Toolbar, Text Files, Hyperlinks, Internet Explorer, Web, Window, CHAR

 
28. Merge and Unmerge Cells This page contains some VBA macros. If you need assistance to install or to use a macro please refer to my GetStarted page for simpler instructions, or to my GetFormula page for more extensive information on macros. The icon Merge Across is similar to the macro MergeRxR, but MergeRxR will work with... Keywords: Sorting, Borders, Colors, Format, Errors, Formulas, VBA, Macro, User Defined Function, Setup, Web, Comments

 
29. How to use a Web Data Source for a PivotTable in Excel 2000 This step-by-step article shows you how to refer to data that is on a Hypertext Transfer Protocol (HTTP) Web server when you create a PivotTable report. Microsoft Excel 2000 contains many Internet-related features, including Web queries,... KB#211908. Keywords: Query, SQL, Defined Name, PivotChart, PivotTables, Setup, File Name, Files, Text Files, Web, ROW

 
30. How to Use MS Query to Merge Two Excel Files for a Mail Merge Data Source The information in this article describes how to use Microsoft Query to merge two Excel 97 files. You may want to do this so that you can combine related information into a single file and use it in a mail... KB#180599. Keywords: Query, Sorting, Format, Setup, Files, Toolbar, Links, Window

 
31. How to Force Installation of All Office Assistants This article explains how to configure the Microsoft Office 97 Setup program so that the character (.act) files for all of the Office Assistants are copied to your hard disk when you install Microsoft Office 97 from an administrative... KB#162048. Keywords: SERIES, Format, Errors, Setup, Corrupted, File Name, Files, Setup Program, Parse, Window

 
32. Headings for Columns, and Page Numbering Keywords: Text Box, Download, Colors, Fonts, Page Setup, Printing, Macro, VBA, Web, Comments, ROW

 
33. HELP in and for Excel Now everyone can do their own research, does their own typing so is their own secretary, and maybe even their own publisher. If you learn to use the search engines and only use them with the most advanced features, can find practically anything on any subject. In all MS Office products you can... Keywords: Years, Formulas, Links, Macro, Object, VBA, VBE, Setup, Setup Program, HTML, Web, Comments, Window

 
34. Administrative Update Available for HTML Script Vulnerability To help you deploy the Excel 2000 and PowerPoint 2000 HTML Script Vulnerability Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting... KB#268654. Keywords: Dates, Download, Setup, Files, HTML, Web

 
35. How to reset Personal Menus in Office XP and Office 2000 Programs This step-by-step article describes how to reset a menu in a Microsoft Office program back to its default first-run condition. In addition, this article describes the following: What the Personalized Menus and Toolbars feature is. Two methods... KB#193006. Keywords: Errors, VBA, Setup, CD-ROM, Error Message, Files, Toolbar

 
36. How to Use a Web Data Source for a PivotTable Microsoft Excel 97 contains many Internet-related features, including Web queries, hyperlinks, and .htm file support. However, when you create a PivotTable, you cannot directly refer to data that is on an Hypertext Transfer Protocol (HTTP) Web... KB#164020. Keywords: Query, SQL, Defined Name, PivotTables, Setup, File Name, Files, Text Files, Web, ROW

 
37. How to Use File DSNs and DSNless Connections When you use a connection string that does not use a data source name (a DSN-less connection string) to connect to an external data source in Microsoft Excel, information that is required to connect to the external data source is stored in the... KB#165866. Keywords: Query, Microsoft Access, Errors, VBA, Setup, Error Message, File Name, Files, Registry, Save A File, Setup Program, Toolbar, Text Files

 
38. How to Use the WebBrowser Control to Open an Office Document in Visual Basic .NET You may want to display, or embed, an Office document directly on a Visual Basic .NET Form. Unlike earlier versions of Visual Basic, Visual Basic .NET does not provide an OLE control that allows you to embed an Office document on a form. If you... KB#304643. Keywords: ActiveX, OLE, Errors, Printing, Class, Command Button, VBA, Object, Setup, Toolbar, Internet Explorer, Web

 
39. Macro to create a table of contents Thanks to Matt who sent this week's question: I have a large and growing worbook (lots of sheets). I have included page numbers in the footer while printing, however it is getting harder and harder to navigate when we are in a meeting. Is there a way to print a table of contents based on worksheet... Keywords: Format, Arrays, Errors, Page Setup, Printing, VBA, Macro, Object, Web, Window

 
40. Administrative Update Available for the Excel 2000 SR1 REGISTER.ID Function Vulnerability To help you deploy the Excel 2000 SR-1 REGISTER.ID Function Vulnerability Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting file available... KB#269267. Keywords: Download, Setup, Files, HTML, Web

 
41. Configuring Excel Excel 2002 for Dummies When a new spreadsheet spreadsheet is started you may wish to use a selection of preferred options such as the font name and size of a title in cell A1, headers and footers and number formats. These items can be stored in a template called Book.xlt which is automatically... Keywords: Wildcard, Fonts, Format, Patterns, Styles, Errors, Formulas, Startup, Page Setup, Printing, Macro, VBA, Files, Templates, Toolbar, Window

 
42. How to Use the WebBrowser Control to Open an Office Document When working with Office Documents you may want to display these documents directly in Visual Basic, but do not want to create an embedded OLE object using the OLE container control. Instead, you would like to link to an existing document and open... KB#243058. Keywords: ActiveX, OLE, Errors, Printing, Command Button, VBA, Object, Setup, Toolbar, Internet Explorer, Links, Web, Window

 
43. Excel Window, Workbook Window, Worksheet Window Keywords: Borders, Gridlines, Formulas, Printing, Macro, VBA, Toolbar, Web, Comments, Window

 
44. Organization Charts from Office 2000 Programs Appear Different in Office XP Programs An organization chart may change when you try to edit it. This behavior may occur when all of the following conditions are true: The organization chart changes... KB#293615. Keywords: Charts, OLE, Format, Styles, Object, Setup, CD-ROM, Files, Registry

 
45. How to set Up and Use the RTD Function in Excel 2002 This step-by-step article discusses the new functionality that the RealTimeData (RTD) function provides. Microsoft Excel 2002 provides a new worksheet function, RealTimeData (RTD), which allows you to call a Component Object Model (COM)... KB#289150. Keywords: Add-In, Dates, Errors, Formulas, Links, Startup, Macro, Object, VBA, Setup, Error Message, File Name, RTD

 
46. How to Set Print Areas and Print Titles on a Worksheet This article describes different methods that you can use in Microsoft Excel to set a print title and a print area on your... KB#214012. Keywords: Graphic, Page Setup, Printing, VBA, Macro, Toolbar, Web

 
47. How to Use the Query Before and AfterRefresh Events In Microsoft Excel, you can automatically run a macro before or after updating (refreshing) worksheet query data. You can do this with the BeforeRefresh and AfterRefresh Visual Basic for Applications events. This article contains an example of how... KB#182735. Keywords: Query, Class, VBA, Macro, Setup, Files, Setup Program, Toolbar, Web, Window

 
48. How to use the Estimates Sample When the Database and the Web Server Are on Different Computers The Estimates sample that is included with Microsoft Visual Studio Tools for the Microsoft Office System describes how to use managed code extensions and how those managed code extensions can work together with Microsoft SQL Server databases and... KB#824006. Keywords: SQL, Class, VBA, Setup, Files, Templates, Web, Window

 
49. Templates, book.xlt, sheet.xlt, and beyond Keywords: Years, Download, Borders, Colors, Format, Gridlines, Patterns, Styles, Startup, Printing, Class, VBA, Files, Templates, Toolbar, Web, Comments, IS

 
50. How to Use the Query BeforeRefresh and AfterRefresh Events In Microsoft Excel, you can automatically run a macro before or after updating (refreshing) worksheet query data. You can do this with the Visual Basic for Applications BeforeRefresh and AfterRefresh events. This article contains an example of how... KB#213187. Keywords: Query, Class, VBA, Macro, Setup, Files, Setup Program, Web, Window

 

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