I would like to lock a cell in order to copy numbers only.eg B21 Can I lock just the 21 so that the next numbers would be c21, d21,e21 etcwhen I copy to other cells
Yes - it's called "absolute cell references"put a $ symbol infront of the numberi.e. b$21
This thread is now locked and can not be replied to.
Xiaomi Mi Mix 2 review
What went wrong at the Designs of the Year 2017
iPhone X news: Release date, price, new features & specs
Comment utiliser Live Photos ?
© Copyright 2017 IDG UK. All Rights Reserved.