Excel numbers and formulas question

Factual Questions
1

I have a matrix of numbers with several rows and several columns. I’ve auto-summed each column to obtain a row of totals at the bottom of the matrix, and each of the totals is the result of the auto-sum function. My question is, how can I now just get the value without it being dependent on the formula? For example, I have a column with 1, 7, 2, 5, 5, auto-summed to get me a total of 20. However, if I click on the “20” cell, I will see "=SUM(A2;A6), which at this point isn’t an issue. But, if I choose to delete the intervening rows, or if I copy the table so that I can pivot it, all of my totals become “#REF!”.

So how can I grab the totals, decoupled from the formula, while maintaining the totals?

2

When you copy/paste, there should be a pulldown menu for “paste” that includes “paste values.”

3

Awesome! I was looking for something like that and it worked. Thank you very much!