How to refer to cell formulas

How to reference cells in formulas

How to reference cells in EXCEL formulas

All references can be entered directly, but it is a little troublesome. You can directly click the reference cell to generate the reference cell address. It is the same as the worksheet reference. Click the corresponding cell, such as: =A1 B1, click A1 first. cell, then click the " " sign on the keyboard, and then click cell B1 to generate the calculation formula.

Recommended tutorial: excel tutorial

Cross-sheet reference is to follow the worksheet label with an English "!" and add To reference a cell, you can also click the worksheet label first, and then click the reference cell.

If you input directly, when the worksheet label contains characters such as numbers, spaces, etc., the label needs to be added with a pair of English single quotes.

#When the referenced data is not in the same workbook, you need to enclose the external workbook name with "[ ]", followed by the worksheet label, "!", and then When adding reference cells, when the worksheet label contains characters such as numbers, spaces, etc., you also need to add a pair of English single quotes.

If the referenced external workbook is closed, you must also add the path before the workbook, and add English single quotes from the path to the worksheet label.

Regardless of whether the external workbook is open or closed, when you click on the reference directly, it is an absolute reference. You can determine whether you need to remove the absolute reference character "$" as needed.

When you want to reference an external workbook, you can only directly click to reference the cells in the workbook when you open the workbook from the "Open" command in the "File" tab.

The above is the detailed content of How to refer to cell formulas. For more information, please follow other related articles on the PHP Chinese website!