Excel Cell Locks

  sms 12:10 03 Feb 03
Locked

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 03

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.

What is Google Allo? What is Google Duo? Google Allo UK release date and features: Google Allo is…

1995-2015: How technology has changed the world in 20 years

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…