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
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR
I'm very lucky because I have this app. I learned a lot from this app and will keep learning.
Thank you so much LearnVern.
best app for learning
This is very useful app by all courses in this app and thanks for learnvern