Home > Excel Help Portal > Printing With Excel

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

Printing With Excel

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

1. Event Macro to Add Path and Filename to Excel Header Now, on to writing the VBA code. There are a couple of useful variables that you can use. ActiveWorkbook.Path will return the path of the workbook. It might look like "C:\My Documents\MrExcel". ActiveWorkbook.FullName will return the path and filename of the workbook. It might look like "C:\My... Keywords: Add-In, Years, Errors, Printing, VBA, Macro, Object, Setup, File Name, Toolbar, Web

 
2. How to Select a Compatible Printer Driver If you want to troubleshoot a problem with your printer driver, try printing with a different printer driver. If you determine that the problem does not occur when you use a different driver, you may need to update or reinstall the original... KB#177512. Keywords: Graphic, Colors, Errors, Printing

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

 
4. Excel Worksheet Object with Color Text Is Printed Black When you copy text that has been formatted to a color other than black from a Microsoft Excel 2002 document, and then paste the text into a Microsoft Word document as an Excel Worksheet object, the text prints as black. This problem also occurs if... KB#331492. Keywords: Dates, Colors, Printing, Object, File Name, Files, Web, Window

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

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

 
7. How to Add the Workbook Path to the Footer This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that adds the workbook path and file name to the footer of a... KB#142140. Keywords: Printing, VBA, Macro, Object, Setup, File Name, Web, Window

 
8. Not All Workbooks Print When Printing from Windows Explorer When you right-click a group of Microsoft Excel workbooks in Windows Explorer and then click Print , some of the files are not... KB#230137. Keywords: Printing, VBA, Macro, File Name, Files, Web, Window

 
9. Simulating the Lotus pipe feature to suppress row printing 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: Years, Formulas, Printing, VBA, Macro, Web, Window

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

 
11. How to Hide Button Controls with Visual Basic for Applications This article describes how to prevent buttons, such as command and option button controls, from being printed in the following situations. If the buttons are the only objects on the worksheet. If the worksheet that you want to print contains... KB#213832. Keywords: Graphic, Format, Printing, VBA, Macro, Object, Web

 
12. How to Use OLE Automation to Add Data to Excel Sheet OLE Automation provides a way for Visual FoxPro for Windows to interact with other OLE-compliant applications. Using OLE, the Visual FoxPro program can start a Microsoft Excel session, open a workbook, select a worksheet from the workbook, place... KB#142193. Keywords: OLE, Sales, Printing, Object, Setup, Window

 
13. How to Change Arabic Page Numbers to Roman Numerals Microsoft Word for Windows has a page numbering option that converts the arabic page numbers to Roman numerals. Microsoft Excel does not have the equivalent built-in functionality; however, this feature can be emulated with a Microsoft Visual... KB#139403. Keywords: Printing, VBA, Macro, Setup, Toolbar, Web, ROMAN

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

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

 
16. Custom HTML Table from Excel I had a list I wanted to convert to HTML but surround it with graphics of my choice and be able to change on the fly. The finished product in the example is a list of ISO country codes. I actually used it for some company information that will always have the same columns but the content (number of... Keywords: Printing, File Name, Text Files, HTML

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

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

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

 
20. Excel Quits When Printing to a Printer with a Long Name When you attempt to print your workbook, Microsoft Excel quits unexpectedly. You receive the following error message, and your workbook is not printed: EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the... KB#248212. Keywords: Errors, Printing

 
21. Color Shift Occurs When Printing in Windows 98 When you print a document from an Office 97 program, the colors contained in the document may not print as expected. For example, the color red prints as... KB#108729. Keywords: Colors, Printing

 
22. Avoid printing specific rows In some cases, you may wish to avoid printing certain rows in your worksheet. For example, the rows may contain confidential information, or intermediate results that need not be printed.To avoid printing specific rows, you can hide the rows before you print, and then unhide the rows after... Keywords: Charts, Format, Outline, Symbol, Formulas, Printing

 
23. Increment Hours and Minutes in a String Someone in my department was showing me where they were trying to build a batch file that would show the times and string to be run every 5 minutes around the clock. I shot my mouth off and said I could write a 7 line macro that would do the trick. I eventually needed the “Select Case” statement to... Keywords: Printing, VBA, Macro

 
24. Labels on XY Scatter Graphs Disappear in Print Preview When you view an XY scatter graph with smooth lines and labels that has been rotated to less than -6 degrees or more than 6 degrees in print preview, the horizontal (X) axis labels... KB#262113. Keywords: Printing

 
25. Using Custom Dialog Boxes I have been getting a lot of notes about filling a custom dialog box. I particularly like this method because it allows me to edit the list and use it without re-programming. The lines between the § symbols are the key to dynamically filling the list. '------- Print List chosen from... Keywords: Printing, VBA, Object

 
26. Print a Multiple Sheet Workbook with Page Numbers I was in someone's office and found they had a workbook with about 40 linked sheets. They were jumping through hoops trying to print the sheets with page numbers as though they were all on the same sheet. Here is a quicky to make the nice page numbering AND print the whole document in one swoop.... Keywords: Printing, Setup, Window

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

 
28. Writing a Flat File There is probably an easier way to do this, but my customer wanted an Excel written to a flat file in a specified format. In a hurry, of course! And it had to have a pre-defined number of spaces between each item across the... Keywords: Format, Printing

 
29. Creating a linked picture of a range Many users overlook a useful Excel feature that can create a live "snapshot" of a range and placing it anywhere you like. To use this feature: Select a range of cells Choose Edit, Copy Hold down the Shift key, and then choose Edit, Paste Picture Link. The result is an image of the selected range... Keywords: Charts, SERIES, Format, Formulas, Printing, Links

 
30. Printing Just a Portion of Your Worksheet If you need to print just a small portion of your worksheet: Select the cells that you want to print Choose File - Print In the Print dialog box, choose the Selection option Click OK If you've specified a print area, this will not change it. Note If your selection consists of a non-contiguous range... Keywords: Charts, Format, Formulas, Printing

 

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