XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Adding Round Corners to Excel"

Line 1: Line 1:
 
Version 7.1 introduces the ability to easily create rounded corners.
 
Version 7.1 introduces the ability to easily create rounded corners.
  
= Adding Round Corners
+
== Adding Round Corners ==
  
[File:Round1.png]
+
[Image:Round1.png]
  
 
Highlight the required area:
 
Highlight the required area:
  
[File:Round2.png]
+
[Image:Round2.png]
  
 
Go to Extras -> Add/Edit Round Corners:
 
Go to Extras -> Add/Edit Round Corners:
  
[File:Round3.png]
+
[Image:Round3.png]
  
 
The Colours and Border thickness will be picked up from the selected cells. Select the corners to be made round (in this case the Top Left and Top Right corners):
 
The Colours and Border thickness will be picked up from the selected cells. Select the corners to be made round (in this case the Top Left and Top Right corners):
  
[File:Round4.png]
+
[Image:Round4.png]
  
 
Click OK to apply the borders
 
Click OK to apply the borders
  
[File:Round5.png]
+
[Image:Round5.png]
  
= Editing Existing Corners
+
== Editing Existing Corners ==
  
 
If the cell has manually created corners then they will need to be deleted before adding new corners using XLCubed, if the corners were created by XLCubed then you can just highlight the cell or range and Go to Extras -> Add/Edit Round Corners. The changes will be applied to the existing corners (or the corners can be removed by unselecting them)
 
If the cell has manually created corners then they will need to be deleted before adding new corners using XLCubed, if the corners were created by XLCubed then you can just highlight the cell or range and Go to Extras -> Add/Edit Round Corners. The changes will be applied to the existing corners (or the corners can be removed by unselecting them)
  
= Resizing Columns/Rows
+
== Resizing Columns/Rows ==
  
 
If the Column or Row is re-sized then the corners may now be in the wrong place, to fix this go to Extras -> Add/Edit Round Corners and then click OK. Any existing round corners will be moved to the correct location.
 
If the Column or Row is re-sized then the corners may now be in the wrong place, to fix this go to Extras -> Add/Edit Round Corners and then click OK. Any existing round corners will be moved to the correct location.

Revision as of 10:35, 21 August 2012

Version 7.1 introduces the ability to easily create rounded corners.

Adding Round Corners

[Image:Round1.png]

Highlight the required area:

[Image:Round2.png]

Go to Extras -> Add/Edit Round Corners:

[Image:Round3.png]

The Colours and Border thickness will be picked up from the selected cells. Select the corners to be made round (in this case the Top Left and Top Right corners):

[Image:Round4.png]

Click OK to apply the borders

[Image:Round5.png]

Editing Existing Corners

If the cell has manually created corners then they will need to be deleted before adding new corners using XLCubed, if the corners were created by XLCubed then you can just highlight the cell or range and Go to Extras -> Add/Edit Round Corners. The changes will be applied to the existing corners (or the corners can be removed by unselecting them)

Resizing Columns/Rows

If the Column or Row is re-sized then the corners may now be in the wrong place, to fix this go to Extras -> Add/Edit Round Corners and then click OK. Any existing round corners will be moved to the correct location.