Forum Discussion
Copy a formula horiztonally (Row 1") that references text in only one column "Column A"
I have an excel sheet with text in Column A. I have a formula that I need to copy and paste on the first row (D1, F1, H1, J1, L1...) the formula references text only in column A (A1, A2, A3, A4, A5...
Kindly use Absolute Reference ($A$1).
PFB Example
Please consider giving it a 'thumbs up' if it was helpful for you. You can also show your support by subscribing to my YouTube channel, @Excelonlineadvisor, and following me on Instagram, @Excelonlineadvisor.
Thank you. Unfortunately Absolute Reference ($A$1) did not work. A1 appear in each cell instead of A1, A2, A3...