- Image and text skills
The "Paste Special" of the table includes a variety of pasting methods, and its shortcut key is Ctrl+Alt+V
1. Paste formulas, formulas and number formats
Take this sales table as an example. We can see that cell F2 contains a formula. We want to copy the formula from F2 to F6 to find the unit price of mobile phone A.
Copy cell F2, right-click "Paste Special" and select "Formula", so that you can paste the formula of F2.
We can see that cell F2 is a cell with currency format. If you want to paste the formula of F2 and retain the currency number format, select "Formula and Number Format", so that the formula, number The formatting will be pasted.
2. Paste values, values and number formats
When the copied cell contains a formula, data confusion or error messages will appear when pasting. At this time, you can select "Value" in "Paste Special" to paste the formula result. Paste into the range as a numerical value.
If you want to paste the formula result and retain the currency number format, select "Number and number format", so that the value and number format will be pasted.
3. Paste format
If you want to copy and paste the format in the table to other areas, you can select "Format" in "Paste Special".
"Format" includes a variety of cell formats, such as currency format, date format, and you can also paste font format and color format.
4. Paste comments and validity verification
If you want to paste only the comments on the cell, you can choose to paste "Comments" in "Paste Special".
If you want to paste the cell's validity rules to other cells, you can choose to paste "Validity Verification" in "Paste Special", so that when the input does not match A reminder mark will appear in the conditional cell.
5. Column width and borderless
If you want to paste only the column width of the selected table area, you can choose to paste "Column Width" in "Paste Special".
If you don’t want to paste the border of the table when copying the table, you can choose to paste "Except Border" in "Paste Special".
6. Operation when pasting
If you want to paste cell B2 into the area A2:A7 and perform the addition operation, copy cell B2, select the area A2:A7, and select paste in "Paste Special" The operation "add". Similarly, you can also use this function to perform multiplication and division operations on the data area in batches.
7. Skip empty cells
When copying an area and pasting, the entire paste will cover the empty cells. So how can I skip the empty cells and paste?
Just select "Skip empty cells" in "Paste Special"
8. Row and column transposition
If you want to paste the horizontal table content into columns or the vertical table content into rows, you can select "Transpose" in "Paste Special", so that You can convert horizontal rows into columns and vertical columns into rows.
9. Paste as link
When pasting data, if you want to change the original table data, the new data after pasting will also be updated simultaneously. You can select "Paste as Link" in "Paste Special" and modify it at this time. When the original table data is loaded, the pasted data area will also be updated simultaneously.
The above is how to use "Paste Special" in the form. Come and use this practical function.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-de-duo-zhong-zhan-tie-fang-shi-xuan-ze-xing-zhan-tie.html
支付宝扫一扫 
评论列表（196条）
测试