+ Reply to Thread
Results 1 to 5 of 5

in excel 2002, how do i define the cell size by inches?

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    north america
    MS-Off Ver
    Excel 2002 YES still in 2025
    Posts
    196

    in excel 2002, how do i define the cell size by inches?

    say 5 inchs wide and 3 inches high
    thanks

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: in excel 2002, how do i define the cell size by inches?

    I don't have an older version of Excel to test with, but perhaps something similar to the instructions here...
    https://www.automateexcel.com/how-to/change-cell-size-pixels-inches
    Essentially you'd change the default "ruler" from pixels to inches, then in Page Layout view, use Format Cells > Column (or Row) to set the width/height in inches.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,453

    Re: in excel 2002, how do i define the cell size by inches?

    I cannot find a default "ruler" option in my copy of 2002 as shown in Paul's link. I can find a default "ruler" option in my copy of 2007. Scanning the help files for 2002, I do not find anything that talks about changing the default measurement unit for column width and row height. In these help files, they repeatedly say that the "unit" value used in the column width dialog is "average number of 0-9 digits that fit using the standard font. You might be able to infer something about the width (in inches) by knowing something about the average width of numbers in your standard chosen font.

    In the end, though, I expect it will be best to try a couple of different settings and relate the number entered to the actual width you see (whether on screen or in print -- depending on which version is most important to you). After a few direct measurements, it should be possible to develop a column width number to inches conversion that you can store in your head or in a spreadsheet or on sheet of paper near your computer. Repeat for the row height numbers. Then you can use your unit conversion to enter numbers that will correspond to your desire column width and row height.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,453

    Re: in excel 2002, how do i define the cell size by inches?

    Upon further research, it appears that the default unit for column width and row height is "points" (whatever that means). This Q&A suggests that the conversion for row height is 72 points per inch and column width is 12 points per inch. So, 5 inches wide should be 5*12=60 column width points and 3 inches high should be 3*72=216 row height points. https://answers.microsoft.com/en-us/...d-e391c0ab635f

    See if that helps.

  5. #5
    Forum Contributor
    Join Date
    08-20-2013
    Location
    north america
    MS-Off Ver
    Excel 2002 YES still in 2025
    Posts
    196

    Re: in excel 2002, how do i define the cell size by inches?

    Now i know what to do
    thanks VERY much all.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ligne Button Size metric mm imperial inches Excel VBA formulas
    By theclockmaker in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-27-2021, 08:46 AM
  2. printing to exact size excel 2002
    By anon125 in forum Excel General
    Replies: 9
    Last Post: 02-21-2017, 10:48 PM
  3. Define named range where user can define size
    By nahousto in forum Excel General
    Replies: 4
    Last Post: 07-06-2009, 05:09 PM
  4. [SOLVED] HOW TO SET PAGE SIZE OF 3 INCHES HIGH BY 5 INCHES WIDE
    By bean guy in forum Excel General
    Replies: 2
    Last Post: 05-23-2006, 02:25 PM
  5. [SOLVED] How do you define a custom paper size in Excel? (i.e. 11x17)
    By Marcin Rembisz in forum Excel General
    Replies: 1
    Last Post: 09-21-2005, 10:05 AM
  6. How do I print graphs poster size (4 - 8 1/2 x 11) in Excel 2002?
    By Library Dragon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2005, 12:05 PM
  7. [SOLVED] Change measurements from inches to centimeters in EXCEL 2002?
    By MaggieBrennan in forum Excel General
    Replies: 0
    Last Post: 05-25-2005, 05:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1