The reason an error is returned when it is pasted into column A, is because there are no columns to the left of column A. the same relative position that A1 was to the original formula. In each case it is changing the reference to refer to the cell one to the left on the same row as the cell that the formula is in, i.e. If we have the very simple formula "=A1" in cell B1 it will change as follows when copied and pasted: When you copy and paste an Excel formula from one cell to another, the cell references change, relative to the new position: I am talking about use of the dollar sign ($) in an Excel formula. I want to cover something today that I use all of the time but seems to be understood in varying degrees by clients I work with.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |