There are a variety of shapes you can create in MS Excel. Some of the most common shapes are:
Text Box
Line
Circle
Ellipse
Triangle
Rectangle
Star
Formatting shapes in MS Excel is a way to add some visual interest to your data. It can also help you organize your data in a way that is more meaningful to you. You can format your shapes by changing their color, border, fill pattern and line style.
There are many tools available in MS Excel that can be used to create shapes. These tools are the following:
Insert Shapes:
Drawing Tools:
Shape Tools:
Formatting Shapes:
Add Text to a Shape
Click the More drop-down arrow in the Shape Styles group on the Format tab. A style drop-down menu will appear. Choose the style you'd want to utilise. The specified style will be applied to the shape.
To format shapes in MS Excel, use the following keyboard shortcuts:
Ctrl+1: Change shape to a rectangle
Ctrl+2: Change shape to a square
Ctrl+3: Change shape to a diamond
Ctrl+4: Change shape to a triangle
Ctrl+5: Change shape to an arrowhead pointing up
Ctrl+6: Change shape to an arrowhead pointing down
Ctrl+7: Change shape to an arrowhead pointing left
Ctrl+8: Change shape to an arrowhead pointing right
Learner's Ratings
4.6
Overall Rating
81%
11%
6%
2%
0%
Reviews
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.