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 Tutorials

Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Prevent Charts from Printing in Excel
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to ...
Set a Photo/Image as an Excel Worksheet Background
One of the really cool formatting features of Excel is that you can actually set a picture from your computer as t ...
Quickly Find All Comments in a Spreadsheet in Excel
In Excel, you can create a comment for any cell in the worksheet. The problem is that these comments are hard to f ...

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

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

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?

Okay guys,

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.

Hi all,
I've got an imported graphic that is'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.


When printing a large spreadsheet in A3 format, I get the print in full with, but the height is about 50% of the paper height.

I have marked the print area, I have checked the One page height and One page with. Is there a way to get the print to fill out the entire paper size in both directions, or is it impossible due to scaling?

Please help.

Best regards

Sten Olsen, Oslo Norway

I'm printing out a spreadsheet, and I have set a row to appear on the top of each page by going to 'page setup'/'sheet'/'print titles'.

However, I want this to change for different pages.
Is it possible to choose a different header row for each page that is printed?



Hi all

Assuming I have a spreadsheet that is only 10 rows of data but 100 colums.

Now when I print, I can put page breaks in and select what prints on the top, but what I really would like to do is (instead of printing only on the first 1/8'th of each page) is to wrap my print so that I can fit a couple of blocks of the 10 rows on each page, thus making it more readable and use a lot less paper.

Is there a simple way to do this in Excel 2007 or an add in that one can access?

Thanks up front for your responses

I've created a spreadsheet to track all of my expenses on a daily basis. i'm quite pleased with the way it turned out and have used it daily for 7 months.

However, I'm trying to print out the spreadsheet and am having many errors. I realized that when viewing as "print preview" many of the dates and formatting i used were changing.

When I printed it 2 pages were completely skipped and it tells me it is only a 7page document when its really 9 pages. The generated dates at the top are printing over each other or out of order or not printing at all. It's taking forever to spool on the printer (over 30 minutes). I've tried different printers but that didn't help.

It's not only the printing though. In print preview after page 5 the borders change and the dates don't display right. But it all looks right in the main viewing screen.

I've tried resetting all page breaks and settings and creating a new sheet but the same errors occurred.

I've spent hours trying to fix this and its driving me crazy!!

Please help!!!

I can post my spreadsheet online if that helps.