"Organize Data Smartly: Insert, Delete and Format Rows/Columns in Excel"
Columns run vertically and are identified with letters (A, B, C), whereas rows run horizontally and are numbered (1, 2, 3, etc.). Every cell in your worksheet, such A1 or B5, combines a row and a column. Adding rows or columns to your worksheet makes it easier to manage, organize, and analyze data.
How to Add a Row and column to Excel
There are some different types to Insert raw and column
Insert with a right-click.
To access the context menu, right-click the chosen row number. Click "Insert." As per below image.
After Choose “Insert”. The new tab appears as per below image: You can use different features to insert cell, Row or column.
Using the Ribbon
Alternatively, select a row or column, then go to the “Home” tab, find the “Cells” group, and click “Insert”. Select “Insert Sheet Rows or Insert Sheet Columns” from the dropdown.
Keyboard Shortcut
Rows: Select the row, then press Ctrl + Shift + + (plus). This also adds a new row above the selection.
Column: Select the column, then press Ctrl + Shift + +. This will insert a column to the left.
Insert Multiple Rows
Select as many existing rows as you want to insert, right-click, and choose “Insert”. For example, highlight three rows, right-click, and select “Insert” to get three new blank rows at once.
Insert Multiple Columns
Select several columns at once, right-click, and choose “Insert” to add that number of new columns at once. For example, selecting three columns and inserting will place three new columns to the left of your selection.
Deleting Rows and Columns
Clean up unnecessary data easily!
Delete a Row
- Select the row
- Right-click → Delete
Delete a Column
- Select the column
- Right-click → Delete