ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insdert an object within a cell in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/232979-insdert-object-within-cell-excel-2007-a.html)

Learner

Insdert an object within a cell in Excel 2007
 
In Excel 2007, can I insert a picture or an object within a cell so that it
becomes part of a cell? Therefore when I insert a row or move the cell, the
object will move as part of the cell.

Dave Peterson

Insdert an object within a cell in Excel 2007
 
Nope.

But you can insert an object that can hover over the cell. (Make sure it fits
within the cell's border to make your life easier.)

And for some (all???) objects, you can:
rightclick on the object
Choose: Format (object)
And on the Properties tab, you'll find a bunch of options to "move and size with
cells" or "move but don't size with cells", or "don't move or size with cells".

Not all objects support all those possibilities, though.

The real problem I've had is when I didn't put the object completely within the
borders of a cell/row/column. Then when I did sorts, I messed things up.


Learner wrote:

In Excel 2007, can I insert a picture or an object within a cell so that it
becomes part of a cell? Therefore when I insert a row or move the cell, the
object will move as part of the cell.


--

Dave Peterson

Shane Devenshire[_2_]

Insdert an object within a cell in Excel 2007
 
Hi,

You can't make an object part of the cell but you can right click the
picture and choose Size and Properties, Properties, Move and size with cells.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Learner" wrote:

In Excel 2007, can I insert a picture or an object within a cell so that it
becomes part of a cell? Therefore when I insert a row or move the cell, the
object will move as part of the cell.



All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com