- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
Inserting and Deleting Columns
You can insert extra columns into a worksheet to make room for more data or formulas. Adding more columns, which gives the appearance of adding space between columns, can also make the worksheet easier to read. Alternatively, you might want to delete columns from a worksheet to close up some empty space or remove unwanted information.
Right-click on the column letter of the existing column where you want to insert a new column.
Click the Insert option. Excel automatically adds a new column.
To delete a column, right-click on the column number of the existing column that you want deleted.
Click the Delete option. Excel automatically removes the specified column.