问题描述
我想在Excel中创建一个序列，以便当我拖动角手柄时，地址也可以交替增加.例如，如果我在一个单元格中写入"= D3"，在其相邻的右单元格中写入"= D4"，然后导入该序列，则当我拖动手柄，以便它应该像"= D3"下面那样填充系列，该系列应像"= D5"然后是"= D7"，以此类推.类似地，在"= D4"下方，序列应类似"= D6"，然后是"= D8"，依此类推.以此类推.但是它填充的序列是"= D3"，然后是"= D4"，然后是"= D5".我不要这个.
我该怎么办?
谁能帮我解决问题.
预先感谢.
Hi,
I want to make a series in Excel such that when i drag the corner handle so addresses increment alternatively.For example if i write "=D3" in one cell and "=D4" in its adjacent right cell and i import this series so when i drag the handle so it should fill series alternatively like below "=D3" the series should be like "=D5" then "=D7" and so on vertically. similarly below "=D4" the series should be like "=D6" then "=D8" and so on vertically.But it is filling series like "=D3" then "=D4" then "=D5". I don''t want this.
how can i do this?
Can anyone help me how to fix it.
Thanx in advance.
推荐答案
这篇关于如何在Excel中制作替代数字系列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！