Google Sheets tam sim no txhawb macros
Google Sheets tam sim no txhawb macros
Anonim

Koj tuaj yeem tsim ib ntu ntawm kev ua thiab khaws cia rau tom qab siv.

Google Sheets tam sim no txhawb macros
Google Sheets tam sim no txhawb macros

Google tau tshaj tawm qhov hloov tshiab loj rau Google Sheets. Nws lub ntsiab feature yog steel. Lawv tso cai rau koj kom txuag sequences ntawm kev ua kom koj tsis tas yuav ua lawv manually.

Cov haujlwm tshiab yog nyob rau hauv "Tools" tab. Koj yuav tsum xaiv "Macros" thiab nyem "Record Macro". Tom qab ntawd, koj mus dhau tag nrho cov kab ke ntawm kev ua thiab txuag nws. Tom qab ntawd, rov ua nws, koj tsuas yog yuav tsum tau khiav lub macro.

macro
macro

Thaum koj ntxiv ib qho macro, Google Apps tsab ntawv yuav raug tsim. Yog li ntawd, yog tias xav tau, nws tuaj yeem hloov kho los ntawm cov ntawv sau hauv tib lub "Tools" tab.

Lub tuam txhab tau ua ntau yam kev hloov pauv rau Google Sheets. Ntxiv qhov muaj peev xwm ntxiv cov nplooj ntawv so rau cov ntawv luam ntawv thiab tig cov cell mus rau hauv lub thawv ntawv, kev txhawb nqa rau cov ntawv loj, cov kev xaiv tshiab rau kev faib cov kab thiab kab. Tam sim no nws tseem tuaj yeem pab pawg cov ntaub ntawv hauv cov lus pivot los ntawm lub lim tiam, hli thiab xyoo.

kem pawg
kem pawg

Cov kev tsim kho tshiab no yuav dhau los ua muaj rau txhua tus neeg siv hauv lub lis piam tom ntej.

Pom zoo: