Printing Spreadsheet To A Plotter.

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!

Hi,

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

Thanks

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.

oz

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

the format is standard Ariel 8 or 10pt


thanks in advance
mark

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

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?

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?

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

Many thnaks
Jon


Code Variety Qty
123 XYZ 10
123 XYZ 20
127 ABC 10
127 ABC 5
128 QWE 10
128 QWE 17
128 QWE 27

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