Excel 2007 printed columns is too wide

Gateway Atxstf
July 19, 2015 at 12:21:54
Specs: Win7 Ult x32, 4Gb
When I arrange the worksheet columns to be only as wide as they need to be, the print preview (and the actual print out) has extra space after (to the right of) the last entry in the cell. So a cell that looks like : |xxx|, when printed, looks like : |xxx |. Can that be remedied ? The work-around I have found, is to make the original columns too narrow, so that the rightmost contents are hidden from view - that is really a quite undesirable method, though it achieves a 'correct' printout.

Basty

message edited by Sebastian42


See More: Excel 2007 printed columns is too wide

Report •


#1
July 19, 2015 at 17:12:44
How are you setting the columns to be "only as wide as they need to be"? Are you manually setting them or are you doubling clicking the column separator so that Excel sizes them automatically?

I have experienced times when setting them automatically looks good on the screen when viewing the spreadsheet, but prints differently than what is shown. It may have something to do with the print drivers (which I can't control at work which is where I usually see the problem) but I'm not sure.

Are you sure that there isn't actually a trailing space in the cells?

Have you tried changing fonts just to see what happens?

I'm just tossing stuff out for you to consider since I can't actually test anything or see your spreadsheet from where I'm sitting.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 19, 2015 at 19:20:44
1. I've used all three methods. The top rows contain 'merge & centre', which seem to produce an unexpected response to double-clicking the right edge of the merged cells,
in one case introducing a 'trailing space', and in another, narrowing the merged cells far too much.
2. I'm sure there are no trailing spaces.
3. I've changed to both Ariel and Courier fonts without improvement.

I now have a suitable SS to upload to show the problem, but the instructions "To line up the data/table(s) or VBA code in your post on Computing.Net, use the tag found above the Reply box." do not match the website layout - I can find no ''" nor a reply 'box'.
Basty

message edited by Sebastian42


Report •

#3
July 20, 2015 at 04:16:42
You can't upload files in this forum. You can only enter text to show examples and use the pre tags to arrange the columns. That would not help in this situation since simply posting the data as text which we would then copy into a spreadsheet probably wouldn't show the printing problem.

You can upload the file to a site such as zippyshare and then post the link back here. Just don't use a site that will require us to register, because we probably won't go through the trouble. Be sure to remove any personally identifiable data from the file before uploading.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
July 20, 2015 at 05:12:57
There is text missing from my second post, and when I edited it to put it back, I only got an extra " . I have used Dropbox - but will try zippyshare.

Basty


Report •

#5
July 20, 2015 at 05:16:02
Zippyshare appears to become disabled, when I 'drag' the 10Kb XLSX to it

Basty


Report •

#6
July 20, 2015 at 05:18:02
Seems DRAGGING is the problem. Browsing triggered : http://www87.zippyshare.com/v/EWQEd...

Basty


Report •

#7
July 20, 2015 at 05:31:37
Sorry, but zippyshare is blocked at my work location so I can't see the error. Most sites that allow downloads are blocked.

I can check this evening, EST.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#8
July 21, 2015 at 06:50:51
I looked at your spreadsheet and also looked at the results of a few of my own. Based on my brief testing, it looks to me as if there is some extra space added after each column in all spreadsheets. In other words, you are not alone.

One possible fix, assuming the printed results are more important than the viewable results, is to use the Show Margins features in Print Preview. When I dragged the margins in Print Preview to force 2 columns with text to print right next to each other, the resulting view back in the spreadsheet showed one column overlapping the other by almost 2 full characters.

Maybe there is a real fix, perhaps via some setting in the Margins or Indent features, but the issue hasn't been anything I've needed to deal with on a global basis, so I've just manually fixed things on the rare occasions when I needed to,

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#9
July 21, 2015 at 16:29:07
As I outlined, I already have a workaround. Your suggestion of increasing the right margin, led to an overall scaling down of the 'sample' worksheet, without affecting the 'original' view. Thanks for your persistence with this.

Basty


Report •

#10
July 21, 2015 at 16:56:42
I'm glad you have found a workaround.

You may have misunderstood my response, and now that I've reread my post I can see why. Allow me to explain what I meant.

I was not suggesting that you increase the right margin of the spreadsheet, I was suggesting that you move the "margins" of the individual columns in Print Preview until you get a printout that meets your needs.

When you click the Show Margins button in the Print Preview window, it shows you where each column "margin" is. It seems that the location of column "margins" for printing is different that the column margins in the spreadsheet.

I was able to get text in adjacent columns to print right next to each other by moving the column margins in Print Preview, and while it looked OK in Print Preview and on paper, it caused the columns to overlap when viewing the spreadsheet itself.

In any case, I'm glad you problem is solved.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#11
July 21, 2015 at 17:11:48
That was basically my 'workaround'.

Basty

message edited by Sebastian42


Report •


Ask Question