Excel 2008: graphics don't sort & info pastes into hidden cells

Discussion in 'Mac Apps and Mac App Store' started by Dinaall, Jul 16, 2009.

  1. Dinaall macrumors newbie

    Joined:
    Jul 16, 2009
    #1
    I have a huge problem with excel in office 2008:

    when I sort, graphics inside a cell don't sort with their line. The graphics have been sized to fit completely into the cell and also the properties are selected correctly. What can I do?

    In addition, when I hide a column, or use Auto filter, I can't copy/paste into multiple selected cells, as whatever I am pasting also pastes into the hidden cells which I don't want. Has anybody encountered this?

    I have heard there is a "hot-fix" for the same problem with office for the pc, but I wasn't able to find something similar for office mac 2008
     
  2. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #2
    I don't think the graphic is anchored to the cell/row, and therefore will not "move" with a sort. I think that is also true for XL Win 2000/2002/2003 and Mac 2001/2004. I have never used 2007/2008, so cannot say about those.

    That has been the characteristic of pasting in every version of Excel I used (Win: 97, 2000, 2002, 2003 and Mac: 98, 2001, 2004).
     
  3. Dinaall thread starter macrumors newbie

    Joined:
    Jul 16, 2009
    #3
    I had neither problem with my old Excel Mac 2004. Sadly I need the newly increased number of columns and therefore need to work with the 2008 version.
     
  4. glap1922 macrumors regular

    Joined:
    Mar 13, 2009
    #4
    I'm fairly certain this is how Excel is meant to work. I use excel often at work and this is a feature that I use often. I do not believe there is any way to make the paste skip those hidden areas.
     

Share This Page