- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
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.
Tip: Hide Columns instead of Delete Columns
You can always hide your columns instead of deleting them for good. This way, you can always get them back simply by unhiding them. Select the columns you want to hide, right-click, and then select the Hide option. To unhide, select the columns to the left and right of the hidden columns, right-click, and then select the Unhide option.