Using enhanced smart tags and the Paste preview


show more Using enhanced smart tags and the Paste preview provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features show less
please wait ...

Using enhanced smart tags and the Paste preview

Microsoft discovered that about 90% of the time the first thing the user does after pasting is to undo. So obviously something wasn't working quite right. So now when you paste, you'll see the New Paste Options pop-up which would make it easier to choose what you want. So even if you don't get what you expect immediately, you'll have a better shot at doing it. So let's do this. Let's click inside this table here. And when you do, you may see this Table tools and Design tab come up. And that's really not important right now. What we want to do is select all of the cells in this table.

Now press Ctrl+A to select all. That selects all the data. Press Ctrl+A a second time, and that selects the column headers and the total row down at bottom. Now copy to the clipboard as you normally would. I'll press Ctrl+C. And let's go to Sheet2. And I'm going to go over here to around E6, because I want to leave that left side opened. You'll see why. Rather than just...

Using enhanced smart tags and the Paste preview
Video duration: 3m 16s 1h 51m Appropriate for all

Viewers:

Using enhanced smart tags and the Paste preview provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features

Subject:
Business
Software:
Excel
Author:
please wait ...