Insert Hyperlink Navigating to sheets of alpha characters(A,B, C, D,etc.), C & R do not work?

I am using 26 sheets each named after one letter of the alphabet, (i.e. A, B, C , D, E,…X, Y, Z).
A 27th sheet named “Alpha” is used to link to each page using “Insert Hyperlink” (or Ctl-K) with 26 cells each having one letter of the alphabet.

The purpose of this is that each page has a list of links of files to open, the name of each file starting with the letter assigned to the page on which it resides.

All of this works flawlessly except for the hyperlinks for the letter C and the letter R.
When I click on the link to the letter C, instead of going the the sheet C, it selects a Column in the “Alpha” page on which these links are. For the letter R, clicking on it selects a Row on the same sheet. So I deduct Calc is using C to refer to “Column”, and R to refer to a “Row” instead of the sheets named C or R.

Is this normal?
In “Insert Hyperlink” (or Ctl-K), is there a special character to avoid the target being interpreted as a column or row and only interpret a worksheet?

My workaround for the moment has been to rename the sheet “C” to “#C” and this works but it would be better if there is another way.

Sincerely,
Dan

Naming Cells help topic:

Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names.

This comes from existence of Excel R1C1 addressing syntax.
This needs to be extended to other cases, too; but how do you specify the links? If that’s just a sheet name, possibly it’s better to define sheet name together with a cell in it, like 'C'.A1? Because naming sheets does not have such a limitation…

1 Like

Hey Mike,

Wow! Much thanks for this solution.
I renamed the sheets back to just C and R, but changed the hyperlink targets to C.A1 and R.A1. Now it works as it should.

Dan