O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Positioning Graphical Objects Relative to Cells

As you've seen earlier in this chapter, you can drag a graphical object to wherever in the worksheet you need it to appear. But you can also connect the graphical object to the cells over which it appears, so that when you move the cells, the object moves too. This setting is handy when you need to keep the graphical object with particular cells. You can also have Excel resize the object when you resize the cells.

To control whether a graphical object moves and changes size with cells, follow these steps:

  1. Ctrl+click or right-click the graphical object, and then click the Properties command on the context menu to display the Format dialog box. For example, Ctrl+click or right-click a picture, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required