Course Content

Course Content

Formatting Shapes in MS Excel

How To Format Shapes in MS Excel

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:

  • Text Box
  • Line
  • Circle
  • Ellipse
  • Triangle
  • Rectangle
  • Star

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

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

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere