Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!


Free Excel Forum

Printing Spreadsheet To A Plotter.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

How do I print a large spreadsheet to a graphic plotter as a single page?

View Answers     

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
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Output the Name of the Current Excel Workbook Including Extension - UDF
- Free Excel UDF to display the name of the current Excel workbook, including the workbook extension. This function has n

Similar Topics

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

=IFERROR(IF(FIND("color",B7,1),"X")," ")

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")," ")

Any ideas?

Printer Name B/W Color 2-1-color X 2-5 X 2-6 X 2-413-plotter X X 2-10 X 2-12 X

Question 1:

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?

Question 2:

Is there a way to print a chart as a banner using a plotter (for instance 8.5" x 30")?

I have just recently switched from Excel 2003 to 2010 and have some printing issues with graphic characters not printing in the position displayed. I have narrowed the issue to when you re-size on page setup to fit to page the graphic characters stay at 100% while the rest of the data gets reduced. Everything will print just fine if you print without reducing or enlarging. I never had any of this with 2003 and when I switched to 2010 all the spreadsheet that had any graphic images are not printing correctly. I understand the Excel 2010 treats all graphics as layers or selection pane but how do you get the layers to re-size with the printed data?

Thanks in advance.

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?
Thank you.

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

Cheers, Dan.

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

Any Ideas


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,
and fill)

case 1
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

case 2
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

Hello All,

I am having trouble printing my excel spreadsheet. I want to print the column headings and also a certain row below, say row 7 together. However, when I select the heading row and that row and try to print my selection it prints on separate pages. Is there a way to print all on one page?

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!

Thank you!

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?

Hello All,

I am having trouble printing my excel spreadsheet. I want to print the column headings and also a certain row below, say row 7 together. However, when I select the heading row and that row and try to print my selection it prints on separate pages. Is there a way to print all on one page?

In the general forum they talked about using macros and VBA. I am not sure how to do so. Any help will be greatly appreciated.

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

Hi folks,
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?

Thank you.

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?