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.

Most Liked Posts
  1. Dinaall, Jul 16, 2009

    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
     
    share
    + Quote Reply
  2. exegete77, Jul 16, 2009

    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).
     
    share
    + Quote Reply
  3. Dinaall, Jul 17, 2009

    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.
     
    share
    + Quote Reply
  4. glap1922, Jul 17, 2009

    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
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page