From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Accelerate worksheet copying and moving

Accelerate worksheet copying and moving

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Accelerate worksheet copying and moving

- [Voiceover] Any time you need to move a worksheet to a different location, it's really simple, we simply click and drag the sheet tab. I wanna move the Sales sheet to the right of Profits. Sales is active I click and drag, rightward or leftward in this case rightward put it behind profits let go of the mouse and there it is. At a later time I might change my mind I'll move it back again. It can hardly be easier. There could be times that I wanna move more than one sheet. Even though these sheets are empty, sheets three through six. If I wanna select a whole cluster of sheets Click sheet three, with the Shift key held down, I'll click sheet six and I'll drug sheet three leftward, and I'm actually moving four sheets at once, and put them to the left of Sales over here. At other times, I might want to copy a sheet. Maybe I wanna copy, of this projected budget right here. I like the numbers that I see here, but I wanna run another set of number similar to this, but with different…

Contents