How to use shapes in Excel
Cell borders are the reason most dashboards look like spreadsheets. Shapes (rounded rectangles, cards, dividers) are how you design on top of the grid instead of inside it.
Updated September 30, 2026.
Use shapes for the presentation layer (panels, cards, dividers, backgrounds) and use cell fills for tables that stay visible in the grid, because shapes float on their own layer, take rounded corners and soft fills, and can be set not to move or resize when the rows and columns beneath them change.
Design on a layer, not in the grid
A cell border can only be a straight line locked to the grid. It re-draws every time you insert a row, it can't have rounded corners, and stacking borders to fake a panel is fragile. A shape sits on a separate drawing layer above the cells, so it can be any size, take a soft corner radius, carry a subtle fill, and can hold its position when you select Don’t move or size with cells in its properties.
That single difference is most of what separates a designed dashboard from a default one. The polished look you see in good dashboard examples is usually rounded-rectangle panels sitting behind the numbers, not clever formulas. It's the core move in making Excel look less like Excel.
How to use shapes well
Build panels, not borders
Insert a rounded rectangle, drag the yellow handle down to a subtle 6-10 px radius, give it a fill one shade off the background, and remove the outline. That's a card. Send it behind linked text boxes and charts; it cannot sit behind worksheet cell values.
Snap to the cell grid
Hold Alt while drawing or resizing so shapes lock to cell edges. Now your panels share the same underlying columns as your data and your layout grid stays honest.
Align and distribute
Never eyeball it. Select the shapes, open Shape Format, and use Align plus Distribute so every gutter between panels is identical. Even spacing is what reads as "designed."
Layer deliberately
Put panel shapes behind linked text boxes, charts, and other drawing objects. Send to Back controls that stack; it does not put a shape behind cell values. Use cell fills for tables that stay in the grid.
Use fills to group and highlight
A subtle panel works well behind supporting detail. A brighter fill can draw attention to a result or distinguish a section. Choose colors that fit the audience and keep the text readable on top.
Group and reuse
Build one card perfectly (panel, label, value), then group it and copy it across. Identical dimensions everywhere beats six panels that are each slightly different.
Beyond the card
The same layer is where the rest of your structure lives. Thin rectangles make dividers between sections - cleaner than a bottom border and free to span any width. A large rounded rectangle behind a whole zone acts as a background that groups several cards into one visual region. Small shapes carry icons and labels that you can position pixel-perfectly instead of wrestling into a merged cell. And a shape's text can be linked to a cell with =, so a designed card still updates with your data. Photographs and illustrations live on that same layer, which is what the imagery and illustration template is built around.
One discipline holds it all together: pick a corner radius, a fill, and a gutter once, then use the exact same values everywhere. Consistency across shapes is what makes a sheet feel like a single designed system rather than a pile of decorations. I took that to a silly extreme once and built a whole tarot deck out of copied cards.
What ruins a shape-built sheet
Related techniques
Use Excel like PowerPoint
Turn shapes, charts, icons, and text into one manageable presentation layer.
Learn the layer model →Link a cell to a text box
Put live KPI values into movable shapes, including the PivotTable error fix.
Link dynamic text →Excel KPI card design
Turn a shape panel into a clean metric card with a value, label, and delta.
Build a card →Excel dashboard layout
Put your panels on a real grid with margins, columns, and whitespace.
Lay it out →Excel dashboard color palette
Choose panel fills, highlights, and consistent category colors.
Pick colors →Excel Dashboard Toolkit
Take apart shape-built dashboards, chart styles, source tables, and reusable report elements.
See the working files →Shapes in Excel, answered
Why use shapes instead of cell borders in Excel?
Cell borders are locked to the grid, can only be straight lines, and re-draw every time rows or columns change. Shapes float on a separate layer, so you get rounded corners, soft fills, even spacing, and panels whose position can be controlled independently of the cell grid. For a designed look, shapes give you control that borders cannot. More on this →
How do I align shapes perfectly in Excel?
Select the shapes, open Shape Format, and use the Align tools to align edges or centers, then Distribute Horizontally or Vertically to make the gaps identical. Holding Alt while you draw or resize snaps a shape to the cell grid, which keeps everything on the same underlying columns.
How do I put a shape behind my data?
You cannot put a filled shape behind worksheet cells. Send to Back only changes the order of objects on the drawing layer, which sits above the cells. Put linked text boxes and charts above the shape to display live data, or use cell fills when you need the values to remain directly visible in the grid. For a fixed layout, select Don’t move or size with cells in the shape properties. See Microsoft’s explanation of the drawing layer.
Should I add shadows to shapes in Excel?
Use them sparingly. The default Excel shadow is heavy and dated. If you want depth, apply a soft custom shadow at low opacity, a few pixels of blur, and a small offset - or skip shadows entirely and separate panels with whitespace and a one-shade fill difference instead.
Do shapes slow down an Excel file?
Shapes add objects for Excel to draw and manage. The impact depends on the number of objects, their effects, the workbook, and the device. Delete stray shapes and test scrolling, filtering, and opening the finished file on the hardware your audience uses.