How kuti musara muna Excel mutsetse, kuvaita uye kugadziridza nokukwirira?

Microsoft Excel Software kwakakurumbira chaizvo nokuda kwayo kusiyana. Chikumbiro ichi chinogona kushandiswa munyaya zvose yebasa. Excel haagoni chete kushanda nenhamba, asiwo kupa mashoko ari muchimiro calculators nemachati. Vamiririri ounyanzvi hwokugadzira siyana yakawanda basa kunze chaiyo nokuda chirongwa ichi.

Anenge zvose PC vanoshandisa vanotarisana kudiwa kunoshanda Microsoft Excel. Nyaya dzakadai mutsetse nenzvimbo, otomatiki chiverengero, kana kuti kuita musara muna Excel mutsetse, zvikuru akakodzera.

Ndichishanda Excel: kuwanda mitsetse vavo urefu

Mumwe shanduro kunoda imwe nhamba mitsara. In MS Excel 2003, unogona kushandisa 65.536 mitsetse, uye muna MS Excel 2010 - kare 1.048.576.

Shoko rokuti "urefu tambo" rinosanganisira nuances maviri. chakarurama ichi kuyerwa kwenhamba masero uye uwandu mabhii kuti zvingaonekwa apinda muchitokisi.

In MS Excel 2003, nhamba mbiru ndiyo 256. The zvikuru mikana kupa MS Excel 2010 - 16 384 masero.

shanduro Vose vane nhamba pazvinhu muchitokisi, inova 32.767 vatambi. Muchitokisi, vatambi izvi zvose, Chokwadi, haichaonekwi, asi vanogona kuonekwa fomura kubhawa.

Sei pinza uye zvinomuomera kuikanganwa misara muna Excel?

Kuti vagadzirise dambudziko nenzira mbiri:

• Kushandisa akapoteredza Muterere. Zvakakodzera pfungwa chaiyo nzvimbo papi zvichabviswa riri, uye ipapo shandisa zvakanaka mbeva bhatani kuti tinya Muterere. Pashure pakanzi "Insert" "Line" rinowanika. Zvakakodzera kusimbisa chakaitwa nekudzvanya "OK".
• Kuburikidza control panel. Unofanira kusarudza nzvimbo kuti mutsetse uye control panel kuwana "Main" Tab, baya "Insert" uye zvadaro "Insert Row".

Deleting misara rinoitwa nenzira yakafanana, asi pachinzvimbo chacho "Isa" zvinokosha tinya "Kudzima."

Napamusara nokukwirira Excel

parameter ichi inodzorwa nenzira dzakawanda. Kupfuura nyore uye nyore - zviri kuchinja kukwirira nokushandisa mbeva. The cursor inofanira kuiswa mutsetse vaverengwa, uye ipapo vanobatisisa bhatani, utambanudzire kana tsonyera pasi kusvika aenzana.

Uyewo anogona kushandura kukwirira pachishandiswa control panel. Mu "Home" kusarudza "Format" uye zvadaro baya "Row Height". Pahwindo uchida kutaridzwa kukosha kuti uchida neimwe nyaya.

shanduro Vose zvinoda otomatiki pakusarudza musara kukwirira. Izvi zvinokosha kana uchida kushandura pazviruva maererano rugwaro uripo. Zvisinei, kana kushandisa basa iri, unofanira kuziva kuti murayiro zvichabviswa kuurayiwa chete kana bhokisi riri wamaka "putira" mu "Alignment" Tab. The kunonyanyisa yakakwirira anogona kuiswa - zviri 409 tsika.

The muzvikwata zvisina tsarukano kuti mitsara iri Excel

Kana zvakakodzera, mapoka mitsetse vanofanira kusarudza pavari uye kuenda "Data" Tab. Kuchava vanofanira kusarudza "Structure" - "Group".

Ungrouping misara nomuenzaniso, chete tinya "Usakumbanidze".

Uye kana uchida mitsetse mishomanana?

Vanhu vazhinji vanofarira sei kuti musara muna Excel mutsetse. Panewo hapana hombe. Kuti muna Excel mashomanana mitsetse mumutsetse, unofanira kushandisa kiibhodhi yokudimbudzira alt + Enter. Kutamisirwa achange chinozoiswa zvakananga muchitokisi, vachipinza mashoko pakombiyuta mberi ane ndima.

