As far as I’ve understood it, referring to this system as an 8-bit system points out that one can access 8 bits of data in one instruction.
While I understand that we’re not saving vast amounts of time by calling it “one byte” instead of “eight bits”, is there a particular reason why the latter is/was preferred?
Is this called an anchor line? How this supposed to be called?
Absolute references are not changed when the referring cell is moved. But even with an absolute reference, if the referred cell moves the reference is updated. I want it to be dumber and continue to point to the same place even though the cell that was there moved, and pick up the content (a string) in what replaced the original cell. So, what I want is to define a ref to B5, add a new row 3 above B5, and still the ref points to B5. I haven’t found a function to do this. Defining a Name doesn’t help, nor does INDIRECT because both are updated to the new location of the original referred cell.