Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

in row 1, I have cells that are set up as percentages for the columns. I want to times the number in column A by the percentages in row 1, for the rest of the row by starting the formula =B2*A2 then dragging along the rest of the row. What happens is the formula automatically changes the B2 to the next column as it drags. How do it get it so that when I drag the formula stays with *B2, but will change the other part of the formula to the correlating percentage?
Solved by B. J. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/06/2018 - 01:55
Hi…Welcome to Got It Pro
User 14/06/2018 - 01:55
User 14/06/2018 - 01:56
It's a bit hard to explain when I cant speak the language.
Excelchat Expert 14/06/2018 - 01:56
Can we do a quick simulation in this preview sheet?
User 14/06/2018 - 01:56
yes sure
User 14/06/2018 - 01:56
would you like me to go?
Excelchat Expert 14/06/2018 - 01:56
User 14/06/2018 - 01:57
so I have set up cost centres in columns, and cost centres are all paying for a percentage of an admin expense.
User 14/06/2018 - 01:58
okay, so then i put an expense in the budget
User 14/06/2018 - 01:59
then I want the cost centres to show the expense in their columsn
User 14/06/2018 - 02:00
yep. please explain
Excelchat Expert 14/06/2018 - 02:00
i have just done the formula
Excelchat Expert 14/06/2018 - 02:00
I am using absolute and relative cell references to lock the cells when required.
User 14/06/2018 - 02:01
ah yes, I do not know about absolute and relative cells
Excelchat Expert 14/06/2018 - 02:01
Say cell C4 =$A4*C$2
User 14/06/2018 - 02:02
yep. so the dollar signs mean something?
Excelchat Expert 14/06/2018 - 02:02
$A4 means column A is static when you drag it to right, while row number can vary when you pull down
Excelchat Expert 14/06/2018 - 02:02
Yes, dollar sign means absolute reference
Excelchat Expert 14/06/2018 - 02:02
and no dollar mean relative reference
User 14/06/2018 - 02:02
I see, so whenever you put the $, the reference cell wont change?
Excelchat Expert 14/06/2018 - 02:02
Similarly, C$2 mean column can vary but rows remains static
Excelchat Expert 14/06/2018 - 02:03
Yep...that's right
User 14/06/2018 - 02:03
I see. Very helpful.
Excelchat Expert 14/06/2018 - 02:03
Is there anything else I can help you with this query?
User 14/06/2018 - 02:03
no, thats a new wonder openned up for me.
User 14/06/2018 - 02:03
Excelchat Expert 14/06/2018 - 02:03
Yes, it makes excel a lot friendlier
Excelchat Expert 14/06/2018 - 02:04
Please do give me a good feedback for my service.
Excelchat Expert 14/06/2018 - 02:04
Thanks for your time. Please do come back for any new question. Have a great day ahead!
User 14/06/2018 - 02:04
Thanks. I will do!

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc