Siv Excel Shortcut Keys kom txuag koj txoj haujlwm sai

Cov txheej txheem:

Siv Excel Shortcut Keys kom txuag koj txoj haujlwm sai
Siv Excel Shortcut Keys kom txuag koj txoj haujlwm sai
Anonim

Koj tau ua haujlwm ntau rau hauv koj daim ntawv Excel, tsis txhob cia nws plam vim koj tsis nco qab khaws nws. Siv cov lus qhia no kom koj txoj haujlwm nyab xeeb thiab khaws cia rau lwm zaus koj xav tau cov ntaub ntawv tseem ceeb ntawd. Thaum koj xav qhia koj txoj haujlwm, khaws phau ntawv ua haujlwm hauv PDF hom.

Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010; Excel rau Microsoft 365, thiab Excel rau Mac.

Siv Excel Txuag Shortcut Keys

Muaj peb txoj hauv kev txuag cov ntaub ntawv hauv Excel:

  • Xaiv File > Save As. Hauv Excel 2019, xaiv File > Save a Copy.
  • Xaiv Txuag ntawm qhov Quick Access Toolbar.
  • Siv tus Ctrl+ S tus yuam sij luv.

Yog tias koj ua haujlwm ntawm Mac, siv tus yuam sij hais kom hloov tus yuam sij tswj.

Image
Image

Yog tias cov ntaub ntawv tau txais kev cawmdim ua ntej, tus pointer hloov mus rau lub cim teev teev thaum lub sijhawm khaws cia. Yog tias phau ntawv ua haujlwm tau txais kev cawmdim thawj zaug, Save As dialog box qhib.

Thawj Sijhawm Txuag

Thaum ib cov ntaub ntawv tau txais kev cawmdim thawj zaug, ob daim ntaub ntawv yuav tsum tau teev tseg rau hauv lub thawv Txuag Raws li dialog box. Sau ib lub npe rau cov ntaub ntawv thiab xaiv qhov chaw uas nws yuav tau txais kev cawmdim.

Cov npe cov ntaub ntawv tuaj yeem muaj txog 255 cim nrog rau qhov chaw.

kab hauv qab

Siv Ctrl+S yog txoj hauv kev yooj yim los khaws cov ntaub ntawv. Siv qhov shortcut no nquag, tsawg kawg txhua tsib feeb, kom tsis txhob poob cov ntaub ntawv.

Pin Save Locations

Yog tias koj qhib qee cov ntaub ntawv lossis cov folders nquag hauv Excel, pin lawv rau koj cov npe ntawm cov ntaub ntawv qhib tsis ntev los no. Qhov no ua rau qhov chaw nkag tau yooj yim nyob rau sab saum toj ntawm cov npe Tsis ntev los no.

Tsis muaj kev txwv rau tus lej ntawm qhov chaw tuaj yeem pinned. Txhawm rau pin qhov chaw txuag:

  1. To pin a folder, xaiv File > Save As.

    Image
    Image
  2. Xaiv Recent thiab, ntawm sab xis ntawm lub qhov rais, txav mus rau ntawm phau ntawv ua haujlwm lossis ntawv tais ceev uas koj xav tau pin. Ib daim duab me me kab rov tav ntawm lub laub tus pin tshwm rau qhov chaw ntawd.

    Image
    Image
  3. Xaiv tus pin rau qhov chaw ntawd. Cov ntawv tais ceev tseg tau tsiv mus rau Pinned daim ntawv teev npe thiab kab rov tav laub tus pin hloov mus rau ntsug laub tus pin.

    Image
    Image
  4. Txhawm rau tshem tawm qhov chaw, xaiv qhov ntsug thawb tus pin hloov nws rov qab mus rau kab rov tav tus pin thiab tshem tawm ntawm daim ntawv Pinned.

kab hauv qab

