Whenever new cells are inserted into a worksheet in Excel 2007, 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, highlight the cells above which you would like the new cells inserted then choose Home – Cells – Insert – Insert Cells. Excel then displays a dialogue box asking you to specify what to do with the existing data and, naturally, you would choose “Down”. When you click OK, existing data moves down and a range of cells is inserted of the same 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 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 normally blank. However, it is possible to 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. To do this 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. If you right-click, 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. Similarly 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”. If the copy command is used, 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.
The author is a trainer and developer with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel Classes in London and throughout the UK.
Looking for a nice gaming experience after a hard working day? Learn how to get a cheap PlayStation 3 and set the motion for the game