# Excel - COLUMN Function Problem - Expert Solution

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

how to paste a formula from one column to another
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/09/2018 - 11:52
Hi, welcome to Got it Pro-Excel!
Excelchat Expert 05/09/2018 - 11:53
According to my diagnosis, you need help with copying formulas from one column to another, is that correct?
User 05/09/2018 - 11:53
how do i copy formula i used in b2 to rest of b column
Excelchat Expert 05/09/2018 - 11:54
Ok, first - do you know how to do a basic copy and paste?
User 05/09/2018 - 11:54
yes
Excelchat Expert 05/09/2018 - 11:54
Ok, that's good.
User 05/09/2018 - 11:54
yup
Excelchat Expert 05/09/2018 - 11:54
Try clicking cell B2.
Excelchat Expert 05/09/2018 - 11:55
Then copy it by pressing Ctrl+C
Excelchat Expert 05/09/2018 - 11:55
Do you know how to select a range?
User 05/09/2018 - 11:55
kyes
User 05/09/2018 - 11:55
yes
Excelchat Expert 05/09/2018 - 11:55
Ok, try selecting cell B3 to B8.
User 05/09/2018 - 11:55
k
Excelchat Expert 05/09/2018 - 11:56
Then paste by pressing Ctrl+V, make sure that you are copying cell B2, you'll know if B2 has a dotted or dashed border instead of the usual line border.
User 05/09/2018 - 11:56
but you said only to copy b3-b8 not b2?
Excelchat Expert 05/09/2018 - 11:57
Ok, let's repeat it step by step.
Excelchat Expert 05/09/2018 - 11:57
1. Click cell B2
Excelchat Expert 05/09/2018 - 11:57
2. Then Copy by pressing Ctrl+C
User 05/09/2018 - 11:58
k
Excelchat Expert 05/09/2018 - 11:58
Then highlight or select Range B3 to B7
User 05/09/2018 - 11:58
done
Excelchat Expert 05/09/2018 - 11:58
I meant B3 to B8.
User 05/09/2018 - 11:58
k
Excelchat Expert 05/09/2018 - 11:58
I think your selecting A3:A8.
User 05/09/2018 - 11:58
oh you are right
Excelchat Expert 05/09/2018 - 11:59
4. Press Ctrl+V or paste.
Excelchat Expert 05/09/2018 - 11:59
Is that what you're trying to achieve?
User 06/09/2018 - 12:00
yes!!!
User 06/09/2018 - 12:00
thank you
Excelchat Expert 06/09/2018 - 12:00
My pleasure. Would there be anything else I can assist you with regards to the original question and the solution provided?
Excelchat Expert 06/09/2018 - 12:03
Hi, are you still there?
Excelchat Expert 06/09/2018 - 12:05
It's been a while since you replied. Do you have any more questions for me with regards to the original question and the solution provided?
Excelchat Expert 06/09/2018 - 12:07
If that's all, I'd like to wish you have a very nice day ahead of you and we'd love to hear from you again. Thank you for using Got it Pro-Excel!
Excelchat Expert 06/09/2018 - 12:07
Feel free to end the session and leave a rating and comment if you liked our service. I'll do the same and rate you 5-stars as a user since your a fast learner and I'd like for you to be one of our high-rated users. warm regards!

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

Trusted by people who work at