Inserting Rows And Columns In Microsoft Excel 2007
When creating Microsoft Excel 2007 spreadsheets, it is impossible to get it right first time. We almost always have a need to chop and change our original information and adding cells is one of the most frequent requirements. There are two ways of inserting cells into a worksheet: you can either insert entire rows or columns or you can insert individual cells. When inserting entire rows or columns, the number of rows or columns that you highlight will correspond to the number inserted.
For example, if we need to insert a header at the top of a worksheet we might want to insert two blank rows. To do this, we would select the first two rows of the worksheet. To select an entire row, click and drag across the appropriate numbers of the rows. Having highlighted the rows above which you want the new cells to be inserted, you can do one of two things. In the Home Tab of the Excel ribbon, you can move across to the Cells section and choose Insert and then Insert Sheet Rows. The alternative is to right click on the row number of one of the highlighted rows and choose Insert from the context menu.
When inserting new rows or columns, it may seem logical that the format of the newly inserted cells will correspond to the cells that were highlighted when the new row or column is inserted. However, in fact, the format is copied from the cells above, in the case of rows, and the cells to the left, in the case of columns.
The right-click method of inserting rows or columns is normally faster however the other method has one benefit: you don’t have to highlight the number of rows or columns you wish to insert. Even if you have a single cell highlighted, you can still use the insert button and choose Insert Sheet Columns or Insert Sheet Rows.
Yet another way of inserting cells is to right-click on a cell and to choose Insert. To insert an entire column or row, simply select the appropriate option from the dialog box which appears then click OK.
Naturally, all of the above techniques apply equally well to deleting rows or columns. For example, let’s say we have three cells selected going across three columns; we can move across to the Cells section of the Home Tab of the Excel ribbon, click on the Delete button and choose Delete Sheet Columns. This command deletes not just the selected cells but the entire columns that they form part of. Similarly, to use the right-click method, we would right-click on the row or column label and choose Delete from the context menu.
The author is a trainer and developer with Macresource Computer Solutions, an independent computer training company offering Excel Classes in London and throughout the UK.
Find useful experiences to free website traffic – your personal knowledge base.
Popularity: 3%
Related posts:
- Using The Freeze Panes Command In Microsoft Excel Many of the worksheets that are created in Microsoft Excel...
- Using Hidden Sheets In Excel 2007 A Microsoft Excel workbook is actually a container, a bit...
- Adjusting Column Widths In Excel Spreadsheets Microsoft Excel 2007 offers a number of different ways of...
- MS Excel VBA 2007 Ribbon Tabs The Microsoft Excel VBA 2007 Ribbon is the most important...
- Microsoft Excel 2007 Navigation Techniques Each Excel document is called a workbook and each workbook...
Related posts brought to you by Yet Another Related Posts Plugin.
useful tips, thanks!