Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   how to print formulas onto paper Can anyone tell me how to print not the result of a formula but the full equation itself in a cell or series of cells? This will help me track down a problem much easier than trying to do it on the screen. Excell Help is no help. Excell Knowlege Base is no help. Maybe some smart good soul will reply to fishberg@rcn.com Thanks!... 4 12/18/2005 9:24:49 PM Multiple Print areas? I have a large spreadsheet that I would like to be printed on three 11x17 pages: Page1: A1:AF52 Page2: A53:AF110 Page3: AI53:BJ110 This works OK except we also get a blank 4th sheet to print for AI1:AF52 which is directly above Page3 and has no data in it. Is there a way to set the print feature up to only print the areas that we want. I've tried setting a print area, but it se... 6 12/15/2005 7:37:26 PM border format causing the doc to be hundreds of pages long I have a spreadsheet that is about 6 pages long. Evidently, someone has applied a border to some cells , that seem to go on and on forever. Therefore, the worksheet looks to be hundreds and hundreds of pages... all the extra pages have a bold line down one of the columes. I have tried to select all the range and get rid of the bold , but the spreadsheet goes on forever.. I never get t... 9 12/12/2005 7:52:16 PM cleaning custome header / custom footer drop down list Is it possible to clear the custom header / custom footer drop down list in page setup ? If yes how I can do it. Regards, Tony... 3 12/12/2005 5:15:30 PM Alt+ Return Hi, I have a strange thing happening in a couple of cells in a worksheet, all cells are formatted to allow Wrapping and Alt + Return is used for a next line, all calls look fine when you are working on them, however when you print or print preview some of the cells look as if an extra Alt+Return has been used at the end of the last paragraph causing a blank row, I have tried all manner o... 3 12/12/2005 11:41:02 AM Words above above cell borders! Hi: I never seen this one before, but my co-worker printed out a simple sheet, the wording in the upper rows is inside the border cell, but the last row on the page, the words are printing on top of the cells border? any clues? ... 2 12/10/2005 6:24:43 PM Need button to print to network printer We have a "Timesheet" workbook stored on our shared server that several people use to create their weekly timesheet. Currently, they print to the local printer and hand carry a copy to the payroll clerk. I want to create a form button that anyone, anywhere can press to send the printout directly to the payroll clerk's shared network printer. This would be like the feature MS Access ha... 1 11/30/2005 8:50:15 PM Global Print Specs I have a series of 114 workbooks with 22 worksheets each. They are setup for A4 printing. Is there a way to print all worksheets in each workbook on 8½x11 with row and column headings without specifying it on each worksheet individually? I am using Excell 2000. Steve Williams ... 2 11/30/2005 8:36:04 PM Validation Cell On my Worksheet Cell A1 is a validate cell. Its a drop down box listing all bowlers who participated in the bowling tournament. The worksheet lists all personal scores and averages and a graph of there scores. At the end of the tournament i wish to be able to print all bowlers sheets off. I am looking for a quick way of doing it. Rather than having to select each bowler and clicki... 4 11/24/2005 6:26:54 PM Duplex printing I am attempting to print from excel to a colour printer with double sided printing. I have changed the configuration of the advanced settings in Print options to double sided but it still prints on a single page. Is there something I have missed? ... 2 11/19/2005 8:38:30 PM Printing Headings in Excel with OS X Tiger I have created a spreadsheet with the headings at an angle. I am printing to an HP Color Laserjet 4650. When I preview the headings are there. As soon as I bring the print window up to print the text disappears in the angled headers. When I change these headers to horizontal or vertical the text appears fine, but when the orientation is changed to the angle the text is gone when I print. ... 1 11/16/2005 3:43:17 PM Print Preview Won't Let Me Print The Same Page Twice Hello, I have print preview set up for all my documents so I don't print something I don't want. The problem is, when I want to print 1 copy of the worksheet everything is fine, but when I print 2 or more of the same worksheet, one will print and then print preview will load the same one again before printing it and then again each time until the number of copies I want is printed. ... 1 11/5/2005 6:05:09 PM Gridlines Using Excel 2003. Is it possible to set the Print Gridlines option in Page Setup on by default? It is currently off, and needs to be set on for each sheet. Thanks, Betty... 2 11/4/2005 3:05:13 PM Print Function in VB? I just need to know, if I create a button in excel sheet, what forumla I have to put in VB for it to print?... 5 11/2/2005 12:30:01 PM 2003 compatibility with earlier versions HELP! I have a ton of spreadsheets that were created with excel xp, or 2000, or 2002. If I bring up a spreadsheet created in excel xp or 2000, the spreadsheet has the printer information (i.e. "print on both sides") stored. Even if the printer I am attached to does not have "print on both sides" as a default preference. If I bring up the same spreadsheet using excel 2003, it doesn't ... 1 11/2/2005 12:28:45 PM printing defaults lost Hi, Does anyone know why this is happening? If I open a saved excel spreadsheet in excel 2003, if that spreadsheet had been saved with excel 2002 or xp, it overrides the saved print settings (ie. print on both sides) and changes it to not print on both sides. Further explanation. I save an excel spreadsheet on excel 2000 or 2002 or xp. It retains the "print on both sides" value in pri... 1 11/1/2005 6:52:52 PM Embedded Word object Hi, I have an excel spreadsheet with an embedded Word Document. When a user inputs information into the word doc and this goes over 2 or more pages, when the excel form is printed, only the first page of the word doc is printed out. Is it possible to be able to print out all the pages withing the word document plus the information withing the excel form. Thanks in advance for any h... 1 11/1/2005 2:43:04 PM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12