1. 首页 > 精选资讯 > 文章页面

excel如何配对名字(excel如何配对不同列名称)

Excel
is
a
powerful
tool
that
can
be
used
for
various
tasks,
including
pairing
names
together
to
create
a
list.
In
this
article,
we'll
explore
how
to
use
Excel
to
pair
names
and
create
a
list
of
paired
names.
To
begin
with,
open
Microsoft
Excel
and
create
a
new
spreadsheet.
In
the
first
row,
type
the
names
that
you
want
to
pair
together
in
separate
cells.
For
example,
if
you
have
a
list
of
people
you
want
to
pair,
type
their
names
in
the
first
row.
Next,
in
the
second
row,
type
the
name
of
the
person
you
want
to
pair
the
name
in
the
first
row
with.
For
example,
if
you
want
to
pair
the
first
name
in
the
first
row
with
the
third
name
in
the
first
row,
type
the
third
name
in
the
second
row.
To
make
sure
that
each
name
is
paired
with
another
name,
create
a
formula
that
matches
the
names
in
the
first
and
second
rows.
To
do
this,
select
the
cell
next
to
the
first
name
in
the
first
row,
and
type
"="
followed
by
the
cell
containing
the
corresponding
name
in
the
second
row.
For
example,
if
you
want
to
pair
the
first
name
in
the
first
row
with
the
third
name
in
the
second
row,
select
the
cell
next
to
the
first
name
in
the
first
row,
type
"=",
and
then
select
the
cell
containing
the
third
name
in
the
second
row.
After
you've
created
the
formula
for
the
first
pair
of
names,
copy
and
paste
it
into
the
cells
next
to
the
remaining
names
in
the
first
row.
This
will
automatically
pair
each
name
in
t{『领略更多 星座运程常识请关注 :星缘网,wWw.ixINGyuAN.CC』)he
first
row
with
the
corresponding
name
in
the
second
row.
Now
that
you
have
created
your
paired
list
using
Excel,
you
can
save
and
share
it
with
others.
You
can
also
use
the
list
for
various
purposes,
such
as
randomly
pairing
people
for
group
activities
or
creating
a
list
of
potential
business
partners.
In
conclusion,
Excel
is
a
powerful
tool
that
can
be
used
to
pair
names
and
create
lists
for
various
purposes.
By
following
the
simple
steps
outlined
in
this
article,
you
can
easily
create
a
paired
list
of
names
using
Excel.

联系我们

Q Q:

微信号:

工作日:9:30-18:30,节假日休息

微信