If I can recommend you in advance, always include the information about your Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.) in your question. Ideally, if possible, add a file (without sensitive data) or photo-s with your plans and on the basis of this you explain your plan / wish step by step.
This will save you and others a lot of time.
I don't know which Excel version and operating system you have, but a suggested solution would be with VBA.
Also attached is an example file (write a text in whichever cell you want) and the VBA code.
Additional Info: formatting rows & columns
Private Sub Worksheet_Change(ByVal Target As Range)
Hope this information could help you.
Thank you for your understanding and patience
Wish you a nice day.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.