+ Reply to Thread
Results 1 to 4 of 4

Change Pixels to Inches

  1. #1
    Registered User
    Join Date
    08-09-2015
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    55

    Change Pixels to Inches

    Hi All,
    Can someone please help me change Pixels to Inches on the MS 360 Excel Grid?

    I did a google and came up with :Go to File > Options > Advanced > Display > select an option from the Ruler Units list.
    But no help.

    Thanks in advance.
    Mike

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Change Pixels to Inches

    Excel is a spreadsheet software that is primarily designed for working with numbers and calculations, rather than manipulating graphical images. As such, Excel does not have a direct way to convert pixels to inches. However, you can use a formula to calculate the conversion manually.

    Here are the steps you can follow:

    First, determine the resolution of the image in pixels per inch (PPI). This information can usually be found in the image file properties or can be calculated using an image editing program.

    Determine the size of the image in pixels by looking at the image dimensions in pixels.

    Divide the size of the image in pixels by the resolution in pixels per inch. This will give you the size of the image in inches.

    For example, if you have an image that is 800 pixels wide and 600 pixels tall, and the resolution is 100 pixels per inch, the image size in inches would be:

    Width in inches = 800 / 100 = 8 inches
    Height in inches = 600 / 100 = 6 inches

    You can then enter these values into Excel as needed. Keep in mind that this method is only an estimate and may not be entirely accurate, especially for images with varying resolutions.

  3. #3
    Registered User
    Join Date
    08-09-2015
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    55

    Re: Change Pixels to Inches

    Hi Sandy666,
    After reading your very well thought out answer, I discovered that I was going about my problem the wrong way.
    I did not need to change to Inches. I just had to use the correct number that describe the size of the cell.
    I was trying to use the Height number instead of the Pixel number to get a square cell. After reading your reply, I realized how to do what I wanted.

    I thank you Sandy666 and apologies for not stating clearly what I wanted as an end result.

    All of you Forum Responders are great.
    Mike

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Change Pixels to Inches

    You are welcome
    Have a nice day

+ 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. [SOLVED] Convert feet, inches, fractions to inches and decimals
    By bjohnsonac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-03-2021, 12:08 PM
  2. Row Height / Ruler / pixels, points, and inches
    By jcordell65 in forum Excel General
    Replies: 4
    Last Post: 03-25-2018, 11:27 PM
  3. Resolution variations - pixels, inches
    By pughmd in forum Excel General
    Replies: 7
    Last Post: 07-03-2009, 12:09 PM
  4. How do I change the autoshape size from inches to cm
    By Francois in forum Excel General
    Replies: 2
    Last Post: 08-12-2006, 11:30 AM
  5. change margens messure from inches to cm.
    By Papucho in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2006, 03:20 AM
  6. [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
  7. Replies: 2
    Last Post: 04-25-2005, 11:06 PM

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