Printing large Excel file
Thread poster: Rebecca Holmes

Rebecca Holmes
United States
Local time: 13:07
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.


 

Sonja Tomaskovic (X)  Identity Verified
Germany
Local time: 19:07
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


 

Marta Fernandez-Suarez (X)  Identity Verified
United Kingdom
Local time: 18:07
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]


 

Rebecca Holmes
United States
Local time: 13:07
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!

 

Robert Zawadzki (X)  Identity Verified
Local time: 19:07
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.


 

Luisa Ramos, CT  Identity Verified
United States
Local time: 13:07
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.)

 


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






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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