I recently discussed Paste options in Office 2010 which have been upgraded to show a paste preview and it provides different types of pastes with formatting or without.In excel the paste preview has few more options.
In the screenshot above i have copied a cell and then tried to paste it in some other cell.These are all paste options i had:
Under Paste we have the following pastes available :
- Paste
- Formulas
- Formulas & Number formatting
- Keep Source formatting
- No Borders
- Keep source Column widths
- Transpose
Under Paste Values we have the following pastes available :
- Values
- Values & Number formatting
- Values & Source formatting
Under Other Paste Options we have the following pastes available :
- Formatting
- Paste Link
- Picture
- Linked Picture
You can also have a paste preview of any of the above option,just mouse over that option & paste preview would be shown in the excel sheet itself.
Hi,
Regarding the new paste function, do you know if there is any way to customize what choices show up? for instance, I need to paste values and transpose, and I am having to still click on past special and choose these choices versus having a button for it.
Thanks