You need to select the first cell and then hold the Ctrl or Command key while you click on other cells that you want to include in our selection. You might want to enter the same data in the selected non-adjacent cells, delete their data, etc. Many of the frequent tasks that we do on Excel involve selecting non-adjacent cells. Fortunately, there are shortcuts for that too! Once you select the desired row or column, you can broaden your selection by holding the shift key along with the appropriate arrow key. Selecting a row or a column is one of the most common tasks in Excel. how to transfer video from dv camcorder to mac.After all, if you want to print your data in the worksheet, you would not want to print 20 blank pages just to find some stray data in some far away cell! This shortcut comes to rescue and helps you check that. It may happen that there is some stray data in a very far away cell in the worksheet. One of the uses of this shortcut is to quickly verify if there exists any data in the sheet that you do not know about. Many times it may happen that the last cell of the worksheet does not really have any data in it. The last cell in a worksheet is at the crossing point of the last column that contains information and the last row that contains information.
