word-excel-access-help.com logo
Excel Worksheets
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Additional Resources




Excel Worksheets: Columns | Microsoft Excel XP

Microsoft Excel XP logo
Learn how to work with cells, rows and columns on your Excel worksheets. Learn step-by-step how to insert or delete cells, rows or columns.

Excel Office Helper 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.
   
  Excel Worksheets: Column Heading example
   
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.
   
  Excel Worksheets: Column Heading example
   
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
- Print
- 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