#1   Report Post  
jsc3489
 
Posts: n/a
Default column width

If I want my column to be 1" when I print, what number do I put in the
'column width' box?

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default

If you want to set column width, select the column and pull-down:
Format Column Autofit Selection

If you want the header to say "1" instead of "A", then pull-down:
Tools Options General and check the R1C1 box
--
Gary's Student


"jsc3489" wrote:

If I want my column to be 1" when I print, what number do I put in the
'column width' box?

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

  #3   Report Post  
jsc3489
 
Posts: n/a
Default

???? I want my column width to be 1 inch (1"), and my row height to be 1/4
(.25) inch. Stupid Excel, why not have a pixel (or character) to inch (or cm)
converter built in so I know how wide (or tall) my stuff will be when I print
it? AAARRRGGGHHH
--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!


"Gary''s Student" wrote:

If you want to set column width, select the column and pull-down:
Format Column Autofit Selection

If you want the header to say "1" instead of "A", then pull-down:
Tools Options General and check the R1C1 box
--
Gary's Student


"jsc3489" wrote:

If I want my column to be 1" when I print, what number do I put in the
'column width' box?

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

  #4   Report Post  
Dave O
 
Posts: n/a
Default

A search on this newsgroup yielded this:

http://groups.google.com/group/micro...86fab77f0d7107

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default column width

I have just discovered (maybe I am a slow discoverer) that in Excel 2007
column width measurements are in inches in Page Layout View. When you are in
Normal view, column width is Excel's normal funky measurements.

"jsc3489" wrote:

If I want my column to be 1" when I print, what number do I put in the
'column width' box?

--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!

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
Running total w/2 columns - Excel Anna / Ideal Excel Worksheet Functions 14 August 10th 05 04:28 PM
Changed column width keeps reverting back to original size David Boone Excel Discussion (Misc queries) 3 May 29th 05 01:22 PM
Is it possible to create one column with two different width? Dave H... Excel Worksheet Functions 1 February 21st 05 05:52 PM
fixed column width with text string Sarah Excel Discussion (Misc queries) 1 February 8th 05 09:09 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM


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

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"