Jan 14 2022 09:04 PM
This may be a dumb question but columns used to be labelled with letters and I could create formulae easily. Now my columns appear as numbers and don't know how to refer to particular cells. For example if I want to add the cell in the first column and first row to the cell in the first column and second row I used to write = A1+A2 or =$a$1+$a$2. What do you do now columns are relabelled with letters? Am not sure how to write formulae now columns are also labelled with numbers.
Jan 14 2022 09:40 PM
@Matt_Benge That's called "R1C1 referencing style". You can switch it back to what you are used to in Options.
Jan 15 2022 02:28 AM
Jan 15 2022 01:44 PM