我可以在excel 07中将结构化引用设为绝对值吗? [英] Can I make a structured reference absolute in excel 07?
问题描述
我有一个带有两列"Foo"和"Bar"的表"A".我有一个结构化引用为A [Foo]的公式.当我水平填充此公式时,我希望引用保持为A [Foo],但是现在,在第二列中,引用变为A [Bar].有没有一种方法可以使此结构化引用成为绝对引用?
I have a table "A" with 2 columns "Foo" and "Bar". I have a formula with the structured reference A[Foo]. When I fill this formula horizontally I want the reference to stay A[Foo] but now, in the second column, the reference turns to A[Bar]. Is there a way to make this structured reference absolute?
令人震惊的是,如果不支持此功能.
It'd be shocking that this isn't supported if not.
示例公式:
= A [Foo]
=A[Foo]
如果表有多列,则水平拖动并Foo更改
Drag that horizontally and Foo changes if the table has multiple columns
推荐答案
复制和拖动之间存在区别.拖动也称为填充"公式.在 Microsoft的支持网站,您将找到以下说明:
there is a difference between copying and dragging. Dragging is also called "filling" formulas. On Microsoft's support website you will find the following explanation:
移动,复制和填充结构化参考
所有结构化引用仍然是复制或移动公式时相同使用结构化引用.
All structured references remain the same when you copy or move a formula that uses a structured reference.
填写公式时,请完全合格的结构化参考可以像这样调整列说明符系列总结如下桌子.
When you fill a formula, fully qualified structured references can adjust the column specifiers like a series as summarized in the following table.
因此,这基本上意味着您看到的行为是设计使然.如果您希望引用是绝对引用,则应复制公式,而不要拖动/填充"该公式.
So it basically means that the behavior you see is by design. If you want the reference to be absolute you should copy the formula and not drag/"fill" it.
这篇关于我可以在excel 07中将结构化引用设为绝对值吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!