+ Reply to Thread
Results 1 to 5 of 5

Hide images when Hiding Rows

  1. #1
    Registered User
    Join Date
    06-22-2006
    Posts
    2

    Hide images when Hiding Rows

    I have inserted images into cells, but when I hide the column the images are not hidden with that column, they just get squished between the two cells next to the hidden cell. Is there a setting or way to tie the image to that cell so that it hides/unhides appropriately with the row?

  2. #2
    Gord Dibben
    Guest

    Re: Hide images when Hiding Rows

    Kurt

    You cannot insert an image into a cell.

    You can overlay a cell with an image.

    Select the image and Format>Properties>Move and size with cells.


    Gord Dibben MS Excel MVP

    On Thu, 22 Jun 2006 13:41:43 -0500, kurt
    <[email protected]> wrote:

    >
    >I have inserted images into cells, but when I hide the column the images
    >are not hidden with that column, they just get squished between the two
    >cells next to the hidden cell. Is there a setting or way to tie the
    >image to that cell so that it hides/unhides appropriately with the row?



  3. #3
    Registered User
    Join Date
    06-22-2006
    Posts
    2

    Thanks

    I only had it set to "Move but don't size with cells" thanks for the tip.

  4. #4
    Registered User
    Join Date
    04-19-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Hide images when Hiding Rows

    Quote Originally Posted by Gord Dibben View Post
    Kurt

    You cannot insert an image into a cell.

    You can overlay a cell with an image.

    Select the image and Format>Properties>Move and size with cells.


    Gord Dibben MS Excel MVP

    On Thu, 22 Jun 2006 13:41:43 -0500, kurt
    <[email protected]> wrote:

    >
    >I have inserted images into cells, but when I hide the column the images
    >are not hidden with that column, they just get squished between the two
    >cells next to the hidden cell. Is there a setting or way to tie the
    >image to that cell so that it hides/unhides appropriately with the row?
    You are awesome! I thought it was impossible until I found this thread... something so simple had me stumped

  5. #5
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Marlborough
    MS-Off Ver
    365 (latest beta)
    Posts
    57

    Re: Hide images when Hiding Rows

    I realise this thread is now 10 years old but it's just helped me with a frustration I've had for years!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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