tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Not sure what you meant by "table." How did you draw/create the table?

Have you checked out AutoShapes from the drawing toolbar? Autoshapes>Basic shapes>first one second row is a rounded rectangle. Draw the rectangle then right-click ...... Format AutoShape>Colors and Lines tab>Fill - color - no fill or transparency 99%. Grid lines optional.

Is this what you want?

Epinn

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?
 
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.Count)
.Interior.ColorIndex = xlNone
.ShapeRange.AutoShapeType = msoShapeRoundedRectangle
End With
Next area
End Sub


Gord Dibben MS Excel MVP
 
Back
Top