# Excel - COLUMN Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.