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

[Dinaall]

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

 

[exegete77]

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?

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.

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

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

 

[Dinaall]

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.

 

[glap1922]

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'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.