Microsoft Office Tutorials and References
In Depth Information
Accessing the Gallery After Performing a Paste Operation
You open the Paste drop-down from the Home tab.
After you perform a typical Paste operation, the old Paste Repair
menu icon appears with the tip that you can press Ctrl to access the
gallery.
Accessing the Gallery After Performing a Paste Operation
Accessing the Gallery After Performing a Paste Operation
Suppose that you copy a range with Ctrl+C and then paste with Ctrl+V. The
icon for the old Paste Repair appears next to the paste, but this time it notes
that you can open the menu by pressing Ctrl. When you press Ctrl, you are
presented with a gallery of paste options.
The options available in the gallery are as follows:
Paste
Paste This is the standard paste that you would get using Ctrl+V.
Formulas
Formulas Pastes only formulas, with no formatting. This is com-
mon when you are copying down from the first row of a table that has
an outline border. To prevent the top border from copying, you can
paste formulas. You then find that you have to reapply the number
formatting.
Formulas & Number Formatting
Formulas & Number Formatting Copies formulas as previous for-
mulas, along with the number formatting.
Keep Source Formatting
Keep Source Formatting This is particularly useful when copying
from another application such as a web page. The formatting from the
other application is pasted along with the values.
No Borders
No Borders Pastes everything but the borders.
Column Widths
Column Widths Includes the column widths from the copied area.
Transpose
Transpose Turns the data on its side. A 12-row-by-1-column
copied range would paste as 1 row by 12 columns.
Values
Values Converts formulas to values.
Values and Number Formatting
Values and Number Formatting Converts the formulas to values
and includes the number formats from the copied data.
Values & Source Formatting
Values & Source Formatting Converts the formulas to values and
includes all formatting such as cell styles, font color, number
formatting, and borders.
Formats
Formats Does not bring any values, only the cell formatting. Sim-
ilar to using the Format Painter but not as annoying.
Search JabSto ::




Custom Search