Copy data obtained by using formulas or functions in Excel

 

For example, the following result is obtained by using the function. The number column is the result obtained by using the function, and the input parameter of the function is data in a series of tables,

 

Score segment	Number of students
<60	31
60 ~ 69	73
70 ~ 79	116
80 ~ 89	91
90 ~ 100	7

 

If we want to copy and paste the number of people column to another Excel table, because the new Excel table does not have the original data (that is, the input parameters of the formula function ),

An error occurs. For example, the result is:

 

# Ref!

# Ref!

# Ref!

# Ref!

# Ref!

 

To copy the data values calculated using formulas to other tables, we need to do this:

 

First, select the columns to be copied, and then copy them. When you paste the columns to other Excel tables, right-click the columns and select "select to paste" and "value" to paste the values.