The paste function in Microsoft Office products is probably the most widely used next to copying. Some suggestions from users were accepted and incorporated into the development of Office 2010. There were mainly problems when inserting content into Excel tables, since not only the content shown, but also formulas and other values have to be copied. The changes are demonstrated here once in Excel 2010.
In order to try out the new paste function, something must first be copied.
Now stand one three different options to choose to insert something.
- The Insert button
- The right mouse button
- Ctrl + V
The new symbols, which the insert function arranges in three groups, are immediately noticeable. In the Excel predecessors, these were hidden in numerous submenus. Furthermore, it is noticeable that when you move over the individual functions with the Cursor*, a preview is displayed in real time, such as when selecting the font size.
These are among the three groups of the insert function Insert, Insert values and More insert options. These are explained again in more detail here. (from top left to bottom right)
Insert
- Inserts the values and all formatting in the new position.
- Inserts only the values of the source data without formatting.
- Accepts the values and number formats from the source data.
- Adopts the values and formatting of the source data.
- Retains formatting, but frames are removed.
- Also takes over the column width of the source data.
- Transposes the cells to be copied.
Insert values
- Accepts only the values.
- Accepts the values and number formats.
- Accepts the values and all formatting from the source.
More insert options
- Only takes on the formatting of the source area.
- Inserts links to the source data as a formula.
- Inserts an image, i.e. a screenshot of the source area.
- Inserts an image of the source data linked via a formula.
| Transparency: | This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de. |
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille
Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.