Tsis tuaj yeem tso cov kab hauv excel?

Cov txheej txheem:

Tsis tuaj yeem tso cov kab hauv excel?
Tsis tuaj yeem tso cov kab hauv excel?

Video: Tsis tuaj yeem tso cov kab hauv excel?

Video: Tsis tuaj yeem tso cov kab hauv excel?
Video: cov hauv tshuaj cawm tib neeg siab phem tso dab tom 31/12/22-23 2024, Kaum ib hlis
Anonim

Sim cov hauv qab no: ntaus thawj lub xovtooj siv A1 hauv Lub Npe Lub Npe thiab nias nkag mus. Ntawm lub Tsev tab, nyem rau ntawm hom ntawv icon Xaiv Hide & Unhide los ntawm cov ntawv qhia zaub mov ces xaiv Unhide Kab. Koj yuav tsum muaj peev xwm unhide tag nrho cov kab hauv nruab nrab tom qab ntawd.

Yuav ua li cas koj qhib cov kab zais hauv Excel?

Yuav ua li cas tshem tawm txhua kab hauv Excel

  1. Txhawm rau tshem tawm tag nrho cov kab zais hauv Excel, mus rau "Tsev" tab.
  2. Click "Format," uas yog nyob rau sab xis ntawm lub toolbar.
  3. Niag mus rau ntu "Visibility". …
  4. Hover over "Hide &Unhide."
  5. Xaiv "Unhide Kab" los ntawm cov npe.

Vim li cas kuv thiaj tsis tuaj yeem zais ib daim ntawv hauv Excel?

Yog tias phau ntawv ua haujlwm tsuas muaj cov ntawv zais ntau heev, koj tseem yuav tsis tuaj yeem qhib lub thawv Unhide vim tias Unhide cov lus txib yuav raug kaw. Yog tias phau ntawv ua haujlwm muaj ob daim ntawv zais thiab zais heev, lub Unhide dialog yuav muaj, tab sis cov nplooj ntawv zais heev yuav tsis tau teev nyob ntawd.

Yuav ua li cas koj tshem tawm cov ntaub ntawv Excel?

Unhide Worksheets using the Ribbon

  1. Xaiv ib lossis ntau daim ntawv tab nyob hauv qab ntawm Excel cov ntaub ntawv.
  2. Nias lub Tsev tab ntawm kab.
  3. Xaiv hom.
  4. Click Hide & Unhide.
  5. Select Unhide Sheet.
  6. Nias daim ntawv uas koj xav tso tawm ntawm cov npe uas tshwm sim.
  7. Click OK.

Yuav ua li cas koj tshem tawm cov ntaub ntawv hauv Excel?

Txhawm rau tshem tawm tag nrho cov hlwb hauv daim ntawv ua haujlwm:

  1. Nias lub pob Xaiv Txhua, nyob rau sab sauv-sab laug ntawm daim ntawv ua haujlwm lossis nias Ctrl + A.
  2. Click the Home tab > Format (in the Cells group) > Hide & Unhide > Unhide Rows or Unhide Columns.
  3. Tag nrho cov hlwb tam sim no pom.

Pom zoo: