Printing Spreadsheet To A Plotter.
How do I print a large spreadsheet to a graphic plotter as a single page?
Similar Excel Video Tutorials
Helpful Excel Macros
Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pag
Is this possible. I need to print 4 worksheets on one large page and print
from the plotter. If not possible, any suggestions? Help . . .
I know this is an easy one but I need some help. I have the following list of printers below - if the name ends with color or plotter - then put a "X" under the color column else "X" goes under the B/W column. I have this statement under the "Color" column
however I need to include an "OR" statement for plotter but I get an error when I do this
=IFERROR(IF(OR (FIND("color",B7,1),FIND("plotter",B7,1)),"X")," ")
When printing charts I will get the gridlines, legend, axis, etc. to print normally but the series will not show up on the printout. This happens when printing to a printer or to a .pdf. It will work if I copy the chart to paint and print from there. Any ideas why this is happening or what can be done to fix it?
Is there a way to print a chart as a banner using a plotter (for instance 8.5" x 30")?
I use an Oce' TDS700 large format printer & am trying to print a very large spreadsheet with limited luck.
I would like to "fit to 1 page" the print area to a single sheet of paper 36"x72" and somewhat "fill" the paper, but the only way I can get the complete print range to print is by unchecking the "fit to 1 page" & checking the scaling button & selecting 83%. This prints all the data within the print range but prints with large paper "margins" top/bottom & left/right. It looks (print preview) as if I could scale at a higher factor but when I scale to any percentage higher I lose columns of print range data.
(I have tried different custom sizes of paper & tried most every printing option available.)
Perhaps I'm missing something? Suggestions?
In my spreadsheet, I have given background colours to a few cells. I also have a coloured graphic on every sheet of the workbook.
Since I don't want to print the cell backgrounds, I have chosen to print the sheet in Black&White from the Page Setup menu. But that also prints the graphic in B&W.
So, is there a workaround where I can avoid printing the cell backgrounds, but still print the graphic in colour?
Thanks in advance.
This is probably a function not capable of Excel, but thought I'd ask.
What I have is an Excel workbook with all our products listed, including codes, descriptions, costs, taxes, etc, and I want to print this information in a formatted way.
I have set up a single spreadsheet with the style I would like excel to print the data, and can auto import the appropriate data fields from the other spreadsheets to populate the areas I want.
However, our product database contains about 100 products, and this new printing spreadsheet i have created fits 5 products each. Now, my options are to just create page after page of tempaltes to print all of our products. Or, is it possible to have Excel continuously use the single page spreadsheet as a printing template and for every new page, just keep referencing to 5 different products every time?
Thanks, and if it sounds like I don't know what I'm talking about, your right!
I'm attempting to plot a large excel table to a HP5500 through Colourgate.
The size is 5945mm x 841mm.
I can set the page size but for some reason only half the data is on the page.
Have i hit the limitations of the program or is there something i am doing wrong?
Have tried everything conceivable withibn excel to get round this problem.
Any suggestions, fixes or help would be awesome!
Even just telling me that i am wasting my time would be good so i can move on...
I am having problems while printing my invoices that I created in Excel. For
some reason my logo graphic gets blown up 10 times the size and shifts to the
right on the printout.
It also will not show up on the Print Preview Page. It just shows a blank
area of the page where the graphic should be.
I tried to create a new spread sheet with another graphic and Excel did the
same thing. The new graphic shows up in the print preview but it changes the
location of the graphic from where I placed it in the new spread sheet
I have data that I want to plot to our Color Plotter. The size of the sheet is 22x34 and of course the data does not fit the entire sheet. How do I stretch/scale the data automatically to make it all fit on one page (scaled up accordingly)? I have tried the fit to page option and some other common sense solutions, but to no avail. Thanks.
( I realize that this is more of printing newsgroup issue, but having
gotten no results there (after a few days....))
---> problem with acrobat (when printing to PDF's) not printing the
value of the cell, but printing the graphic of the page (ex: lines, borders,
the cell values have been formatted by VB code: none of the values print,
only the graphic of the page (ex: borders etc...); if I select a cell (any
cell) and reset the font (thru the usual excel / format / cells...) ; it
seems to consistently be OK, and everything prints
the cell values are simple cell entries: some lines of values print, then
several lines do not , then some following do... but, as with above the
format of the page does print; resetting the font does nothing
I cannot tell if these two conditions (above) are firm; it is what seems to
happen, but it may be only what happens MOST of the time, and then only by
the format is standard Ariel 8 or 10pt
thanks in advance
i have a large spreadsheet that grabs data from many cells. when it comes to printing, i just want to to print the 1st page. I forget all the time and it wants to print 169 pages. is there a default print option per spreadsheet
when i print my small (3 column) spreadsheet, I am unable to make it print
with larger fonts or fill up the page? I have eliminated all but the first
three colums, and yet the spreadsheet prints only to about 1/4 to 1/3 of a
page even with a size 16 font. I am using microsoft office standard, would
office professional have additional features to allow better spreadsheet
I am attempting to print a large excel spreadsheet. This spreadsheet consisted of wrap texts and frozen panes (not sure if this makes a difference). The spreadsheet consists of about 15 columns and 12 rows...The problem is that I need to print this information onto 1 sheet. Help!
Right, to cut a long story short, the web developer at the company I work for has come up with a spreadsheet that we use for processing orders made through our website and also ebay.
Although it is almost perfect, there's one slight flaw with it.
Here's the sheet in question.
which pulls the relevant information from another sheet to create this
Now then, the problem we have is when it comes to printing. As we come to add more customer order details to the data sheet, each row can be printed out as shown in the second screenshot.
The setback is that when it comes to exporting the sheets to .pdf for printing/emailing each row and therefore each seperate order ends up being printed and/or saved as a single document. so if for example we need to print out 20 order sheets to pass on to our warehouse, the orders have to be printed as 20 seperate documents. which as you may know could end up being a bit of a bugger if there's a large printer queue.
Here's the current script for the print button, Ideally what I want is to adapt the script so that its possible to export the orders and merge them into 1 single PDF, or at the very least, print the orders as though it were 1 multi-page document instead of 'x' single page documents.
I have several versions of Excel files, tables that are from (4' H x 5' W) to (2.3' H x 8.3' W) in size when printed. These are for large format printing. It's best to convert these files to PDF first before submitting them for printing.
The problem is that I have a printer driver installed for my 8x11 laserprinter, and this causes insertion of page breaks in the Excel documents, which in turn causes the PDF file to be broken up in 8x11 pages. I want a single-page PDF that doesn't have page breaks so it'll print on as large format printer as a single sheet of paper. IOW: no page breaks.
What can I do here?
I have a large spreadsheet that stops between each page during printing. Can anyone tell me how to correct this? It takes forever to print anything that is based on this file, which is pretty much everything I do.
Trying to select a couple groups of columns that are not adjacent to each other on the Spreadsheet but want to print next to each other on the output. Tried using Page Break functionality but can't seem to figure out how to combine Page 1 and Page 2 into a single page on the printout. Went through Page Setup and everything should fit on a single page. Used the Help functionality without success. I do have my Window set to Freeze so I can eliminate some cells from view but it doesn't seem to make any difference.
I recall being in a seminar/workshop and someone mentioned using a plotter
with Excel for very large paper sizes. However, I cannot find anyway to
customize the paper size.
I have a HUGE Excel spreadsheet and I only want to print a certain page. Is
there any way that I can tell what page the row resides on so that I can
specifically print only that page of the spreadsheet???
Any help would be GREATLY appreciated!
Thanks in advance!
I have a large spreadsheet that I want to print onto ONE page (onto legal size or tabloid size paper). Columns A-K. I can do this from a PC without a problem but when I try to do it from my MAC it shrinks it to 10%. All margins are fine, landscape orientation is fine, and all other print options look normal why does the MAC have a problem with this and the PC works fine?
When I print from Excel, I nearly always use one of two methods:
1) Selecting a single page to print and then choosing the number of copies from the print menu, eg. 50.
2) Selecting single-page print areas to print using a macro (eg. 50 invoices).
In both instances, I end up with a print queue of 50 single page documents.
Using our expensive laser printer, I get about 1 copy every 10 seconds, which rather defeats the object of having an expensive laser printer. Is there any setting/macro/method which would enable me to incorporate such tasks into a single 50 page document, which would then print about ten times quicker?
i have sheet for printing i create page numbers with page brake preview
normally we manual select page for example in print preview i choose page # form printing i mean page 1 print page 5 print and much more
now i want to code for printing i punch code in range a1,for second page print in a2 like it all print who i want
Can anyone please help me with this?
I have a three column spreadsheet like the basic one I've detailed below. The spreadsheet has approx 3000 rows comprsiing of approx 400 different codes. I want to print the spreadsheet with the information for each code appearing on a different page. Therefore, I need a 400 page print out. The "slow" way of doing this is to insert 400 page breaks into the spreadsheet. Is there a quicker way?
Code Variety Qty
123 XYZ 10
123 XYZ 20
127 ABC 10
127 ABC 5
128 QWE 10
128 QWE 17
128 QWE 27
Please help put myself out of this misery that has plagueing me for years. Whenever I design a spreadsheet when I print it out it does not fit to the edge of page. Even if I set the margins the spreadsheet will still have massive margins! I have set the spreadsheet to be one page. I ahve gone into view then page break preview. Everything fits fine. But when I print the margins are different on all sides and it is only like half the size of the paper....what am I missing here. Also I am using Office 2007. Thanks.
I've got an imported graphic that is 300dpi...it's a color .jpg and it looks just fine onscreen after I've inserted it. But when I go to print it, it isn't scaled quite right. It looks like it's expanding just the width of the pic so it looks stretched on the print out. I've looked at the graphic and it's not been scaled at all, it's 100% both height and width. All I did was insert it into a few cells merged together. The weird thing is, it looks totally fine on the screen. It's just after I print it. I also checked my print settings and I'm not enlarging it in any way. I just can't figure out what's goin on here. Anyone have any ideas? I'm using Excel 2000.