0

As explained in this other Answer, SheetName!A1 = cell A1 in the worksheet called "SheetName" (without quotations).

Say the name for my worksheet is very long. Without shortening "SheetName" and writing out expressly "SheetName", what's a more efficient way to refer to it? Is it possible to designaet "SheetName" by "S" and then input S!A1?

Community
  • 1

2 Answers2

1

No, that's not possible in a formula. If you have a long sheet name, wrap it in single quotes -

'this sheet name is huge'!A1

Raystafarian
  • 21,963
  • 12
  • 64
  • 91
1

You can create named ranges in Excel, which are like aliases.

If you select a single cell or a range of cells, go to the text box to the left of the formula bar. By default, it will display the generic name of the currently selected cell, such as C5. However, you can type a simple name into this box and press enter to give the cell a name, and then use that name in formulas.

For example, you can go to cell A1 on Sheet1, and name it "Profits". Then on Sheet2, you can specify B3 to be =Profits*2, and then Sheet2!B3 will always have twice the value of Sheet1!A1

Darth Android
  • 38,658