Move images along with cells, similar to Word

  • Thread starter Thread starter phillr
  • Start date Start date
P

phillr

Hello, in Microsoft Word, when you put in an image, you can set it to move
along with the text content (text moves down 3 lines, so does image). You can
also set it so that the image never gets cut off, it'll automatically bump to
a new page to stay intact across one sheet.

I'd like to have similar behaviour in Excel if at all possible. I'm using
Excel 2002 :S.
 
phillr said:
Hello, in Microsoft Word, when you put in an image, you can set it to move
along with the text content (text moves down 3 lines, so does image). You can
also set it so that the image never gets cut off, it'll automatically bump to
a new page to stay intact across one sheet.

I'd like to have similar behaviour in Excel if at all possible. I'm using
Excel 2002 :S.
Click to expand...

You can't really anchor an image to a paragraph in Excel - do you anticipate
inserting many cells into your spreadsheet?

You can format the image though (right-click on the picture and choose
format).
On the Properties tab ensure that the "Move but don't resize with cell"
Option button is selected.

You can insert manual page breaks (Insert menu) but if you later insert rows
you may have to delete them again.

Excel does not have the same formatting features as Word and you you might
like to think about inserting Excel within a Word Document. This can be
Linked or embeded.

If I remember correctly, when you click on an embedded spreadsheet the menu
changes to the Excel and all the function are available.

Hope this helps.

Peter Atherton
 
Back
Top