Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2007

Tip: Looking for answers? Try searching our database.

tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sam - 14 Jan 2007 08:36 GMT
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?
Signature

Sam

Epinn - 14 Jan 2007 09:14 GMT
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?
Signature

Sam

Gord Dibben - 14 Jan 2007 17:32 GMT
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

>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?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.