
- 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 - Add Cells
The Microsoft Excel tool can seamlessly add, delete, or move cells in the workbook. We can swiftly add new columns or rows in Microsoft Excel by right-clicking on the specific cell and choosing the Insert option from the drop-down menu to add a column or row to the worksheet.
How to Add Cells in Microsoft Excel?
There are four ways to add cells to the worksheet −
- Shift Cells Right − Moves the selected cells to the right and adds a new cell at that specific location.
- Shift Cells Down − Moves the selected cells downwards and adds a new cell to that specific location.
- Entire Row − You may insert an entire row by clicking on this option to add new cells in that row.
- Entire Column − You may utilize this option to insert the new column to add new cells in that column.
Lets elaborate one by one −
Shift Cells Right
The "Shift cells right" option allows you to move the cells adjacent to the right cell.
For example
Consider the sample worksheet consisting of three columns: Executive Names, Sales Target, and Date of Joining.

You can right-click on the B8 cell and select the "Insert" option from the drop-down list.

Select the "Shift cells right" option from the list in the Insert dialog box and click the OK button.

Hence, a new cell has been added to the B8 cell, and the previous B8 cell is being shifted to the right.

Shift Cells Down
You can also shift the new cells downwards and add a new cell in the targeted cells.
Lets say you wish to add a new cell to the B5 cell. Right-click on the B5 cell and select the Insert option from the drop-down list.

Afterward, you can select the "Shift cells down" and click the OK button.

The Excel add a new cell in the B5, as shown below:

Entire Row
Let's say you wish to insert the row between the 3 and 4 rows to add a cell where new executive information would be added. Select the B4 cell, right-click on that cell, and select the Insert option from the drop-down menu.

Once you click on Insert, another dialog box, "Insert," will open. In this box, you can select the "Entire row" option. Then click on the OK button.

Therefore, multiple cells were added to the new row in Microsoft Excel.

Entire Column
Microsoft Excel may add cells in a new column to a specific worksheet. To do so, select the C header and choose the "Insert" option from the drop-down menu.

Therefore, a new column is added between the C and D columns, and the previous column, C, will be shifted to the right.
Now, you can add new data in the C columns cells.
