Microsoft Office Tutorials and References
In Depth Information
Controlling How Graphic Objects Overlap
to open the Save Current Theme dialog box. Edit the generic Theme1 filename
in the File Name text box (without deleting the .thmx filename extension) and
then click the Save button. Excel then adds the custom theme to a Custom
Themes section in the Themes drop-down gallery and you can apply it to any
active worksheet by simply clicking its thumbnail.
Controlling How Graphic Objects Overlap
In case you haven’t noticed, graphic objects float on top of the cells of the
worksheet. Most of the objects (including charts) are opaque, meaning that
they hide ( without replacing) information in the cells beneath. If you move
one opaque graphic so that it overlaps part of another, the one on top hides
the one below, just as putting one sheet of paper partially on top of another
hides some of the information on the one below. Most of the time, you should
make sure that graphic objects don’t overlap one another or overlap cells
with worksheet information that you want to display.
Reordering the layering of graphic objects
When graphic objects (including charts, text boxes, inserted clip art and
pictures, drawn shapes, and SmartArt graphics) overlap each other, you can
change how they overlay each other by sending the objects back or forward
so that they reside on different (invisible) layers.
Excel 2013 enables you to move a selected graphic object to a new layer in
one of two ways:
To move the selected object up toward or to the top layer, select the
Bring Forward or Bring to Front option on the Bring Forward button’s
drop-down menu in the Arrange group on object’s Drawing, Pictures,
or SmartArt Tools contextual tab. To move the selected object down
toward or to the bottom layer, select the Send Backward or Send to Back
option on the Send Backward button’s drop-down menu in the Arrange
group on object’s Drawing, Pictures, or SmartArt Tools contextual tab.
Click the Selection Pane command button in the Arrange group on
the Format tab under the Drawing Tools, Pictures Tools, or SmartArt
Tools contextual tab to display the Selection task pane. Then, click the
Bring Forward button (with the triangle pointing up) or Send Backward
button (with the triangle pointing down) at the top of the task pane
to the immediate right of the Show All and Hide All buttons. You click
the Bring Forward or Send Backward button until the selected graphic
Search JabSto ::




Custom Search