MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Using outline in excel

  Asked By: Kiswar    Date: Sep 30    Category: MS Office    Views: 1258

It is nice to have outline capability in Excel so that we can just
display level 1 and hide all level 2+. But this works for text only--
if I have a photo (inside a frame) stored in a cell which is in
level 2+; if I display level 1, all level 2+ would be hidden except
that photo. In this case, the photo may very likely overlay level 1's
text. That's not what I had in mind, how could I slove this?



5 Answers Found

Answer #1    Answered By: Abaddon Cohen     Answered On: Sep 30

It works  for me, as long as I set the picture properties to "Move and
Size with Cell".

Answer #2    Answered By: Jacqueline Long     Answered On: Sep 30

I usually do COPY in a graphic application like MSPaint or Photoshop
and then in Excel I select a cell, say C5, then I do PASTE to bring
the photo  into Excel. Now, I do not know how to set "Move and Size
with Cell" after that.

Answer #3    Answered By: Joe Evans     Answered On: Sep 30

After you've pasted the picture, do a right click on it. Choose the
"Format Picture" option on the context menu that comes up. Click the
properties tab. Then choose "move and size" with cells.

Answer #4    Answered By: Mable Stone     Answered On: Sep 30

One more question, please. How do you set "move and size" for all cells to be
pasted as the default without having to do it every time you paste a picture?

Answer #5    Answered By: Guillermo Cox     Answered On: Sep 30

If there is a way, I'm not aware of it.

But you can select all the pictures and do it at once, instead of one
at a time...

1. Open up the "Drawing" toolbar
2. Click on the "Select Multiple Objects" icon
3. Click "Select All" and "OK"
4. Do what we did before on one of the selected objects (i.e. left click, ...)

Or you could write a VBA routine to do it. Something like:

For Each oShape In ActiveSheet.Shapes
oShape.Placement = xlMoveAndSize
Next oShape

Didn't find what you were looking for? Find more on Using outline in excel Or get search suggestion and latest updates.