Forum Discussion
Excel formula
Hi Carlos
Try ' in front of the formula in E1 and autofill down.
Example: '=$A1
That will show text only of your formula.
If you're looking for something more intricate, please write back?
Cheers
Damien
Hi Damien.
Thank you for your reply.
Sorry for my mistake. I don't want the cells to show the formula. what I really want is cell D1 to show "M" and cell E1 to show "N". In other words, I want to copy the formula along one line and the formula must show the data across column A.
Thank you
Oooh if you want to pull the formula down the column for =$A1 =$A2, etc then please try this.
1. Click into cell D1, you should see a small square at the bottom right of the cell.
2. Hover your mouse cursor over the dot and left click and hold down the button.
3. Drag down and the formula will go =$A2, =$A3, etc.
Left click the suqare, bottom right of the cell and drag downHere's the result
One other way to do it if you are doing many cells, is to select the cells in your column you want to have the formula in, go to the Home tab > (Editing) Fill > Down.
This will autofill the formula to what you have selected.
Let me know if this is what you were after please?
Cheers
Damien