View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Column Widths in Word and Excel

Hi,

Am Sat, 6 Jun 2015 13:06:30 -0700 (PDT) schrieb :

So it appears that Word and Excel use different measurements for column heights and widths. Word's table cell measurements are apparently in inches. Are Excel's in pixels? Not sure.

I have Excel tables I need to paste into Word. I want to set my Excel table heights and widths to match Word's. Is there a way to do this calculation? I tried converting inches to pixels and that doesn't seem to work.


in Excel the width is the width in characters.
Try:
Excel options = Advanced = Display and set the ruler units to inches.
You can check the width of the columns in Word and can modify the width
in Excel = Page Layout.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional