Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deb Deb is offline
external usenet poster
 
Posts: 102
Default How can I set up my columns and rows in inches?

I have Excel 2000. Can I set up my columns and rows in inches?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default How can I set up my columns and rows in inches?

In pre-2007 versions of Excel there isn't any easy/quick way to measure/set
column width or row height in inches. Column width is set by pixels although
the approximate number of characters that will fit in a cell are displayed.
There are approximately 96 pixels per inch.

I think the best you can do in Excel 2000 would be to experiment with
setting the width until you find a setting that is approximately 1 inch wide
and note that value for future use.

In Excel 2007, you can set the width in inches when you are in Page Layout
view - it even provides horizontal/vertical rulers on screen in that mode.


"deb" wrote:

I have Excel 2000. Can I set up my columns and rows in inches?

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
Converting from feet, inches and fractions to inches and decimal p Dee Setting up and Configuration of Excel 5 September 18th 07 04:18 PM
columns and rows in inches TR Young Setting up and Configuration of Excel 3 February 1st 07 07:24 PM
HOW TO SET PAGE SIZE OF 3 INCHES HIGH BY 5 INCHES WIDE bean guy Excel Discussion (Misc queries) 2 May 23rd 06 07:20 PM
How can I resize columns and rows to inches? Max Gough Excel Discussion (Misc queries) 4 June 30th 05 11:44 PM
is there a macro that will convert from inches to feet and inches cable guy Excel Discussion (Misc queries) 1 June 20th 05 07:29 PM


All times are GMT +1. The time now is 11:37 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"