Cach loai bo ban ghi trung lp hoc tao danh sach ban ghi duy nht trong Excel

D?ch tiu ? D?ch tiu ?
ID c?a bi: 262277 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

TM T?T

Khi Microsoft Excel nhp hoc kt hp nhiu ban ghi, co th tao cac ban sao. Bai vit nay m ta cach tao mt danh sach ban ghi duy nht a bin dich.

THNG TIN THM

tao mt danh sach ban ghi duy nht a bin dich, lam theo cac bc sau:
  1. Chon tiu ct trn hang hoc ban ghi ban mun sp xp.
  2. Trn menu D liu, tro chut ti B loc, ri bm B loc Chuyn su. Nu ban c nhc nh sau, bm OK.
    Khng tim tiu . Coi hang trn cung muc chon la hang tiu ?
  3. Di Hanh ng, bm Sao ti vi tri khac.
  4. Bm chon hp kim Chi ban ghi duy nht.
  5. Trong Pham vi danh sach, go hoc chon pham vi ban ghi (chng han nh A3:H10).
  6. Trong Pham vi tiu chi, go hoc chon cung pham vi ban ghi (o la, A3:H10).
  7. Trong Sao ti, go ia chi hoc chon u tin ban mun t thng tin. Hay chc rng co u khoang trng khng ghi e d liu co sn.

    Chu y Ban chi co th thc hin trn trang hin hoat.
  8. Bm OK.
Chu y

Nu ban ghi u tin cua d liu gc c nhn ban, ban ghi xut hin hai ln trong danh sach mi. Chi cn n dong u.

Nu ban thc hin lnh B loc Chuyn su tai ch, trang tinh nay vn cha tt ca ban ghi. n ban ghi trung lp. khc phuc hanh vi nay, tro chut ti Hang trn menu inh dang, ri bm Bo n.

Thu?c tnh

ID c?a bi: 262277 - L?n xem xt sau cng: 13 Thang Nm 2008 - Xem xt l?i: 4.2
p d?ng
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
T? kha:
kbhowto KB262277

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com