ExcelBanter - How do I add 1.5 to each cell in a particular column?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I add 1.5 to each cell in a particular column? (https://www.excelbanter.com/new-users-excel/131526-how-do-i-add-1-5-each-cell-particular-column.html)

BrendaC

How do I add 1.5 to each cell in a particular column?

Max

How do I add 1.5 to each cell in a particular column?

On Feb 21, 8:20 am, BrendaC wrote:
How do I add 1.5 to each cell in a particular column?

Enter 1.5 in an empty cell. Copy the cell.
Then select the col range, right-click paste special add ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

BrendaC

How do I add 1.5 to each cell in a particular column?

Thank you so much for your help - it worked!

"Max" wrote:

On Feb 21, 8:20 am, BrendaC wrote:
How do I add 1.5 to each cell in a particular column?

Enter 1.5 in an empty cell. Copy the cell.
Then select the col range, right-click paste special add ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

How do I add 1.5 to each cell in a particular column?

On Feb 21, 1:32 pm, BrendaC wrote:
Thank you so much for your help - it worked!

Welcome, Brenda. Nice of you to post back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

All times are GMT +1. The time now is 05:40 AM.