# Excel numbers and formulas question **URL:** \ **Category:** Factual Questions\ **Created:** [August 17, 2020, 1:33pm UTC](https://boards.straightdope.com/t/excel-numbers-and-formulas-question/918314 "2020-08-17T13:33:10Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![velomont](https://avatars.discourse-cdn.com/v4/letter/v/8491ac/32.png) [@velomont](https://boards.straightdope.com/u/velomont)\ **Post date:** [August 17, 2020, 1:33pm UTC](https://boards.straightdope.com/t/excel-numbers-and-formulas-question/918314/1 "2020-08-17T13:33:10Z")
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? ---
**Author:** ![YamatoTwinkie](https://avatars.discourse-cdn.com/v4/letter/y/cc9497/32.png) [@YamatoTwinkie](https://boards.straightdope.com/u/YamatoTwinkie)\ **Post date:** [August 17, 2020, 2:04pm UTC](https://boards.straightdope.com/t/excel-numbers-and-formulas-question/918314/2 "2020-08-17T14:04:43Z")
When you copy/paste, there should be a pulldown menu for “paste” that includes “paste values.” ---
**Author:** ![velomont](https://avatars.discourse-cdn.com/v4/letter/v/8491ac/32.png) [@velomont](https://boards.straightdope.com/u/velomont)\ **Post date:** [August 17, 2020, 2:10pm UTC](https://boards.straightdope.com/t/excel-numbers-and-formulas-question/918314/3 "2020-08-17T14:10:29Z")
Awesome! I was looking for something like that and it worked. Thank you very much!