General discussion

Locked

Excel Trouble

By mbertel ·
I have a user that has an Excel file that is 10 pages long. When she calls up the file to be printed for no apparant reason the file is now 30 pages long. Here are some of the things I've done so far. Used different print drivers, used different printers, took the file and put it on someone elses machine and still the same problem, I narrowed the columns thinking this might reduce the amount of paper it would take up printing this particular file, I renamed the file hoping this would fix it. There are no viruses to my knowledge. Have I made matters worse? Its quite obvious I have'nt found the fix. I would appreciate any help that any one can give me. Thank you for you help.

Markus R Bertel

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Trouble

by miubhi In reply to Excel Trouble

Markus,
I would look at the formatting of columns & rows. Specifically, are there any rows underlined? I have found that users like to click the row header & then select underline. This underlines the entire row clear to the end of the spreadsheet, and will cause unnecessary pages to be added. You will not see the underline in the print preview but on the actual spreadsheet.
Some row or column somewhere has formatting that is causing the extra pages.
Hope this helps.
DJ Beasley

Collapse -

Excel Trouble

by mbertel In reply to Excel Trouble

Poster rated this answer

Collapse -

Excel Trouble

by SuzanneI In reply to Excel Trouble

Is it printing 10 pages of information on 30 pieces of paper? If so, your print area might be off. Select the range of cells that you want to print and then select Print Area>>Set Print Area from the File menu.

Other things you can play around with: reduce your margins to 0.5 or 0.25 inches; reduce your font size, and row height/column width. Also, if the width of your print area is maybe a bit too wide to fit on one page, in Page Setup set it to Fit to 1 page wide by 10 pages long (adjust these numbers if the document is supposed to be 2 pages wide and 5 pages long, or whatever).

Hope something in here helps.

Collapse -

Excel Trouble

by mbertel In reply to Excel Trouble

Poster rated this answer

Collapse -

Excel Trouble

by DKlippert In reply to Excel Trouble

Look at it with File>Page Set Up>Page Fit to 1 page wide by 100 pages tall.

Collapse -

Excel Trouble

by mbertel In reply to Excel Trouble

Poster rated this answer

Collapse -

Excel Trouble

by mbertel In reply to Excel Trouble

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums