CCNC/CCNC Module 4/Spreadsheets2/Cells/Shifting
Previously we made changes to the contents of cells. In this operation our focus is on the entire cell, taken as a whole, and not on its contents. We will be moving a range of adjacent cells either horizontally or vertically. We are moving the cells; the data inside the cells remains in tact. To perform this function, we use the Delete Cells dialogue Box, which is accessed through Edit>Delete Cells. You may be wondering about the name of this tool, since you have not set out to delete any cells. Dont worry too much about that. As you will notice, the dialogue box includes two types of functions - shifting of cells and deleting entire rows and columns, that is all (not some of) the cells in a row or column. We are focusing on the shifting function. When we apply either of the 'Shift cells' function, we are interested in the movement of cells either to the right or above the highlighted cells.
Now do it
- Highlight the range C10:F14
- Edit->Delete Cells
- Click the Shift Cells Up radio button then click OK.
- Notice that the cells previously in C15:F15, that is in the row immediately below the highlighted range,have moved up to C9:F13, that is in the row immediately above the highlighted range.
(: The content expert needs to pay special attention to the cell ranges. I made changes to the ones in the original materials because they did not seem to be accurate. So these need to be checked.)