The disadvantage of this technique is that when it spots an empty row, then it stops copying. Excel will copy the cell value to the rest of the cells below. Instead of dragging the fill handle to copy the cell values, just double click on it. One still involves using the mouse and the other technique uses the keyboard. There are two other quick techniques to copy cell values. Dragging the fill handle inside will clear the values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |