There are various ways to rectify this, but they usually require you to insert a helper column or type a formula. However ... Then, go back to that cell, and press Ctrl+C to copy it. The aim is to ...