Microsoft Office Tutorials and References
In Depth Information
Accessing the Paste Options Gallery from the Right-Click Menu
Paste Link
Paste Link Creates formulas here that point back to the copied
range.
Paste as Picture
Paste as Picture Pastes a picture of the original cells in this
location.
Paste as Linked Picture
Paste as Linked Picture Pastes a live picture of the original cell
in this location. This is the elusive Camera tool from Excel 2003.
Open Paste Special
Open Paste Special Used to access the old Paste Special dialog.
The Paste Special dialog still offers some choices not available in
the Paste Options gallery: Comments, Validation, All using Source
Theme, Add, Subtract, Multiply, Divide, and Skip Blanks.
Accessing the Paste Options Gallery from the Right-Click Menu
Accessing the Paste Options Gallery from the Right-Click Menu
The Paste Options gallery appears in the right-click context menu and in-
cludes Live Preview. The top six options appear directly in the menu. A fly-
out menu offers all 14 options.
As you start to hover over the various paste icons, Live Preview takes
over. The rest of the context menu disappears so that you can see the work-
sheet. Hover over Transpose, and you get a preview of what Transpose ac-
tually does. Hover over Formatting and you see that the Formatting option
copies only the cell formats and not the numbers. If you hover over Paste
Special and then move out to the full gallery, all the context menu except the
full gallery disappears, and Live Preview continues to work.
Search JabSto ::




Custom Search