Copy Paste formla

New Contributor

Dear all, 


I really hope you will be able to help me on this one, It could save me lots of time. 

Basically, lets say you have the formula =A1 in cell "B3" and you want to copy this cell in cell "D3" ; the result will be =C1 

I want when copy paste from B3 to D3 that the letter stay the same but the number change by +1....as a result having =A2

If I use =$A1 the result will be $A1.

Is anyone knows the formula I should use to lock the letter but change the number to +1 when copy paste ?


Thank you very much for you help. I hope It is clear enough :)


Good evening. 


2 Replies

Try the suggested formula in the attached picture.

You should copy it from cell B3 to D3 and F3.
Michael Micky) Avidan

Thank you very much for taking the time to answer to me. Unfortunately I am not as good in excel and I have tried several times but it does not seems to work. It might be from my side though. :-(


Have a great evenning





Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies