ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rows are shifting slightly when printed (https://www.excelbanter.com/excel-discussion-misc-queries/244408-rows-shifting-slightly-when-printed.html)

Matt Lauer

Rows are shifting slightly when printed
 
The problem I am having is that my rows seem to be shifting by what seems
like a couple pixels each. This wouldn't be that big of a deal but after
about 10 rows it's pretty obvious that it's not printing the exact row sizes
I have specified. I have made sure that all my rows and columns are the
exact same values as eachother as well. Maybe there is some invisible border
that is being printed, I don't know.

KC

Rows are shifting slightly when printed
 
Matt,
can you try the below two options?
1)
select all the rows
Format Rows AutoFit

2)
select all the rows
Format Rows Row Height
enter 12.75 or whatever you think it should be and click OK

-kc
*Click YES if this helps



"Matt Lauer" wrote:

The problem I am having is that my rows seem to be shifting by what seems
like a couple pixels each. This wouldn't be that big of a deal but after
about 10 rows it's pretty obvious that it's not printing the exact row sizes
I have specified. I have made sure that all my rows and columns are the
exact same values as eachother as well. Maybe there is some invisible border
that is being printed, I don't know.


Matt Lauer[_2_]

Rows are shifting slightly when printed
 
I already have all the rows set to static values.

"KC" wrote:

Matt,
can you try the below two options?
1)
select all the rows
Format Rows AutoFit

2)
select all the rows
Format Rows Row Height
enter 12.75 or whatever you think it should be and click OK

-kc
*Click YES if this helps



"Matt Lauer" wrote:

The problem I am having is that my rows seem to be shifting by what seems
like a couple pixels each. This wouldn't be that big of a deal but after
about 10 rows it's pretty obvious that it's not printing the exact row sizes
I have specified. I have made sure that all my rows and columns are the
exact same values as eachother as well. Maybe there is some invisible border
that is being printed, I don't know.


KC

Rows are shifting slightly when printed
 
Matt!
sorry i can't think of anything else, ideally you should get what you see on
the print preview, if that is not happening then i don't know why!

can you try to print this onto pdf or Microsoft XPS Document and see if the
rows are shifting in there as well? if it is not shifting then try to print
it from pdf or microsoft XPS Document to printer..

-kc


"Matt Lauer" wrote:

I already have all the rows set to static values.

"KC" wrote:

Matt,
can you try the below two options?
1)
select all the rows
Format Rows AutoFit

2)
select all the rows
Format Rows Row Height
enter 12.75 or whatever you think it should be and click OK

-kc
*Click YES if this helps



"Matt Lauer" wrote:

The problem I am having is that my rows seem to be shifting by what seems
like a couple pixels each. This wouldn't be that big of a deal but after
about 10 rows it's pretty obvious that it's not printing the exact row sizes
I have specified. I have made sure that all my rows and columns are the
exact same values as eachother as well. Maybe there is some invisible border
that is being printed, I don't know.


Dave Peterson

Rows are shifting slightly when printed
 
Or maybe it's the printer or printer driver????

Have you tested a different printer or gotten a newer driver from the
manufacturer's site?

Matt Lauer wrote:

The problem I am having is that my rows seem to be shifting by what seems
like a couple pixels each. This wouldn't be that big of a deal but after
about 10 rows it's pretty obvious that it's not printing the exact row sizes
I have specified. I have made sure that all my rows and columns are the
exact same values as eachother as well. Maybe there is some invisible border
that is being printed, I don't know.


--

Dave Peterson


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com