Microsoft Excel Tutorial - how to draw a semi-circle in Excel.
The Insert Shapes drop-down menu in Excel offers an oval, but not a semi-circle. How can you draw a semi-circle? Most of those shapes include a yellow handle for changing the inflection point. You can use this handle to make the partial circle into a half-circle or quarter circle.
Download the workbook from today:
www.mrexcel.com/youtube/U2gvZtUW0vk/ This short video shows you how.
Welcome to my
#shorts video on how to draw a semicircle in Excel! In this quick tutorial, I'll show you how to create a semicircle shape using the insert shapes feature in Excel.
First, go to the insert tab and select shapes. You'll notice that there isn't a semicircle option, but don't worry, we can easily modify one of the existing shapes to create a semicircle.
Next, draw a partial circle by holding down the shift key while you draw. Then, look for the yellow handle on the shape and drag it to the edge of the cell border. This will serve as a guide for creating a perfect semicircle.
Once you have the shape in place, use the rotation angle to adjust the orientation of the semicircle. This will allow you to position it exactly how you want it.
If you found this tutorial helpful, please consider giving it a thumbs up and subscribing to my channel for more Excel tips and tricks. And don't forget to hit the bell icon to be notified of new videos. I love hearing from my viewers, so feel free to leave any questions or comments down below. Thanks for watching!
Buy Bill Jelen's latest Excel book:
www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below:
www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents
(
0:00) Draw a semi-circle in Excel
(
0:15) Yellow handle
(
0:27) Rotation handle
This video answers these common search terms:
How to draw a semi-circle in Excel
How to draw a half circle in Excel
How to draw a quarter circle in Excel
Join the MrExcel Message Board discussion about this video at
www.mrexcel.com/board/threads/1237796/
@tahirshah6979
1 year ago
How easy...
1 |