Thaum koj xav tau daim ntawv theej ntawm daim ntawv ua haujlwm lossis tag nrho phau ntawv ua haujlwm uas tsis muaj leej twg tuaj yeem hloov kho thiab txhua tus tuaj yeem saib, hloov lossis khaws koj cov ntaub ntawv Excel hauv hom PDF. Ib cov ntaub ntawv PDF (Portable Document Format) tso cai rau lwm tus saib cov ntaub ntawv yam tsis xav tau cov haujlwm qub, xws li Excel, ntsia hauv lawv lub computer. Hloov chaw, cov neeg siv qhib cov ntaub ntawv nrog cov ntawv nyeem PDF pub dawb xws li Adobe Acrobat Reader.

Txuag Daim Ntawv Ua Haujlwm Ua Haujlwm hauv PDF hom

Thaum khaws cov ntaub ntawv hauv PDF, los ntawm lub neej ntawd tsuas yog daim ntawv tam sim no, lossis daim ntawv ua haujlwm (cov ntawv ua haujlwm ntawm lub vijtsam), tau txais kev cawmdim.

Txhawm rau txuag daim ntawv ua haujlwm Excel hauv PDF hom:

  1. Xaiv File.

    Image
    Image
  2. Xaiv Save As txhawm rau qhib Txuag Raws li qhov rai.

    Image
    Image
  3. Xaiv qhov chaw koj xav khaws cov ntaub ntawv.

    Image
    Image
  4. Tau lub npe rau cov ntaub ntawv.

    Image
    Image
  5. Xaiv tus Save as type nqes xub.

    Image
    Image
  6. Scroll los ntawm cov npe mus nrhiav thiab xaiv PDF (.pdf).

    Image
    Image
  7. Xaiv Save txhawm rau khaws cov ntaub ntawv hauv PDF thiab kaw lub qhov rais.

    Image
    Image

Txuag Phau Ntawv Qhia Tag Nrho hauv PDF Format

Lub neej ntawd Txuag Raws li kev xaiv tsuas yog txuag daim ntawv ua haujlwm tam sim no hauv PDF hom. Ua raws li cov kauj ruam no txhawm rau txuag koj phau ntawv ua haujlwm tag nrho ua ib daim ntawv PDF:

  1. Xaiv File> Save As.

    Image
    Image
  2. Xaiv Browse txhawm rau qhib lub thawv Txuag Raws li dialog.

    Image
    Image
  3. Xaiv Txuag li hom txhawm rau qhib cov npe poob thiab xaiv PDF. Cov Options khawm tshwm nyob rau hauv Txuag As dialog box.

    Image
    Image
  4. Xaiv Options txhawm rau qhib lub Options dialog box.

    Image
    Image
  5. Xaiv Tag Nrho Cov Ntawv Ua Haujlwm hauv Tshaj Tawm Dab Tsi.

    Image
    Image
  6. Xaiv OK rov qab mus rau lub thawv Txuag Raws li dialog.

    Image
    Image
  7. Xaiv Txuag txhawm rau khaws phau ntawv ua haujlwm hauv PDF thiab kaw lub thawv sib tham.

AutoSave rau OneDrive

Yog tias koj siv Microsoft 365, Excel cia li txuag koj txoj haujlwm thaum koj xaiv khaws cov ntaub ntawv rau koj tus account OneDrive huab cia. Thaum koj cov ntaub ntawv raug cawm rau OneDrive, cov ntaub ntawv tau txais kev cawmdim txhua ob peb vib nas this, tshem tawm qhov xav tau rau koj txuas ntxiv xaiv Txuag lossis siv cov yuam sij luv.

Rau AutoSave muaj nuj nqi ua haujlwm, txuag cov ntaub ntawv rau qhov chaw nyob hauv koj OneDrive nplaub tshev. Lub AutoSave muaj nuj nqi tsis ua haujlwm nrog txhua qhov chaw ntawm koj lub PC lossis Mac.

Yog tias koj muaj Microsoft 365 thiab txuag koj cov ntaub ntawv rau OneDrive, pab kom AutoSave los ntawm kev xaiv qhov hloov pauv nyob rau sab saum toj-sab laug ntawm lub vijtsam Excel. Thaum enabled, qhov hloov yuav hais tias On. Txhawm rau tua cov yam ntxwv thiab txuag koj txoj haujlwm manually, hloov mus rau Off.

Pom zoo: