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.
