# Google spreadsheet question
**URL:** https://boards.straightdope.com/t/google-spreadsheet-question/978767
**Category:** Factual Questions
**Created:** [January 25, 2023, 6:44am UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767 "2023-01-25T06:44:00Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Mike\_Mabes](https://boards.straightdope.com/u/Mike_Mabes)
#### Post date: [January 25, 2023, 6:44am UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/1 "2023-01-25T06:44:00Z")
I have a column of numbers and I want to add 10 to each number in the column. In Excel, as I recall, it’s been many years, you could highlight the cells and create a formula. How would I do this in Google? After it is done I want to remove the formula so the numbers don’t change in that column on down.
---
### Author:  [@Richard\_Pearse](https://boards.straightdope.com/u/Richard_Pearse)
#### Post date: [January 25, 2023, 9:49am UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/2 "2023-01-25T09:49:58Z")
Do you need the new numbers to be in the same column / cells as the original numbers? That is something that Google Sheets doesn’t seem to be able to do but I remember you could do it in Excel by special pasting a formula.
Otherwise, the easiest way would be to create a new column of numbers that are the original cell + 10 but I suspect that’s not what you are after?
---
### Author:  [@Mike\_Mabes](https://boards.straightdope.com/u/Mike_Mabes)
#### Post date: [January 25, 2023, 11:33am UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/3 "2023-01-25T11:33:09Z")
I could do that and then copy the column back over the origninal one
---
### Author:  [@Richard\_Pearse](https://boards.straightdope.com/u/Richard_Pearse)
#### Post date: [January 25, 2023, 11:49am UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/4 "2023-01-25T11:49:58Z")
Yes, you can.
---
### Author:  [@Mike\_Mabes](https://boards.straightdope.com/u/Mike_Mabes)
#### Post date: [January 25, 2023, 11:52am UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/5 "2023-01-25T11:52:27Z")
Do you know the formula I would use? I was pretty sure this could be done, but didn’t know how
---
### Author:  [@pjd](https://boards.straightdope.com/u/pjd)
#### Post date: [January 25, 2023, 12:06pm UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/6 "2023-01-25T12:06:53Z")
If your column of numbers stars at A1 and ends at A 20, and your temp column is B;
In B1, enter “=A1+10” and press enter
Then click back on B1 and select copy (ctrl C)
Then highlight the rest of column B (ie, click on B2 then shift+click on B20) and
paste the formula (ctrl V).
Then copy column B back over column A (using ctrl + shift + V to paste values only)
---
### Author:  [@Mike\_Mabes](https://boards.straightdope.com/u/Mike_Mabes)
#### Post date: [January 25, 2023, 12:08pm UTC](https://boards.straightdope.com/t/google-spreadsheet-question/978767/7 "2023-01-25T12:08:53Z")
thank you, that is very helpful