Excel Worksheets
 |
 |
 |
 |
 |
 |
 |
Additional Resources
Excel Worksheets: Columns | Microsoft Excel XP |
 |
 |
What's on this page... Insert Cells Delete Cells Insert Rows Delete Rows Insert Columns Delete Columns |
Insert Columns
You can also insert an entire column or range of columns, instead of just cells into your Excel worksheets.Remember that a column is inserted to the left your selection.
To insert columns, follow these steps:
| 1. | Select a column by clicking on the Column Heading from whom you want to insert a column to the left of. |
 |
|
| 2. | With the mouse pointer still in the selected column, right-click and choose Insert from the shortcut menu. |
| OR | |
| Choose Insert ► Columns from the menu bar. | |
| You'll notice that an empty column is inserted to the left of the selected column. |
You can insert as many columns that you want at a time simply by selecting more than one column.
Delete Columns
You could have inserted too many columns into your Excel worksheet, now you can delete these columns just as easily.To delete columns, follow these steps:
| 1. | Select a column by clicking on the Column Heading that you want to delete. |
|
|
|
| 2. | With the mouse pointer still in the selected column, right-click and choose Delete from the shortcut menu. |
| OR | |
| Choose Edit ► Delete from the menu bar. |
| Back to Top |
| Return to Excel XP from Excel Worksheets : Column |
Excel XP Topics
- Tips- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter