Question

如何在excel中设置能在一列以及一行一起使用的公式？

Answer 1

充分理解你的问题，我也经常会有这种要求，操作为：

1、选中一列（整列选取）
2、输入公式
3、敲 Ctrl+回车 完成公式输入

行的操作也一样，只有第一步不同

Answer 2

比较常用的英文问候语句
wish
you
success
in
your
career
and
happiness
of
your
family!
事业成功，家庭美满!
请多保重！
take
good
care
of
yourself
in
the
year
ahead.
祝你今后获得更大成就。
wishing
you
many
future
successes.
good
luck,
good
health,
hood
cheer.
i
wish
you
a
happy
new
year.祝好运、健康、佳肴伴你度过一个快乐新年。
i
hope
you
have
a
most
happy
and
prosperous
new
year.
谨祝新年快乐幸福，大吉大利。
with
the
compliments
of
the
season.
祝贺佳节。
may
the
season's
joy
fill
you
all
the
year
round.
愿节日的愉快伴你一生。
season's
greetings
and
best
wishes
for
the
new
year.
祝福您，新年快乐。
please
accept
my
season's
greetings.
请接受我节日的祝贺。
to
wish
you
joy
at
this
holy
season.
wishing
every
happiness
will
always
be
with
you.
恭祝新年吉祥，幸福和欢乐与你同在。
good
health,
good
luck
and
much
happiness
throughout
the
year.
恭祝健康、幸运，新年快乐。
may
the
joy
and
happiness
around
you
today
and
always.
愿快乐幸福永伴你左右。
please
accept
my
sincere
wishes
for
the
new
year.
i
hope
you
will
continue
to
enjoy
good
health.
请接受我诚挚的新年祝福，顺祝身体健康。
allow
me
to
congratulate
you
on
the
arrival
of
the
new
year
and
to
extend
to
you
all
my
best
wishes
for
your
perfect
health
and
lasting
prosperity.
恭贺新禧，祝身体健康、事业发达。
best
wishes
for
the
holidays
and
happiness
throughout
the
new
year.
恭贺新禧，万事如意。
with
very
best
wishes
for
your
happiness
in
the
new
year.
致以最良好的祝福，愿你新年快乐幸福。
please
accept
our
wishes
for
you
and
yours
for
a
happy
new
year.请接受我们对你及你全家的美好祝福，祝你们新年快乐。
may
the
coming
new
year
bring
you
joy,
love
and
peace.
愿新年为你带来快乐，友爱和宁静。
wishing
you
happiness
during
the
holidays
and
throughout
the
new
year.
节日快乐，新年幸福。
season's
greetings
and
sincere
wishes
for
a
bright
and
happy
new
year!
献上节日的问候与祝福
,
愿你拥有一个充满生机和欢乐的新年。
i
give
you
endless
brand-new
good
wishes.
please
accept
them
as
a
new
remembrance
of
our
lasting
friendship.
给你我无尽的新的祝福，让它们成为我们永恒友谊的新的纪念。
good
luck
and
great
success
in
the
coming
new
year.
祝来年好运，并取得更大的成就。

Answer 3

你在一个单元格里设置完公式后 拖拉该单元格 要一排使用就横着拉 一列就下拉 和拖拉时间或序号一样

Answer 4

在一个格中设置一个公式
再吧鼠标放到格的右下角，变成十字形的时候直接托拉到你想覆盖的范围就行了