How to Make Rounded Corners in Excel Tables

Published on
June 14, 2008

Igor Asselbergs was contemplating the value of round corners in design. Is it eye-candy? Or does it add value to the user experience? He comes to the conclusion that rounded corners clearly make a difference.

image

“On the left side, you see one surface divided by a line. On the right side your eye interprets the image as two adjoining boxes.”

The effect can be explained by the Gestalt Law of Continuity. Gestalt is a set of rules based on research into perception psychology, and a very powerful tool for Excel table design. In table design this effect can help us to see the table columns as a unit.

image

Did you ever wonder how to create rounded corners in Excel tables?

The basic idea of rounded corners is putting some shape objects into the corners of the column headers.

How to Make Rounded Corners in Excel

Here are the steps to create rounded corners:

1. To show the Drawing toolbar, click on the “Drawing” icon in the main toolbar

2. Go to Drawing Bar > Auto Shapes> Basic Shapes and insert an arc and a rectangle

image


3. Right-click the shapes and select Format Auto Shapes > Colors and Lines. Give the arc the fill color of your table headers, and the rectangle the fill color White. Set “no line” for the both.

image


4. Right-click the shapes and select Format Auto Shape > Size and assign the arc and the rectangle the size 0.5″x0.5″ and set Lock aspect ratio.\

5. Select the rectangle and move it to cell B2 keeping the ALT key pressed. This ensures that shape snaps to the Excel grid. Do the same for the arc so that it overlaps with the white rectangle.

image


6. Select the arc and the rectangle and select the right-click command group.

7. To get the corner for the left side copy-paste the shape and go to Draw > Rotate / Flip / Flip Horizontally

image


8. Set the Size to 0.18″ if you want rounded corners that have the Excel standard row height

image


9.And put them left and right of your header cell

image


10. Set the Size to to 0.09″ for corners with 50% row height

image


11. If your table headers have a different border or fill color, click the corner twice to select the rectangle arc object in the grouped corner object and format the arc with your fill or border color

image

Gary Crawford
COO, XLCubed
Fluence Technologies

Connect with Fluence

Discover how Fluence can help your organization plan better and close faster with more confidence.