Whenever new cells are inserted into a worksheet, existing data has to shift in order to make room to the newly inserted cells. When we are inserting entire rows or columns the direction in which data will be moved is predetermined. If we insert an entire column, existing data is shifted to the right. If we insert an entire row, any existing data is shifted down. However when we insert cells rather than entire rows or columns excel needs to ask us in which direction we want the existing data to be shifted: to the right or down.
To insert a row of cells, begin by selecting the cells above which you would like the new cells inserted then choose Home - Cells - Insert - Insert Cells. Excel will then display a dialogue box asking you to specify what to do with the existing data and, naturally, you should choose "Down". When you click OK, the existing data moves down and a range of cells is inserted matching the size as the range that was highlighted.
The same rules apply when we delete cells. To delete an unwanted row of cells, select the appropriate cells and choose Home - Cells - Delete - Delete Cells. Alternatively, you can right-click on the highlighted cells and choose Delete from the context menu. Again, Excel displays a dialogue box asking you to specify the direction in which you want the existing data to move. This time, however, since we are moving data to fill the gap created by the Delete command, the directions available are "Up" and "Left". To delete a row of cells, we would choose "Up" as the direction.
When you are inserting cells, the format of the newly inserted cells will always match that of the cells which are selected when the Insert command is used.
Inserted cells are also normally blank. However, you can also cut or copy a range of cells and then, instead of pasting them, to insert them above or to the left of a given range. Simply copy or cut the desired range and then highlight the range of cells above or to the left of which you want the cells inserted. Upon right-clicking, you will notice that the context menu displays the command "Insert Copied Cells" (or "Insert Cut Cells" if the cut command was used) in place of the normal "Insert" command. In a similar fashion, in the Insert drop-down menu in the Cells group of the Home Tab of the Excel Ribbon, "Insert Cells" has also been replaced by "Insert Copied (or Cut) Cells". When you use the copy command, having inserted cells, to exit copy mode and get rid of that flashing border around the copied cells, simply press the Escape key on your keyboard.
To insert a row of cells, begin by selecting the cells above which you would like the new cells inserted then choose Home - Cells - Insert - Insert Cells. Excel will then display a dialogue box asking you to specify what to do with the existing data and, naturally, you should choose "Down". When you click OK, the existing data moves down and a range of cells is inserted matching the size as the range that was highlighted.
The same rules apply when we delete cells. To delete an unwanted row of cells, select the appropriate cells and choose Home - Cells - Delete - Delete Cells. Alternatively, you can right-click on the highlighted cells and choose Delete from the context menu. Again, Excel displays a dialogue box asking you to specify the direction in which you want the existing data to move. This time, however, since we are moving data to fill the gap created by the Delete command, the directions available are "Up" and "Left". To delete a row of cells, we would choose "Up" as the direction.
When you are inserting cells, the format of the newly inserted cells will always match that of the cells which are selected when the Insert command is used.
Inserted cells are also normally blank. However, you can also cut or copy a range of cells and then, instead of pasting them, to insert them above or to the left of a given range. Simply copy or cut the desired range and then highlight the range of cells above or to the left of which you want the cells inserted. Upon right-clicking, you will notice that the context menu displays the command "Insert Copied Cells" (or "Insert Cut Cells" if the cut command was used) in place of the normal "Insert" command. In a similar fashion, in the Insert drop-down menu in the Cells group of the Home Tab of the Excel Ribbon, "Insert Cells" has also been replaced by "Insert Copied (or Cut) Cells". When you use the copy command, having inserted cells, to exit copy mode and get rid of that flashing border around the copied cells, simply press the Escape key on your keyboard.
About the Author:
The The writer of this article is a training consultant with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel 2007 Classes at their central London training centre.
0 comments:
Post a Comment