Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 94
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 94
Default 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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows and Shifting Up - Repost D.Parker Excel Discussion (Misc queries) 14 October 11th 07 04:58 AM
Shifting rows into columns biggg_fish Excel Discussion (Misc queries) 2 March 28th 07 03:13 AM
Print few rows with many colums so that rows wrap on printed pages usfgradstudent31 Excel Discussion (Misc queries) 1 October 20th 05 02:39 PM
rows break across printed page Kimmie B Excel Discussion (Misc queries) 2 August 23rd 05 09:54 PM
Shifting Date from all data on one row to several rows ChuckW Excel Discussion (Misc queries) 1 June 8th 05 07:56 PM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"