
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Merge Workbooks
- Excel - File Password
- Excel - File Share
- Excel - Emoji & Symbols
- Excel - Context Help
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Shapes
- Excel - 3D Models
- Excel - CheckBox
- Excel - Add Sketch
- Excel - Scan Documents
- Excel - Auto Fill
- Excel - SmartArt
- Excel - Insert WordArt
- Excel - Undo Changes
- Formatting Cells
- Excel - Setting Cell Type
- Excel - Move or Copy Cells
- Excel - Add Cells
- Excel - Delete Cells
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting
- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format
- Excel - Highlight Cell Rules
- Excel - Top/Bottom Rules
- Excel - Data Bars
- Excel - Color Scales
- Excel - Icon Sets
- Excel - Clear Rules
- Excel - Manage Rules
- Working with Formula
- Excel - Formulas
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Relative References
- Excel - Absolute References
- Excel - Arithmetic Operators
- Excel - Parentheses
- Excel - Using Functions
- Excel - Builtin Functions
- Excel Formatting
- Excel - Formatting
- Excel - Format Painter
- Excel - Format Fonts
- Excel - Format Borders
- Excel - Format Numbers
- Excel - Format Grids
- Excel - Format Settings
- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Sparklines
- Excel - Ads-ins
- Excel - Protection and Security
- Excel - Formula Auditing
- Excel - Remove Duplicates
- Excel - Services
- Excel Useful Resources
- Excel - Keyboard Shortcuts
- Excel - Quick Guide
- Excel - Functions
- Excel - Useful Resources
- Excel - Discussion
Excel - Shapes
Excel Shapes are the basic building blocks for children, adults, and professionals. You can add multiple interactive shapes like squares, rectangles, arrows, and many more to the Excel worksheet, add the text string, and change their styles such as Shape effects, Shape color, and Shape Outline, through the Shape Format tab for a better appearance.
Collection of Shapes in Microsoft Excel
- Line
- Rectangles
- Basic Shapes
- Block Arrows
- Equation Shapes
- Flowchart
- Stars and Banners
- Callouts
Each Excel shapes collection has a separate list. Lines can be a single, double arrow, connector, curve, etc.

Steps to Insert Shapes in Microsoft Excel
First, open a new Microsoft Excel worksheet. After that, select the Insert tab and expand the Illustrations tile.

Furthermore, you can expand the Shapes tile and select the desired shape. Once you choose a particular shape, the mouse pointer transforms into the + sign, and you may drag the + sign and place it in any portion of the worksheet.

Lets suppose you choose the Rectangle from the Shape icon and drag the + sign, and drop it into the specified area of the worksheet as given below:

Add a Text String to a Shape in Microsoft Excel
Various steps need to be taken place to insert a text into a Shape.
You may right-click on the Rectangle and choose the Edit text from the drop-down list.

After that, the text option is enabled, and you can write the text inside the Rectangle.

Format a Shapes in Microsoft Excel
Once you add shapes to the Excel worksheet, you can easily change the default formatting of the inserted excel shapes.
You can select the Shape Format tab, which offers options such as Shape Styles, Shape Fill, Shape Outline, Shape Effects, and WordArt Styles.
Case Scenario − Harry is a beginner in Microsoft Excel, and he has to complete his Excel Shape assignment where he has to add the rectangle in the Microsoft Excel and change its shape formatting as mentioned below:
- Set the Shape fill to green color.
- Alter the Shape Outline to 3 pt.
- Apply the Shape Effects to Glow and set the Glow Variations to 8 points, Orange, Accent Color 2.
- Edit the Rectangle shape to the Isosceles Triangle shape.
Lets elaborate on each point thoroughly.
Set the Shape Fill to Green Color
In the previous section, rectangle shape has been already added into the Excel worksheet. Now he can select the Rectangle shape.

After that, navigate to the "Shape Format" tab and expand the "Shape Fill" and select the Dark green color from the given list of the Theme Colors.

Alter the Shape Outline Weight to 3 pt
To change the Shape Outline, he can expand the "Shape Outline" and select the "Weight" option and choose the 3 pt from the drop-down list.

Therefore, the Rectangle Shape border has been wider to 3 points.

Apply Glow Shape Effects: 8 Point, Orange, Accent Color 2
He can select "Shape Effects" under the "Shape Format" tab, expand the "Glow" option, and select "Glow, 8 point, Orange Color, Accent Color 2."

Edit the Rectangle Shape to Isosceles Triangle Shape
You may click on the "Edit Shapes" under the "Shape Format" tab and click on the "Change Shape" and select the "Isosceles Triangle" under the "Basic Shapes" section.

Therefore, the Rectangle shape has been edited and transformed into the Isosceles Triangle.

Can Harry Add the Same Shape Like Line shape so Many Times
Yes, he can add the similar shape multiple times. He clicked on the "Illustrations" and then select the "Shape" icon and then right click on the "Line" shape and select the "Lock Drawing Mode".

After that, once you click on any portion in the Excel worksheet, the Line shape would be added. Repeat this process multiple times to add the same shape in the Excel worksheet.
