Mobile menu

Printing large Excel file
Thread poster: Rebecca Holmes

Rebecca Holmes
United States
Local time: 12:51
German to English
Jul 20, 2006

I have a rather large Excel file that I would like to be able to print somehow. The problem is that it is almost 2000 lines long and although it is only 4 columns wide, those columns run way off to the right. How can I print this file? I have even tried copying into Word, landscape format, but the last column still runs way off the right-hand side of the page.
Any helpful hints would be must appreciated.


Direct link Reply with quote
 
Sonja Tomaskovic  Identity Verified
Germany
Local time: 18:51
English to German
+ ...
Enable line breaks Jul 20, 2006

You could try to enable line breaks in the cells, and then resize the columns.

To do so, highlight the whole column, right-click and choose Formatting cells. There should be an option called "Line breaks" (Zeilenumbruch in German).

HTH.

Sonja


Direct link Reply with quote
 
Marta Fernandez-Suarez  Identity Verified
United Kingdom
Local time: 17:51
English to Spanish
another option Jul 20, 2006

Not sure if this will work in your case, but you can try.

Select by dragging the mouse what you want to print and then go to
File>Print Area>Set Print Area

Then adjust the Page Setup so that the whole thing fits in, you can try different percentages and then do a preview to verify if the one selected is right. You do this in
File>Page Setup>Page: Adjust to

Regards

Marta

[Edited at 2006-07-20 09:42]


Direct link Reply with quote
 

Rebecca Holmes
United States
Local time: 12:51
German to English
TOPIC STARTER
Thanks Jul 20, 2006

Thanks to you both for your help - I still haven't been able to get it to print perfectly, but it is certainly better than it was before!

Direct link Reply with quote
 
Robert Zawadzki  Identity Verified
Local time: 18:51
English to Polish
+ ...
Print it to PDF and then to printer Jul 20, 2006

PDF995 is one of free PDF printers.
Acrobat reader enables you to print multiple pages per sheet.

There are also tools that do the same trick to Excel, but I never used them.


Direct link Reply with quote
 

Luisa Ramos, CT  Identity Verified
United States
Local time: 12:51
Member (2004)
English to Spanish
Select the column and click twice (sort of) Jul 21, 2006

You say that those columns run way off to the right. I ask, is the data in them equally long or it is just that the columns are defined as that wide. If this is the case, position yourself at the top, select the column you wish to resize, place the cursor over the line between the selected column and the next, the dividing line, and double click. This will reduce the column but keeping it wide enough as to accomodate the longest data in any of its cells. You can also drag the dividing line and resize the column manually or select the columns, go to Column Format and select Auto Fit. (There are many ways to skin a cat.)

Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Printing large Excel file

Advanced search






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
PDF Translation - the Easy Way
TransPDF converts your PDFs to XLIFF ready for professional translation.

TransPDF converts your PDFs to XLIFF ready for professional translation. It also puts your translations back into the PDF to make new PDFs. Quicker and more accurate than hand-editing PDF. Includes free use of Infix PDF Editor with your translated PDFs.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs