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

    Jul 16, 2009
    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

    Feb 12, 2008
    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

    Jul 16, 2009
    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

    Mar 13, 2009
    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