linking a cell to a worksheet

[daveyc18]

so when i link a cell to a worksheet and see the list, i noticed some of the worksheets dont have the surrounding apostrophes and some do...why?

 

[MARK858]

Are the apostrophes only on the sheets with spaces in the sheet names?

 

[daveyc18]

Are the apostrophes only on the sheets with spaces in the sheet names?

good question, but surprisingly no

 

[MARK858]

That is a bit strange because that is what I expected (and does with my sheets)

Book2
	A	B
1	A	='Sheet 4'!A1
2	0	=Sheet2!A1
3	0	=Sheet1!A1
4	0	='aaa bbb'!A1
Sheet3

Cell Formulas
Range	Formula
A1	A1	='Sheet 4'!A1
B1:B4	B1	=FORMULATEXT(A1)
A2	A2	=Sheet2!A1
A3	A3	=Sheet1!A1
A4	A4	='aaa bbb'!A1

 

[Alex Blakenburg]

It would be easier if you show us the names with quotes.
If you name a sheet with R or C it will have single quotes too. This conflicts with RC referencing format.

 

[Fluff]

Also any names that are valid cell references, or numbers will also have apostrophes.

 

[daveyc18]

That is a bit strange because that is what I expected (and does with my sheets)

Book2
	A	B
1	A	='Sheet 4'!A1
2	0	=Sheet2!A1
3	0	=Sheet1!A1
4	0	='aaa bbb'!A1
Sheet3

Cell Formulas
Range	Formula
A1	A1	='Sheet 4'!A1
B1:B4	B1	=FORMULATEXT(A1)
A2	A2	=Sheet2!A1
A3	A3	=Sheet1!A1
A4	A4	='aaa bbb'!A1

sorry let me be clarify

when I say link, i mean right-clicking the cell, click "Link" at the bottom of the option list, then "place in document" ...all worksheet names have no spaces and start with alpha characters followed by 3 digits....some have apostrophe in that list, some dont

the reason im asking is that there are so many sheets ....so I try to type the sheet name to go directly to that sheet, but some have apostrophes so sometimes I'll need to hit the apostrophe key first....

 

[Fluff]

If there are less than 4 alpha characters then it's a valid cell reference & so you need quotes.
That said, you should be able to type-in the sheet name without quotes & it should still work.