Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Print only certain rows Help please. I have a listing, 000's of rows, ~ 20 columns and I only want to print those that match certain criteria and I am looking for a VBA solution. Details are: I have indicated the rows to print by inserting a txt character [can be changed to value] in each row, in a spare column. I know my problem can be solved with filtering but that method is not appropriate here. I am usin... 6 2/27/2006 11:01:43 PM Print watermark Hi, I have a problem in Excel when printing with a watermark. I want to print multiple worksheets from one workbook at once, with a watermark. So I select all the worksheets, press Ctrl-P for the printer dialog. Then I select in the printer settings the watermark and print the document. But only the pages of the first worksheet get the watermark. All the next worksheets are printed wi... 2 2/26/2006 4:43:26 PM Printing worksheets in an alphabetical order Hi, I need some help. I have several excel files and I need to print all the worksheets in an alphabetical order (based on the worksheet name). Please help. Thanks Fari ... 4 2/23/2006 11:12:44 PM I want Excel Gridlines to show up when printing I do have at least one worksheet in my workbook where I want the gridlines of the cells to print. Can you remind me where to set it so these prints? Thanks in advance. ... 2 2/22/2006 11:44:18 AM Forcing Page numbers to print outside of normal sequence Hi. Looking for a way to print an Excel spreadsheet that is approx. 3 pages - but not with the typical 1,2,3 page number sequence. These 3 pages from this one spreadsheet have to be included in a presentation and inserted after page 24. Therefore, I need my spreadsheet to print with the page numbers 25, 26 and 27. If I add "25" to the custom footer, all 3 pages print out the page ... 2 2/21/2006 8:19:28 PM Print to PDF using a Macro. I am trying to create a macro to print out each sheet to a different file name. Only is that It wont let me specify file. I have tried several different choice and it will stiil not work. See Below Range("A2").Select Selection.Copy Application.Goto Reference:="test" Application.CutCopyMode = False ActiveSheet.PageSetup.PrintArea = "$A$1:$L$62" ActiveWindow.Sele... 1 2/21/2006 7:23:15 PM Automatic Best Fit For Chart Hi There, I create a lot of charts, and I always manually have to change the settings to get the best fit onto A4 paper. Is there a method of automating this process?? tia BigH ... 1 2/20/2006 10:02:32 PM Print all sheets one below? Hi I have more than 12 sheets in my workbook. I group tham and print all sheets. But in some sheets i have not more than 15 to 20 rows and than new sheets start in new page, is there any way can i print all sheets one below other. Thanks Tiya Shah ... 1 2/20/2006 12:02:27 PM Formatting changes when I Print I have some borders on my spreadsheet that, when I try to print the sheet the formatting for some of my columns, and Rows, winds up being thicker than the formatting on the screen. The lines show up thicker in print preview as well. I believe this is probably caused old formatting I may have had on this sheet at one time or another but am not sure. I have even tried to erase the old f... 1 2/14/2006 7:11:51 PM Spreadsheet with autofilters print multiple choices I have inherited a horrible spreadsheet which has a number of autofilters and macros. The data is a list of rounds and pickup days e.g. Day: Monday Round: North 1. I select Day and round from the drop down list and then click a button which starts a macro 'View round sheet'. The round sheet data show the roads filtered out according to the selections I made. I would like to write ... 6 2/14/2006 12:55:28 PM How to set default footer to "none" I've tried creating templates (book.xlt and sheet.xlt) that reside in my XLStart folder; I used Page Setup to set headers and footers to none, but only the header instruction sticks. Every time I create a spreadsheet and go to Print Preview, there is a footer present and I have to go to the dropdown to change it to none. I'm using Excel2003. ... 1 2/9/2006 7:56:10 PM PrintOut Pdf Sendkeys Hi, I'm desperately trying to automate clicking on the save button of PDFWriter v5 dialog box. Do you know how to use these sendKeys ? I never did it, It seems damned simple, but I still can't get it to work ! This is one of the lines i've tried : SendKeys "{ENTER}", False ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat PDFWriter" Thanks in advance for an... 1 2/7/2006 4:04:27 PM (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 2/4/2006 4:09:09 AM (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 2/4/2006 4:09:08 AM Printing Workbook with 2 worksheets per page I have a workbook with around 30 worksheets and wish to reduce the size and print 2 worksheets per a4 page. I have tried everything and i can't seem to get it Please help... 2 2/3/2006 6:10:23 PM Fit To Issue I'm trying to automatically size my print area in a macro and I have not been able to do it manually in this particular worksheet. Note this worksheet is given to me as an excel document but it originally came from HTML. I have chosen 1 wide blank tall on the setup screen. I get a the scaling is then 35%. The issue is that I get a huge blank space on my paper (it is not fiting to one pag... 1 2/1/2006 4:08:52 PM Why the extra white space? Quick question here from a reasonably experienced Excel user. I routinely use page setup options based on 1 page wide and no limit to the number of pages long. I like this because it typically optimizes printouts. Frequently, however, I get excessive white space on the right side or the bottom. I check the Page Preview mode to ensure the print area is not incorrectly set (I nearly al... 2 2/11/2006 3:06:25 PM Print only pages have data I don't want to print out blank pages, how do I tell Excel to stop printing when there is no more data on a worksheet? ... 2 2/13/2006 2:59:37 AM Q.EXCEL2000,Howtoremove margin wholly Subject : Q. EXCEL2000 - How to remove margin wholly ? Page Margin(A4) was set all zero(0) at Excel 2000 (not XP or 2002), but it still remains at 'print preview'. Please advise me how to remove margin completely. I want to fill with Black color(or deep, dark color) for a background on the whole A4 Paper (Characters are white or another color). Thank you ! Linda FE... 1 2/14/2006 4:15:30 AM Q.EXCEL2000,Howtoremove margin wholly Subject : Q. EXCEL2000 - How to remove page margin wholly at the print preview ? Page Margin(A4) was set all zero(0) at Excel 2000 (not XP or 2002), but it still remains AT 'PRINT PREVIEW'. Please advise me "how to remove margin completely at the Print PREVIEW". I want to fill with Black color(or deep, dark color) for a background (filling cell) on the whole AT THE PRINT PREVIE... 1 2/14/2006 5:00:58 AM Excel Does Not Print I saw that there was an older thread with the same problem, but decided to start a new one because there was no solution posted. I have a user here that has a HP3700DN ColorLaser Jet attached to her machine. Excel will not print anything. When she clicks to print the printer icon shows up in the system tray, acts as if it is spooling, then disappears with no output from the printer at all.... 4 2/17/2006 11:35:32 PM "Line Creep" When I go to print an excel document, the print preview looks fine, but when I print, with grid lines of course, the data seems to slowly creep up until you get to the end of the sheet and it looks like the last line has moved up one complete line. I am using office xp with sp3. Any ideas? Thanks Al ... 1 2/28/2006 1:53:35 PM EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 3/1/2006 7:14:08 AM AutoCAD text not printing correctly in Excel I have copyclipped an AutoCAD 2000 drawing into Excel 2003. When I do a print preview, the text on the drawing is correct. When the sheet is printed, the letter "N" looks like a box. How can I fix this? This didnt happen when I was on Excel 98, or 2000. ... 1 1/30/2006 8:03:01 PM Excel doesnt print My Excel XP doesnt print. All other Offfice apps print fine. When I click the print Icon or go to FILE then Print in Excel I don't get an error. Nothing in Spooler.. I Have installed a PDF Writer please help me...it's important. david ... 2 1/31/2006 10:25:21 PM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12