Dec 03 2021 01:29 AM
I constantly have to identify the column number and rows to write code in another software. However, as Excel still names the columns A, B, C, .... AW.... it is tedious to look up what AW means in numbers.
I suggest to show the numbers row and column when a cell is selected in the part of the excel-window, maybe left of the zoom function.
Something like this:
Dec 03 2021 01:37 AM - edited Dec 03 2021 01:37 AM
Solution@JOldeland Wouldn't it work if you switch the reference style to "R1C1"? Then the column references change to numbers.
Dec 03 2021 04:38 AM
@Riny_van_Eekelen Yes, this is already perfect! I did not know that this was possible. Many thanks! And sorry for this beginner question.
Dec 03 2021 01:37 AM - edited Dec 03 2021 01:37 AM
Solution@JOldeland Wouldn't it work if you switch the reference style to "R1C1"? Then the column references change to numbers.