LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Working with column and page widths

Hi,

My A4 paper in portrait orientation has a width of 595 points. I have
manipulated the width of seven columns manually to have the largest
width that will just fit on the page. I then expect the sum of
LeftMargin, RightMargin and Columns("A:G").Width to equal my page
width, but it does not. My sum yields 570.45 not 595 points. Any ideas
on where the remaining 24.55 points have disappeared to?

Related to the above is another question: Do cell borders occupy
space?

And another question that has just come to mind: What effect might
font substitution on the printer side have on all this?

Many thanks

Craig

 
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
How to copy & paste row heights and column widths to another page TIG55 Excel Discussion (Misc queries) 2 January 2nd 09 06:09 PM
Controlling column widths in interactive web page output Chris Collingridge Excel Discussion (Misc queries) 1 December 15th 06 12:38 PM
Controlling column widths in interactive web page output Chris Collingridge Excel Worksheet Functions 0 December 13th 06 03:52 PM
Need to change column widths in middle of page. cruz2man Excel Discussion (Misc queries) 1 May 19th 06 04:11 AM
having a two tables on the same page with different widths southerntwangqt Excel Worksheet Functions 2 September 14th 05 05:44 PM


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

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

About Us

"It's about Microsoft Excel"