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

  • Thread starter Thread starter Guest
  • Start date Start date
How do I add 1.5 to each cell in a particular column?
Click to expand...

Enter 1.5 in an empty cell. Copy the cell.
Then select the col range, right-click > paste special > add > ok

---
 
Thank you so much for your help - it worked!

Max said:
Enter 1.5 in an empty cell. Copy the cell.
Then select the col range, right-click > paste special > add > ok
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding the same number to each cell in a column 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I add 1 to a number in column b 8
Curious general format rounding 2
split 1.5/2.1 into 1.5 and 2.1 2
conditional format based on column statistics and loop over columns 1
How to find out when you're getting full fibre internet 3
Modifying Text in a column 9

Back
Top