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.


Insert shapes in Excel is a practical and easy-to-use tool for performing a wide range of common mathematical and geometric operations with shapes. With Insert Shape tool, you can add a shape from the Illustrations group from the Insert tab in the Illustrations group. The shape's cursor changes to a plus sign which lets you drag it to the worksheet where you want to place it.

You can format a shape in MS Excel by moving and resizing your selected shape. There are different ways to format a shape in Excel: - Change the color of the cell: Format cells with the Fill & Line options. - Change the border of a cell: Format cells with borders and shading options. - Add text to a cell: Format cells with text and alignment settings. There are two main types of formatting: - Grid: This is a multi-column table with rows and columns that can be resized by dragging the column borders or clicking on the column header. - Number: This is an easy way to add labels, text, or numbers above, below, beside, or between cells. The tools provided by Microsoft help in achieving many tasks such as adding borders, adjusting text size, and placing data points in different positions or at different angles depending on the requirements of the user.

Conditional formatting is a formatting technique that can change the appearance of data by applying unique types of formatting to it. This is a great tool for helping you organize your work. To use conditional formatting on shapes in Excel 2016, click on any cell in the spreadsheet, select the Home tab, and locate conditional formatting. Using conditional formatting, you can assign certain styles to specific types of data. For now, let's consider the most popular example - shape styles. If you highlight a number or date then apply conditional formatting to it, Excel will automatically format that number or date as an arrow with no border and fill it with color based on its condition

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
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ 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