**Question description:**

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

i want to hide a column but still use it in formula. is this even possible?

Solved by X. E. in 11 mins

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

Excelchat Expert
27/02/2018 - 05:41

Hi

User
27/02/2018 - 05:41

hi

Excelchat Expert
27/02/2018 - 05:41

So hiding a column and using formula based on that column

User
27/02/2018 - 05:42

yes

Excelchat Expert
27/02/2018 - 05:42

Check

Excelchat Expert
27/02/2018 - 05:42

I have hid column B

User
27/02/2018 - 05:42

how did u do that

Excelchat Expert
27/02/2018 - 05:43

Just hide the column B

Excelchat Expert
27/02/2018 - 05:43

But you can use B at any where in the sheet

Excelchat Expert
27/02/2018 - 05:43

That will not be a problem

User
27/02/2018 - 05:43

i am using ms office 2007

Excelchat Expert
27/02/2018 - 05:43

Its fine

User
27/02/2018 - 05:44

no option showing to hide

Excelchat Expert
27/02/2018 - 05:44

It supports in MS OFFICE 2007

Excelchat Expert
27/02/2018 - 05:44

Right click on the column

User
27/02/2018 - 05:44

i did it

User
27/02/2018 - 05:44

thanks

Excelchat Expert
27/02/2018 - 05:44

Found?

User
27/02/2018 - 05:44

yes

Excelchat Expert
27/02/2018 - 05:44

Great!

Excelchat Expert
27/02/2018 - 05:44

Thats it then

User
27/02/2018 - 05:44

i need a formula to update balance

Excelchat Expert
27/02/2018 - 05:45

You can attach the sheet if you have the work

Excelchat Expert
27/02/2018 - 05:45

I can work on that based on your requirement

Excelchat Expert
27/02/2018 - 05:47

You there?

User
27/02/2018 - 05:48

sorry thats not possible. but here is the detailed question. in M3 column i have a formula to calculate profit/loss i need a formula to update balance in N column . for example my inital balnce is 100 usd. if profit is 5 usd in m column . n column should update 105usd. if loss is -3 usd . n column should show 97 usd

Excelchat Expert
27/02/2018 - 05:49

Check

Excelchat Expert
27/02/2018 - 05:50

Column A is your N

Excelchat Expert
27/02/2018 - 05:50

And B is M

Excelchat Expert
27/02/2018 - 05:50

A1 is the initial balance

User
27/02/2018 - 05:52

thanks got it

**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.*