Discussion Locked

microsoft excel paramveer

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Excel, if I copy a cell containing a formula down the column to copy to adjustment rows, i need formula increase sequentially for example if a1 = 5, a1 =2, a3= 4 and then i use coloum no. m4 =a1 i.e. 5 but when i copy m4 paste it on m6 the result is m6=a3 i.e. 4 but i need m6=a2 how can i copy formula

1 reply

by Wizard57M-TR

Try re-posting in the Q&A
section.The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution. The 'Water Cooler' is for non-technical discussions. You can submit a question to 'Q&A' here:

https://www.techrepublic.com/forum/questions/post?tag=mantle_skin;content

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer". .

This discussion is closed to new replies.