tables
 

i have created a table in excel but want the edges of table to be slightly
curved instead of being a right angle....is there a way of doing it?
--
Sam

tables
 

Not sure what you meant by "table." How did you draw/create the table?

Have you checked out AutoShapes from the drawing toolbar? AutoshapesBasic shapesfirst one second row is a rounded rectangle. Draw the rectangle then right-click ...... Format AutoShapeColors and Lines tabFill - color - no fill or transparency 99%. Grid lines optional.

Is this what you want?

Epinn

"Sam" wrote in message ...
i have created a table in excel but want the edges of table to be slightly
curved instead of being a right angle....is there a way of doing it?
--
Sam

tables
 

Do you mean you want a border around the range?

And this border to have rounded corners?

From Drawing Toolbar select rounded rectangle from Basic Shapes.

Place it over your range and set its properties to Transparent.

Or use this macro after selecting the range of cells.

Sub RoundRectangle()
Dim x, y As Single, area As Range
For Each area In Selection.Areas
With area
x = .Height * 0#
y = .Width * 0#
ActiveSheet.Rectangles.Add Top:=.Top - x, Left:=.Left - y, _
Height:=.Height + 1 * x, Width:=.Width + 1 * y
End With
With ActiveSheet.Rectangles(ActiveSheet.Rectangles.Coun t)
.Interior.ColorIndex = xlNone
.ShapeRange.AutoShapeType = msoShapeRoundedRectangle
End With
Next area
End Sub


Gord Dibben MS Excel MVP

On Sun, 14 Jan 2007 00:36:00 -0800, Sam wrote:

i have created a table in excel but want the edges of table to be slightly
curved instead of being a right angle....is there a way of doing it?