Excel Cell Locks

  sms 12:10 03 Feb 2003

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 etc
when I copy to other cells

  harristweed 12:19 03 Feb 2003

Yes - it's called "absolute cell references"

put a $ symbol infront of the number

i.e. b$21

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

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 ?