Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Enjoying Your Work and other Businesses topics.
Insert new cells and paste data in a single step. When copying and moving cells, select the range of cells you want to move, point with your mouse to the border of the selection, and hold down the Ctrl key as you drag the range to the location. When you release the mouse button, Excel copies the cells to the destination. To insert data at the destination, press and hold the Shift and Ctrl keys as you drag your selection; existing cells are shifted down or right.
Guru Spotlight |
Ray Lokar |