Now we'll see that how we can format shapes in MS Excel.
If we want to insert anything then we have INSERT tab in menu bar, which
can be viewed differently according to everyone's screen resolution, but in
that tab we can see a particular option for shapes. When we click that we
can see different types of shapes such as basic shapes, block arrows,
equation shapes, flowchart etc...
Now suppose if you want to insert and rectangle, so we select the rectangle
option from Shapes column, and as soon as we select any option we can see
that our mouse pointer has been changed to '+' like sign, which is when
dragged will give our selected shape.
After inserting the required shape, we can also change the style of that
shape. Additionally we can also write something in our shape, and then
align it as per our requirement from home tab.
Similarly in INSERT tab we have an another option which is known as 'SMART
ART'. It is used to insert any organizational flow chart or hierarchical
chart. As soon as we select our preferred art according to our requirement
we can see that it will be displayed on our screen and on their left side
there will be a small dot which is used to write data in chart.
Suppose if you want to add another shape linked with the shape which we
used we can do that by right clicking on our main shape and selecting our
required option from 'Add shape' option.
Similarly we can add any kind of picture by using insert tab in MS Excel.
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 a variety of shapes you can create in MS Excel. Some of the most common shapes are:
There are many tools available in MS Excel that can be used to create shapes. These tools are the following:
Add Text to a 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
Thank you very much.
I am satisfied.Teaching system is clear and very easy to understand.
I am happy this caurse
I am very happy, Free cuorse big opportunity.
Yes i am so glad to tell it is the best ever platform where i learn many of the features in ms excel and also sir who given a practical knowledge and the way sir explaining is good one thank you learn vern.
The course is very informative but questions asked in quiz section is totally different from what is taught in the video lectures. Please teach those things also which are asked in quiz.
VRUSHALI AJAYRAO GURAD
Diwakar Singh Chauhan
nice teaching language and easy to understand.
I have completed my excel course and my other 3 courses are in process. This is greate plate form to learn any course the teachers are well trained and qualified. Thank you and love you all from PAK.