即使在Excel 2007中插入行，仍保持绝对的参考 [英] Keep absolute reference even when inserting rows in Excel 2007

问题描述

我有一个电子表格，我想要单元格公式总是查看一个特定的单元格，即使插入行或列，特定的单元格移动。实际上，我总是想看一下表格的顶部单元格，即使在表顶部插入新行。

eg。单元格A2具有公式[= $ E $ 2]

现在我突出显示第1行并插入行。 A2中的公式现在表示[= $ E $ 3]，但是我想要查看新行2。

美元将保持绝对单元格参考无论我对引用单元格做了什么，但是我希望单元格引用是绝对的，不管我对引用单元格做了什么。如果这是有道理的！

有效地，我在excel 2007中有一个'table'，我想始终引用顶行。麻烦的是，行从顶部添加到这个表中，所以顶行继续向下移动，为新的顶行腾出空间。

--- Alistair。 / p>

解决方案

尝试 = indirect（F2）。如果您知道表格右上角的单元格总是 $ F $ 2 。

I have a spreadsheet where I want cell formula to always look at a specific cell, even if rows or columns are inserted and the specific cell moves. Effectively, I always want to look at the 'top' cell of a table, even if new rows are inserted at the top of the table.

eg. Cell A2 has the formula[=$E$2]

Now I highlight row 1 and do Insert Row. The formula in A2 now says [=$E$3] but I want it to be looking at the new row 2.

The dollars will keep an absolute cell reference no matter what I do to the 'referencing' cell, but I want the cell reference to be absolute no matter what I do to the 'referenced' cell. If that makes sense!

Effectively, I have a 'table' in excel 2007 and I want to always reference the top row. The trouble is that rows are added to this table from the top so the top row keeps moving down to make room for a new top row.

--- Alistair.

解决方案

Try =indirect("F2"). This will work if you know that the top-right cell of the table is always going to be $F$2.

这篇关于即使在Excel 2007中插入行，仍保持绝对的参考的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！