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.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Ask a Question

Not finding the advice and tips you need on this Businesses Tip Site? Request a Tip Now!

Guru Spotlight

Alexis Niki

Ever wonder how you could make your life better and more fun? So have tens of millions of fans who have turned to LifeTips for answers over the past decade. We keep the tips, advice, books, podcasts and writing services flowing, so you can keep your life and business growing in the right direction. Upward!