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 you have three different options to choose from for inserting something.
- The Insert button
- The right mouse button
- Ctrl + V
The new icons, which organize the Insert function into three groups, are immediately noticeable. In previous versions of Excel, these were hidden in numerous submenus. Furthermore, it's noticeable that when you hover the mouse pointer over the individual functions* , a real-time preview is displayed, such as when selecting the font size.
The three groups of the Insert function are Insert , Insert Values , and Other Insert Options . These are explained in more detail below. (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.
