**Question description:**

*This user has given permission to use the problem statement for this blog.*

How can I subtract a fixed value from a complete column of cells.

Solved by Z. S. in 7 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
17/07/2018 - 04:05

Hello, I understand that you are trying to subtract a fixed value to a column, right?

User
17/07/2018 - 04:05

Yes please..

Excelchat Expert
17/07/2018 - 04:06

I see. I can help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.

Excelchat Expert
17/07/2018 - 04:06

Are you able to demonstrate what you need using the document preview to the right?

User
17/07/2018 - 04:07

from column A I want to subtract 5 from all cells.

Excelchat Expert
17/07/2018 - 04:08

I see. Do you want the result to be in the same location or do you want the result to be in another column?

Excelchat Expert
17/07/2018 - 04:08

This is easier if the result would be in another column.

User
17/07/2018 - 04:08

result in same locations.

Excelchat Expert
17/07/2018 - 04:08

Okay, are you using Excel?

User
17/07/2018 - 04:09

another column is fine

Excelchat Expert
17/07/2018 - 04:09

If another column is fine then you can simply use this formula:

User
17/07/2018 - 04:09

yes Excel 2013

Excelchat Expert
17/07/2018 - 04:09

=A1-5

Excelchat Expert
17/07/2018 - 04:09

Where A1 is where your first number is.

Excelchat Expert
17/07/2018 - 04:09

Then you can simply drag down the formula or copy and paste the formula to the rest.

Excelchat Expert
17/07/2018 - 04:09

You can see the formula in column B of the document preview.

Excelchat Expert
17/07/2018 - 04:11

Got it?

User
17/07/2018 - 04:11

I understand...thank you very much..appreciate the quick response.

Excelchat Expert
17/07/2018 - 04:11

You are welcome. Glad to have helped!

Excelchat Expert
17/07/2018 - 04:11

Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.

Excelchat Expert
17/07/2018 - 04:11

I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.

Excelchat Expert
17/07/2018 - 04:11

Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*