Search results
In Excel, an exclamation point is used to differentiate a sheet from a particular cell reference that’s being used in a formula. In most cases, you would see the exclamation mark is used before cell references and after sheet names in formulas.
20 lis 2014 · As Jerry says, Sheet1!A1 refers to cell A1 on Sheet1. If you create a named range and omit the Sheet1 part you will reference cell A1 on the currently active sheet. (omitting the sheet reference and using it in a cell formula will error).
21 wrz 2023 · Exclamation Point (!) to Indicate a Sheet Name The exclamation point ( ! ) is critical if you want to create a formula in a sheet and include a reference to a different sheet .
2 sie 2023 · Here are the important symbols used in Excel Formulas. Each of these special characters have used for different purpose in Excel. Let us see complete list of symbols used in Excel Formulas, its meaning and uses.
28 mar 2022 · Exclamation Point (! ) to Indicate a Sheet Name The exclamation point (!) is critical if you want to create a formula in a sheet and include a reference to a different sheet, eg =SUM(Sheet1!B2:B4)
1 lut 2019 · The exclamation mark connects the sheet name with the cell address. But if you have a case where the same named range is defined on multiple sheets, this method can be used to create a "generic" sheet reference.
16 mar 2023 · To refer to a cell or a range of cells in another worksheet, type the name of the target worksheet followed by an exclamation point (!) before the cell or range address. For example, here's how you can refer to cell A1 on Sheet2 in the same workbook: =Sheet2!A1
