![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://www.thewindowsclub.com/wp-content/uploads/2022/02/hide-paste-options-after-pasting-content-excel-1.png)
This will take vertical columns and turn them into horizontal rows of data or vice versa.
![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://www.thewindowsclub.com/wp-content/uploads/2022/02/hide-paste-options-after-pasting-content-excel.png)
![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://support.content.office.net/en-us/media/2898ed21-e53b-4ba3-9899-a8fcb1c3b135.png)
This maintains the formulas and all other formatting, but changes the widths of the columns to match the source. This maintains the formulas and all other formatting (colors and number formatting). This will eliminate any text formatting and cell colors, but maintain number formatting such as the number of decimal places, percentage formats, or accounting formats. The formatting (colors, font, number formatting) won’t be transferred to the new cells. There are a number of other options for pasting data:īutton Description Paste formulas only.
#WHAT ARE THE DIFFERENT PASTE OPTIONS IN EXCEL 2016 UPDATE#
Only use this option if you won’t need these values to update later on. Because these options paste static values, they will not update if you change any other cells on the spreadsheet. The second section in Paste Options has three options to Paste Values instead of formulas. In this case, you do not want to copy the formulas, but instead, the values. For example, if you want to copy the acceleration column without the force column, the default paste would give you a column of zeroes because their formulas would be referencing empty cells (or whatever cells are directly to the left). If you update the original table, those changes won’t be reflected in this new copy. In this example, the acceleration data are calculated from the force, and those formulas reference the force column that we’ve just pasted rather than the original. Although the formulas are preserved, the cells that are referenced in the formula will be relative. It will paste all of the formatting and formulas that existed in the source data.