mitsetse zvakavanzika uye kwavakazoita Mapping

Dzimwe kana tichishanda pamwe Excel Chirongwa, zvakakodzera kuvanza pemitsara. Izvi zvinogona kuitwa kushandisa zvakanaka mbeva bhatani. Mushure kudana akapoteredza Muterere, sarudza "Hide" pashure yaakasarudza zvimwe zvimedu.

Kana apo uchida kuratidza zvakavanzika mumitsara, kuti chiito chinofanira sezvinotevera: wasarudza zvakafanira zvidimbu kunombata kunyange vari pamusoro kana pazasi kuchiitirwa siyana. Zvadaro, pashure nekudzvanya zvakarurama mbeva bhatani, uchaona chechinyorwa Muterere apo uchifanira sarudza "Show".

Concatenation pamwe Excel

Paaisika matafura kunokosha chine kuti rinopindura batanidza masero. Kwaizvozvi, yakananga nzvimbo uye wasarudza Tab zvaunoda sarudza "Home", ipapo mashandiro "Kubatanidza" uye "Kutamira pakati." Kana zvakakodzera, unogona kusarudza dzimwe nzira kuti abatane. Zvino kuti munoziva kuti musara muna Excel mutsetse uye kushandisa navo. Ona kuti matanho aya anokosha angapedze matambudziko ari chirongwa kupiwa.

Panzira, kana iwe ukaita matanho zvakare, rapfuura murayiro zvichabviswa wacho.

Chii makro uye chii vari pamusoro?

vanozvishandisa vakawanda vasangana rokuti "makro", asi kwete vose vanoziva kuti chii. A makro iri purogiramu ine mirayiridzo uye zviito kuti - panguva chikumbiro kana kwete - inogona kuratidzwa zvakananga kana kuti zvisina kunanga.

Macro rakanyorwa programmers kana vanoshandisa achitirega zvisina kukwana michina kuderedza nguva inodiwa kupedza basa.

Kana tichishanda pamwero mukuru uye bhuku nemashoko kune kupatsanurwa, munhu inopedzera nguva yakawanda ari nezviito yokudzokorora.. Itai imwe makro achakwanisa kuita zvinhu zvakadai pamusoro yavo, Excel User uchaponesa maawa kushanda. Uyezve, zvakanaka-akagadzirirwa Mini-chirongwa anokwanisa Detective zvokuimba kukanganisa zvose, izvo zvinoita kuvhiyiwa yamunenge uye nyore.

makro ngozi

Kushandisa macro inozviisa zvimwe njodzi. Anonyengera programmer anogona kusika utachiona, nacho sezvo makro kuti uchaparadza ose Data uye kukonzera atadze kushanda zvakanaka. Uyezve, chirongwa ichi inogona kushanda sezvo musori nokuverenga zvose mashoko.

wrapping

Kutamisirwa Excel mitsetse zvinogona kuitwa nenzira dzakawanda. Kana apo unofanira kupinda yakawanda vatambi, unogona kuisa chirongwa basa "Inoyerera chinyorwa mumasero pedyo." Ipapo mashoko achapiwa uratidzwe pamusoro vakawanda pemitsara.

Long Rugwaro zvinogona kurapwa zvokuti akaiswa mubhokisi. Kuti aite izvi, kusarudza Tab "Insert" uye zvadaro "Text" uye "Caption". Zvadaro unogona kutanga achitaipa. Mundima bhokisi, zvinokwanisika kuita formatting ari akanyudzwa zvinhu pasina panotaurwa pamiganhu.

Nyore nzira kuenda mumutsara muna Excel, - ndiko kuibvisa pamwe mbeva. Zvakakodzera kutamisira cursor kuti sero kusarudzwa uye mubatirire kuruboshwe mbeva bhatani, anodhonzera kusarudzwa munzvimbo imwe nzvimbo itsva. Vakwanise chikamu ichi, iwe unogona mu "Options" - "Advanced".

Kuziva sei kuti musara muna Excel mutsara uye kuva nedzimwe unyanzvi zvinoshanda, iwe uchava zvachose kuti zvive nyore kushanda nepurogiramu uye kuwedzera kwezvinhu, kunze basa nguva.