+ Reply to Thread
Results 1 to 3 of 3

View Excel Cells Through a .JPEG

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    Stockton, CA
    MS-Off Ver
    Excel 2010
    Posts
    5

    View Excel Cells Through a .JPEG

    Hello All,
    This may be a question for the artistic types but I thought I would start here. I'm trying to consecutively number windows in a railroad passenger car from 1 to 128 and want to do so with the car .jpeg on top of the spreadsheet. Can this be done? See the attached for an example...
    Thanks in advance,
    acemotorman
    Bombardier Vehicle Exterior Drawings.jpg

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: View Excel Cells Through a .JPEG

    If you want a picture of a railroad car at the top of the sheet: Select A1 go to Insert, 'Picture, browse your PC for the pic and press 'Enter.

    If you want to place the car numbers on top of the pic then go back to Insert, select 'Text Box and draw the box over the windows then add
    your #'s.

    If you want to be more "Artsy" then I would suggest using an external program to edit the picture 1st because you can not see cells underneath the picture.
    Last edited by BlindAlley; 10-03-2016 at 04:40 PM.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,174

    Re: View Excel Cells Through a .JPEG

    You will need to manipulate the image first. Copy the image to paint and fill the windows you want to see through with a colour not used in the rest of the image.
    Copy the image back into Excel and use the Set Transparency button, Picture Tools > Adjust > Color > Set transparent color, to make that colour transparent. Then align cells to appear in windows.

    In the example I coloured a few windows red and then made them clear. Both images are included.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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] How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  2. How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  3. How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. How do I view a JPEG file from data selected in Excel
    By gilg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2005, 05:05 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