Cov txheej txheem:

Yuav ua li cas kuv AutoFill yam tsis formatting?
Yuav ua li cas kuv AutoFill yam tsis formatting?

Video: Yuav ua li cas kuv AutoFill yam tsis formatting?

Video: Yuav ua li cas kuv AutoFill yam tsis formatting?
Video: Tupao Xiong & Nhia Chang - Kuv Tsis Paub Yuav Ua Li Cas (Original) 2024, Kaum ib hlis
Anonim

Sau Tsis muaj Luam the Formatting

Yog koj xav siv Autofill hauv a formatted cell thiab nyiam tiv thaiv kom formatting yuav tau theej, Autofill raws li niaj zaus, ces xaiv "Fill Tsis Formatting "los ntawm Smart Tag xaiv.

Ib yam li ntawd, nws tau nug, Kuv yuav ua li cas thiaj li tsuas formatting hauv Excel?

1: Siv cov ntawv sau los luam tawm cov ntaub ntawv

  1. Xaiv lub cell uas muaj cov formatting koj xav luam.
  2. Muab ob npaug rau-nias lub xov tooj ntawm tes sau.
  3. Nyem qhov tshwm sim AutoFill Options tswj los tso saib cov npe hauv daim duab B.
  4. Xaiv qhov Fill Formatting nkaus xwb.

Ib yam li ntawd, qhov twg yog qhov pib sau cov kev xaiv hauv Excel? Yuav Siv AutoFill li cas hauv Microsoft Excel

  1. Pib ib daim ntawv tshiab. Ntxiv cov ntaub ntawv thawj zaug uas xav tau.
  2. Xaiv lub cell uas koj xav kom AutoFill. Txav tus cursor mus rau hauv qab sab xis ntawm lub cell. Nws yuav tig mus ua ib tug ntoo khaub lig.
  3. Daim ntawv ceeb toom yuav ua li cas Excel sau cov koob lub hlis rau koj tau txais. Luag tus cursor hla lub hlwb kom ntau npaum li koj xav tau.

Ib sab saum toj, dab tsi tsis muaj formatting txhais tau tias hauv Excel?

Sau Tsis Formatting Qhov no tso cai rau koj luam tawm tsuas yog qhov tseem ceeb uas nyob hauv qhov kev xaiv thawj thiab tsis yog qhov cuam tshuam formatting . Yog tias ntau tshaj ib lub xov tooj raug xaiv ces qhov sib lawv liag ntawm formatting yuav txuas ntxiv mus.

Yuav ua li cas koj AutoFill hlwb hauv Excel yam tsis muaj rub?

Sau cov lej hauv cov xovtooj sai sai yam tsis muaj rub tawm

  1. Sau 1 hauv cell A1.
  2. Mus rau Tsev -> Kho -> Sau -> Series.
  3. Hauv lub thawv sib tham Series, xaiv cov hauv qab no: Series hauv: Kab. Hom: Linear. Kauj Ruam Tus Nqi: 1. Nres Tus Nqi: 1000.
  4. Nyem OK.

Pom zoo: