When you add multiple shapes, text boxes, or images to an Excel worksheet, they automatically stack on top of each other. This can hide important elements behind larger objects. The stacking order, or z-order, determines which shape appears in front.
Excel provides specific commands to control this layer arrangement. You can bring a shape to the very front or send it to the very back of the stack.
This article explains how to use the Send to Front and Send to Back features. You will learn to rearrange any object on your sheet.
Key Takeaways: Reordering Shapes in Excel
- Format Shape pane > Size & Properties > Properties > Move with cells: Controls whether a shape stays in a fixed position or moves when you insert rows or columns.
- Right-click shape > Bring to Front or Send to Back: The fastest method to change a single object’s layer by one level forward or backward.
- Drawing Tools Format tab > Arrange group: Provides full control over stacking order, including Bring Forward, Send Backward, and selection pane access.
Understanding Shape Layers and the Selection Pane
Every object you insert into Excel exists on its own transparent layer. Newer objects are placed on top of older ones, creating a stack. The order of this stack is not random; it follows the sequence of insertion. This system is called the z-order.
The main tools for managing this are in the Drawing Tools Format tab, which appears when you select a shape. For more complex sheets with many overlapping items, the Selection Pane is essential. It lists all objects on the current sheet and allows you to hide them or reorder them by dragging.
Why Stack Order Matters
Correct layering is key for professional-looking dashboards and diagrams. A shape meant to be a background should be at the very back. Callout arrows or highlight boxes need to be in front of the data they reference. Without proper ordering, your design will look cluttered and confuse the viewer.
Steps to Reorder Shapes Using the Ribbon
The most complete set of ordering commands is on the ribbon. This method gives you precise control for any arrangement task.
- Select the target shape
Click once on the shape, text box, or picture you want to move in the stack. Selection handles will appear around it. - Navigate to the Format tab
Go to the Drawing Tools Format tab on the ribbon. If you selected a chart or picture, the tab name will be Chart Tools Format or Picture Tools Format. - Open the Arrange menu
In the Arrange group, click the Bring Forward or Send Backward button. Each click moves the shape one layer in that direction. - Use the full commands
Click the small arrow next to the Bring Forward button. Select Bring to Front to move the shape above all others. Click the arrow next to Send Backward and choose Send to Back to move it behind all other objects.
Using the Right-Click Context Menu for Quick Changes
For faster adjustments, you can use the menu that appears when you right-click a shape. This method is best for simple forward or backward moves.
- Right-click the shape
Position your cursor over the shape and right-click. A context menu will pop up. - Choose the order command
Hover your mouse over the Bring to Front or Send to Back option in the menu. A submenu will appear. - Select the action
Click Bring to Front to move the shape to the top layer. Click Send to Back to move it to the bottom layer. Click Bring Forward or Send Backward to move it just one level.
Managing Complex Layouts with the Selection Pane
When you have many overlapping objects, the Selection Pane is the best tool. It provides a list view of all items, making it easy to select and reorder them, even if they are hidden.
- Open the Selection Pane
Go to the Drawing Tools Format tab. In the Arrange group, click Selection Pane. A pane will open on the right side of the Excel window. - View the object list
The pane lists every shape, text box, and picture on the active sheet. Objects at the top of the list are in front of objects at the bottom. - Reorder by dragging
Click and hold an item’s name in the list. Drag it up to bring it forward or drag it down to send it backward. Release the mouse button to set the new order. - Hide or show objects
Click the eye icon next to an object’s name to hide it temporarily. This helps you select shapes that are buried underneath others.
Common Mistakes and Limitations to Avoid
Shapes Not Moving with Cells
If your shapes stay in a fixed position when you insert rows, check their properties. Right-click the shape, select Format Shape. In the pane, go to Size & Properties > Properties. Choose the Move and size with cells option.
Cannot Select a Shape Behind Another
When shapes completely overlap, clicking may only select the top one. Use the Selection Pane to click the name of the hidden shape directly. You can also press the Tab key to cycle through all selectable objects on the sheet.
Order Commands Are Grayed Out
This usually means no object is selected. Click on a shape first. If the commands remain unavailable, the selected item might be a cell or part of the sheet background, which cannot be layered.
Bring to Front vs Send to Back: Key Differences
| Item | Bring to Front / Bring Forward | Send to Back / Send Backward |
|---|---|---|
| Primary Action | Moves object closer to the viewer | Moves object away from the viewer |
| Keyboard Shortcut | Alt, H, FR, F (for Bring to Front) | Alt, H, FR, K (for Send to Back) |
| Effect on Stack | Object moves above others in the z-order | Object moves below others in the z-order |
| Best For | Highlighting key elements like arrows or icons | Placing background images or shaded areas |
| Selection Pane Action | Drag object name upward in the list | Drag object name downward in the list |
You can now control the layer of any shape, text box, or image in your Excel workbook. Use the Selection Pane to manage complex sheets with many objects. For advanced control, remember the keyboard shortcuts Alt, H, FR, F and Alt, H, FR, K to quickly reorder without the mouse. Try grouping related shapes after you set their order to move them as a single unit.