Microsoft Office Tutorials and References
In Depth Information
Inserting and deleting
You can also use these techniques to select entire columns or rows and then move or copy
them to new locations.
Figure 8-8 The gray I-beam indicates where Excel will insert selected cells.
Inserting and deleting
In the realm of spreadsheets, the complementary actions of inserting and deleting are
collectively the second most-used editing techniques. Inserting and deleting rows and
columns of information have some nuances that don’t exist in the world of word processing,
for example, but that you must consider.
Inserting columns and rows
On the Home tab, you can click commands on the Insert menu in the Cells group to add
cells, columns, and rows to a worksheet—and even add a new sheet to a workbook.
However, when you need to insert entire rows or columns, it’s easiest to right-click a column or
row heading, which simultaneously selects the whole row or column and displays the
shortcut menu shown in Figure 8-9. (You can also drag through several rows or columns and
then right-click the selection to insert the same number of columns or rows you selected.)
Then just click Insert.
After inserting the column in Figure 8-9, the contents of column D move to column E,
leaving the freshly inserted column D blank and ready for new information. The newly inserted
cells take on the same formats as the cells in the column to the left, and Excel adjusts the
formulas in cells F4:F15 to account for the expanded range.
A floating Insert Options button appears after you insert, which you can use to change the
formatting of the inserted cells. Click the button to display the menu shown in the second
image in Figure 8-9. If you want to extend a table by inserting a column on its right, for
Search JabSto ::

Custom Search