Home > Excel Help Portal > Setting Up Excel

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

Setting Up Excel

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

51. Freeze Panes for view and Repeat descriptive row/col headings for printing Keywords: Download, XML, Page Setup, Printing, HTML, Web, Comments, Window

 
52. How to Use the Internet Assistant Wizard The Internet Assistant Wizard is not new to Microsoft Excel, but it has changed significantly since it was released as a free add-in available on the Microsoft World Wide Web site in January 1996. The Internet Assistant Wizard is now an... KB#158079. Keywords: Add-In, Charts, SERIES, Export, Format, Setup, Setup Program, HTML, Internet Explorer, Web

 
53. Query to Find Unmatched Records Between Two Files This article describes how to create a Subtract query that compares two tables and returns a result set that includes only those records from the first table that do not have matching records in the second... KB#114150. Keywords: Criteria, Query, SQL, VBA, Setup, Files

 
54. Printer Name Not Listed in Print Dialog Box When you try to print your workbook, the printer name does not appear in the Name box in the Print dialog box. However, the same printer does appear in the Print dialog box of other Microsoft Office programs. This problem may occur when you have... KB#211391. Keywords: Printing, Setup, Corrupted, Files, Registry

 
55. How to Set Page Setup Attributes for More Than One Sheet In Microsoft Excel, page setup attributes, such as margins, sheet orientation, and print titles, are set for each worksheet, individually. This article describes three methods that you can use to set some of these attributes... KB#213257. Keywords: Page Setup, Printing, VBA, Object, Templates, Web

 
56. Properties Function Property(aaa) 'Excel Maintains: Title, Subject, Author, Keywords, Comments, ' Last Author, Application Name, Last Print Date, Creation Date, ' Last Save Time, ' Security, Category, Manager, Company 'Some DejaNews threads: AN=393501043, AN=371066133 'also see Chip Pearson's... Keywords: API, Formulas, Links, Printing, VBA, Macro, Setup, Hyperlinks, Web, Comments

 
57. Solving Common Setup Problems This document describes the solution to several common problems involving Excel setup.Excel crashes when it starts When Excel is started, it opens an *.xlb file, which contains your menu and toolbar customizations. If this file is damaged, it may cause Excel to crash when it it started. Also, this... Keywords: Add-In, Charts, Format, Styles, Formulas, Startup, Printing, Macro, VBA, Setup, Files, Toolbar

 
58. OWCHelpr.exe Demonstrates Automation to Excel for Printing a PivotTable Component on a Web Page OWCHelpr.exe is a sample that illustrates how you can use Automation to Microsoft Excel to print a PivotTable component on a Web page. OWCHelpr.exe contains an ActiveX DLL that copies a PivotTable to the clipboard, pastes it to a new Microsoft... KB#262827. Keywords: Download, ActiveX, DLL, PivotTables, Page Setup, Printing, Files, Internet Explorer, Web

 
59. OLE Examples for Taking Control of Excel from Visual FoxPro Dbf2xls.exe is a sample that provides Microsoft Visual FoxPro code to control Microsoft Excel by using OLE... KB#252615. Keywords: Download, OLE, Errors, Page Setup, Printing, Object, Files, TYPE

 
60. Right Click Menus (Context Menus) in Excel This page contains some VBA macros. If you need assistance to install or to use a macro please refer to my «Getting Started with Macros« or delve into it deeper on my Install page. In my Auto_Open in my personal.xls (I call mine with a different name, you'll have to change code... Keywords: Add-In, Sorting, Errors, Formulas, Links, VBA, Macro, Setup, AutoSave, HTML, Internet Explorer, Web, Comments

 
61. How to change the Company Name and User Name in an Office 2003 Program This step-by-step article describes how to change the name of the company in Office 2003 after setup by modifying the Microsoft Windows registry. This article also explains how to change the user name information. Note In earlier versions of... KB#821550. Keywords: Setup, Registry, Web

 
62. Startup Switches for Microsoft Excel 2000 Microsoft Excel accepts a number of optional switches that you can use to control how Excel starts. This article lists the switches and provides a description of each... KB#211481. Keywords: Startup, Macro, Setup, Files, Registry, Toolbar

 
63. How to Set Page Setup Attributes for More Than One Sheet By default, page setup attributes, such as margins, sheet orientation, and print titles, are set individually (on a worksheet-by-worksheet basis). However, you can set some of these attributes globally by using any of the following methods: Use... KB#154663. Keywords: Format, Page Setup, Printing, VBA, Macro, Object, Templates, Toolbar, Web

 
64. Installing Project 4.1 Breaks Office 97 Spelling Checker When you attempt to use the spelling checker in any of the programs listed at the beginning of this article, you may receive one of the following error messages: Out of memory. The custom dictionary is full. The word was not added. Cannot open... KB#162970. Keywords: Format, Errors, Setup, File Name, Files, Registry, Setup Program, Spelling Checker

 
65. Running Tasks or more directly with Run: msinfo32 then within on the left of System Information: Software Environment, Drivers, Running Tasks... Keywords: Fonts, Startup, Macro, Setup, HTML, Web, Comments

 
66. How to Change the Company Name and User Name After Setup In earlier versions of Office, if you want to change the company name displayed in the Office splash screens and About program name on the Help menu (where program name is the program you are using), you uninstall Office, run Setup again, and enter... KB#233499. Keywords: Setup, Registry

 
67. How to obtain and Install the Excel 2000 SYLK File Security Update in Excel 2000 Microsoft recently identified two potential security issues that malicious macro authors could exploit. The Excel 2000 SYLK File Security Update addresses these issues. This article describes how to download and install the Excel 2000 SYLK... KB#242144. Keywords: Download, Macro, Setup, File Name, Web

 
68. Graphics in Header or Footer Extend into Data Area of Worksheet Graphics placed in the header or footer intrude into the data area of the... KB#288966. Keywords: Ratio, Format, Page Setup, Printing

 
69. Fit Print to Page, and Adjustments to Layout Unless you select and area and print selection, limit with Print Area, or have hidden rows and/or columns you will print from cell A1 to your lastcell (Ctrl+End). Excel does not keep track of the used range very well though, so if you insert rows and then delete rows, Excel remembers how many rows... Keywords: Borders, Fonts, Format, Gridlines, Page Setup, Printing, Toolbar, Web, Comments

 
70. How to insert a Picture into the Header or Footer in Microsoft Excel 2002 This article explains how to insert a picture into the header or footer of a Microsoft Excel 2002 worksheet.Insert Picture into Header New functionality in Excel 2002 provides the ability to add pictures to the header or footer areas of a... KB#288964. Keywords: Ratio, Format, Page Setup, Printing

 
71. How to Change the Paper Source Using the SendKeys Command It is possible to change the default paper source used by printer drivers in Microsoft Windows Windows 95 and later versions of Windows by using the SendKeys command within a Visual Basic for Applications subroutine in Microsoft Excel 2000. NOTE :... KB#213815. Keywords: Page Setup, Macro, VBA, Web

 
72. Grayed Out Options CommandBars("AutoCalculate").Reset Make sure you are not in Edit mode by hitting Exc (Escape key), as edit mode will gray out a lot of menu options -- notably most Edit options (except cut & paste). Will grayout Options under Toolbar; many options under Data and under Window. Probably have sheet... Keywords: Colors, Formulas, Page Setup, Printing, VBA, Macro, Files, Toolbar, Web, Comments, Window

 
73. How to use the Histogram Addin in Excel 2000 This step-by-step article describes how to create a histogram with a chart from a sample set of data. The Analysis ToolPak that is included with Microsoft Excel includes a Histogram tool. Verify Installation of the Analysis ToolPak Before you use... KB#214269. Keywords: Add-In, Analysis ToolPak, Charts, Histogram, Setup

 
74. How to Insert a Graphic File in Microsoft Excel Worksheet In Microsoft Excel it is possible to insert graphics files. The type of file you can insert depends on the graphic import filters that are installed on your computer. Typically, filters are installed when you install software programs that... KB#142133. Keywords: Plot, Graphic, Format, Printing, Setup, Files

 
75. How to Copy Files from Cabinets on DMFFormatted Disks The files on Disk 2 and later of the Setup program for Microsoft Excel for Windows are stored in cabinet files on DMF-formatted disks. If you need to copy the files from the disks to a network server or other permanent storage drive, you must use... KB#120006. Keywords: Setup, Files, Setup Program

 
76. How to Use the Histogram Addin The Analysis ToolPak that is included with Microsoft Excel includes a Histogram tool. This article describes how to create a histogram with a chart from a sample set of... KB#141684. Keywords: Add-In, Analysis ToolPak, Charts, Histogram

 
77. How to Format an Excel Workbook While Streaming MIME Content This article demonstrates how you can use Active Server Pages (ASP) to create a formatted workbook that can be streamed as MIME content to Microsoft... KB#271572. Keywords: XML, Format, Page Setup, HTML, Internet Explorer, Web

 
78. Slow Response, Speeding up Excel Help topic: What to do before you print Preparing to print Microsoft Excel provides lots of optional settings that let you adjust the final appearance of the printed page to suit your needs. To make sure you've checked everything likely to affect your printout, follow the steps that are listed to... Keywords: Format, Page Setup, Printing, Macro, VBA, Web, Comments

 
79. Analysis ToolPak Functions Unexpectedly Return #NAME Error Value In Microsoft Excel, you may experience the following problems when you use a worksheet function that is included in the Analysis ToolPak add-in: You receive the #NAME error value. -or- The function you want to use is not available in the... KB#121730. Keywords: Add-In, Analysis ToolPak, Networkdays, Errors, Formulas, VBA, Setup, Setup Program, Toolbar, ACCRINT, ISEVEN, SERIESSUM, ACCRINTM, IMABS, ISODD, SQRTPI, BESSELI, IMAGINARY, LCM, TBILLEQ, BESSELJ, DELTA, IMARGUMENT, MDURATION, TBILLPRICE, BESSELK, DISC, IMCONJUGATE, MROUND, TBILLYIELD, BESSELY, DOLLARDE, IMCOS, MULTINOMIAL, WEEKNUM, DOLLARFR, IMDIV, IMEXP, NOMINAL, XIRR, EDATE, IMLN, XNPV, COMPLEX, EFFECT, YEARFRAC, CONVERT, EOMONTH, COUPDAYBS, ERF, IMPOWER, ODDFPRICE, YIELDDISC, COUPDAYS, ERFC, IMPRODUCT, ODDFYIELD, YIELDMAT, COUPDAYSNC, FACTDOUBLE, IMREAL, ODDLPRICE, COUPNCD, FVSCHEDULE, IMSIN, ODDLYIELD, COUPNUM, GCD, IMSQRT, COUPPCD, GESTEP, IMSUB, PRICEDISC, CUMIPMT, IMSUM, PRICEMAT, CUMPRINC, INTRATE, RECEIVED

 
80. Page Breaks, and Inserting Blank Rows Insert Page Breaks on change in Column A, and insert blank rows on change in Column B. To prevent inserting still more lines when rerunning a check is made to see if a blank row had already been inserted -- so this can be rerun without further changes. If you want a new sheet activate the... Keywords: Sorting, Colors, Page Setup, VBA, Macro, Web, Comments

 
81. Gridlines and Borders Cell color and/or Borders wipe out gridlines: Any color within a cell such as white, or any color borders such as white, will wipe out gridlines. Draft quality wipes out gridlines and interior color as can be previewed in Print Preview. To Make sure you do not have color within a cell Cells with... Keywords: Borders, Colors, Format, Gridlines, Patterns, Printing, VBA, Macro, Toolbar, Web, Comments, Window

 
82. How to Create Multiple Views and Create and Print a Report A view is a picture of the worksheet that has specific characteristics associated with it, such as print settings and whether to include hidden rows and columns. In View Manager, under View Includes, you can select two check boxes: The Print... KB#142529. Keywords: Add-In, Printing, Setup

 
83. Errors When Using ODBC to Insert Microsoft Excel Worksheet When you attempt to insert a Microsoft Excel worksheet into a Word document or when you attempt to attach a Microsoft Excel worksheet as a data document to a mail merge main document using the Excel Files via ODBC (*.xls) driver, one of the... KB#245652. Keywords: Query, SQL, Errors, Setup, Error Message, Files, Toolbar

 
84. Add graphics to your page header Note: Excel 2002 has built-in support for graphics in the page header or footer. Prior to Excel 2002, a common question was: "How can I insert my company's logo into the page header?" The simple answer: You can't. But there are a few ways to fake it. Perhaps the simplest solution is to print your... Keywords: Charts, Graphic, Fonts, Format, Formulas, Sounds, Page Setup, Printing, Window

 
85. 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

 
86. Sample Visual Basic Procedure to Print Range of Cells This article contains a Microsoft Visual Basic for Applications macro that lets you print different parts of a worksheet without first having to select the range of cells or set the print area in the Page Setup dialog... KB#213451. Keywords: Errors, Page Setup, Printing, VBA, Macro, Web

 
87. Excel - Hyperlink navigation and macro buttons If you regularly use a large spreadsheet and repeatedly need to move between particular sections, it is worth adding some simple links to automate moving from one area to another. The link can be placed anywhere convenient on a worksheet and when clicked, it takes you directly to another location.... Keywords: SERIES, Graphic, Fonts, Format, Links, Page Setup, Printing, Macro, Object, Toolbar, Hyperlinks

 
88. How to create Multiple Views, Create and Print a Report in Excel 2000 This step-by-step article shows you how to create multiple views of a worksheet as well create and print a report. A view is a picture of the worksheet that has specific characteristics associated with it, such as print settings and whether to... KB#214258. Keywords: Add-In, Printing, Setup

 
89. How to Obtain a New Product Key for Office Program Setup This article describes how to obtain a new product key for your Microsoft Office program setup if your product key label is damaged or is... KB#823570. Keywords: Setup, CD-ROM, Registry

 
90. "The Macros in This Project Are Disabled" Error Running Macro When you run a macro in the Samples.xls file, you receive the following error message: The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable... KB#215715. Keywords: Errors, Macro, VBA, Setup, Setup Program

 
91. Excel -- Comments -- Basics Basics Insert a Comment Display a Specific Comment Display All Comments Use the Reviewing Toolbar Format Text in a Comment Printing Comments Comments -- Tips Comments -- Programming To hide the comment: a) Edit comment b) Previous comment c) Next comment d) Show comment e) Show all comments f)... Keywords: Borders, Colors, Fonts, Format, Printing, Setup, Toolbar, Comments

 
92. Microsoft Excel Text Formatting May Not Convert When Opened in Word When you use Microsoft Word 2000 to open a Microsoft Excel 2000 worksheet with multiple character formats within a cell (for example some text is bold and other text is italic), all text in that cell uses the format of the first character. All... KB#211850. Keywords: Format, Setup, Files, Toolbar

 
93. How to add the Workbook Path to the Header and Footer in Excel This article describes how to add the path of the Microsoft Excel workbook to the header of footer of the workbook. The feature described in this article is not available in versions of Excel earlier than Excel 2002. In earlier versions, the only... KB#287482. Keywords: Page Setup, Macro, VBA, File Name

 
94. Ejecting CDROM Causes Microsoft Excel to Close When you press the eject button on your CD-ROM drive, Microsoft Excel 97 may close unexpectedly. NOTE: This behavior occurs regardless of whether there is a compact disc in the CD-ROM... KB#167136. Keywords: Setup, CD-ROM

 
95. Articles About New Printing Features in Excel 2002 Print functionality in Microsoft Excel 2002 is similar to that of earlier versions of Excel. This article lists Microsoft Knowledge Base articles that address some of the more frequently asked questions concerning print features in Excel... KB#293447. Keywords: Graphic, Errors, Page Setup, Printing

 
96. How to suppress the Printing of Errors in Workbook Cells in Excel 2002 This step-by-step article describes how to suppress the printing of cell errors in a Microsoft Excel 2002 workbook. How to Suppress Printing of Errors Excel 2002 provides a way to suppress the printing of errors in cells or to change the format... KB#288972. Keywords: Format, Errors, Page Setup, Printing

 
97. Basic Excel Tips to make life easier 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: AutoFilter, Format, Page Setup, VBA, Web

 
98. Setup Print in Macro I deliver a massive list to lots of people every month. Many of them are casual Excel users and simply want a spreadsheet that prints correctly the first time. I establish the headers and footers and apply them as the setup continues. Note that the date of the report is hard-coded this way so... Keywords: Months, Printing, VBA, Macro, Setup

 
99. Highlighting and Exporting Cell notes If you just want to print a cell note, you can use the File, Page Setup, Sheet, Print dialog and set Print Notes to ON. Excel will print the row and column heading for each note if you choose option Print Row and Column Headings in the Sheet dialog. If you want to highlight the cells with notes so... Keywords: Export, Borders, Printing, VBA, Macro

 
100. Copy Page Setup settings to other sheets Each Excel sheet has its own print setup options (orientation, margins, headers and footers, and so on). These options are specified in the Page Setup dialog box, which you access using the File, Page Setup command. When you add a new sheet to a workbook, it contains the default page setup setting.... Keywords: Charts, Format, Formulas, Page Setup, Printing

 

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