Add and Delete Columns and Rows in Excel

When creating a spreadsheet, the layout I start with is usually not the layout I finish with. Having planned my spreadsheet, I always think I have a pretty good idea of where things will go. Before long, however, I realize that I didn't make room for this formula or I have left too many blank columns after the data.

So I end up adjusting the layout by adding or removing rows and columns. This isn't difficult as rows and columns can be added or removed in Excel with a single click of the mouse.

Of course you need to take care when making such changes in layout that you don’t remove any of your data at the same time. Data contained in rows or columns that are deleted gets deleted as well.

For all the details, read the series of articles on how to Add and Delete Columns and Rows in Excel.

Related Articles

• Excel 2007 Formatting Tutorial
• Parts of the Excel 2007 Screen
• Parts of the Excel Screen