Ba shi daɗi sosai lokacin da, saboda wutar lantarki, daskarewar kwamfuta ko wata matsala, bayanan da ka buga a cikin teburin amma basu da lokacin ajiyar. Bugu da kari, koyaushe yana adana sakamakon aikin su - wannan yana nufin nishadantar da kai daga babban darasi da rasa karin lokaci. Abin farin, Excel yana da irin wannan kayan aiki mai dacewa kamar autosave. Bari mu gano yadda ake amfani da shi.
Aiki tare da saitunan adanawa
Don kare kanka da kanka daga asarar bayanai a cikin Excel, ana bada shawara don saita saitunan adreshin naka mai amfani wanda zai dace musamman don bukatunku da damar tsarin ku.
Darasi: Adanawa cikin Microsoft Word
Je zuwa saiti
Bari mu gano yadda za a iya shiga saitunan adana kansu.
- Bude shafin Fayiloli. Bayan haka, matsa zuwa sashin "Zaɓuɓɓuka".
- Taga zabin na Excel yana buɗewa. Mun danna kan rubutun a sashin hagu na taga Adanawa. Anan ne za a sanya duk saitunan da muke buƙata.
Canja saiti lokacin
Ta hanyar tsoho, ana kunna autosave kuma ana yin kowane minti 10. Ba kowa ne ya gamsu da irin wannan lokacin ba. Tabbas, a cikin mintuna 10 zaka iya tattara bayanai masu yawa kuma ba a son ka rasa su tare tare da sojojin da kuma lokacin da aka kashe akan tebur. Sabili da haka, yawancin masu amfani sun fi son saita yanayin ajiyewa zuwa mintuna 5, ko ma minti 1.
Minti 1 kacal shine mafi guntun lokacin da za'a iya saitawa. A lokaci guda, wanda ya isa ya manta cewa yayin ceton tsarin ana cinye albarkatun, kuma akan kwamfutocin jinkirin da gajere lokacin shigarwa na iya haifar da ma'amala a cikin saurin aiki. Saboda haka, masu amfani waɗanda ke da tsoffin na'urori suna zuwa ɗayan matsanancin gabaɗaya - suna kashe kullun ta atomatik. Tabbas, wannan ba bu mai kyau a yi ba, amma, duk da haka, zamuyi dan dan kara magana kan yadda za'a kashe wannan aikin. A yawancin kwamfutocin zamani, koda kun saita lokacin zuwa minti 1, wannan ba zai tasiri aikin tsarin ba.
Don haka, don canza lokaci a fagen "Ajiye kowane" shigar da yawan adadin da ake so. Dole ne ya kasance cikin lamba kuma ya kasance cikin kewayon daga 1 zuwa 120.
Canza wasu saitunan
Bugu da kari, a cikin tsarin saitin zaka iya canza wasu sigogi daban daban, kodayake ba a ba su shawarar su taɓa su ba tare da buƙatar da ba dole ba. Da farko dai, zaku iya tantance wane tsari ne za a ajiye fayiloli ta atomatik. Ana yin wannan ta hanyar zaɓin sunan da ya dace a cikin filin sigogi "Adana fayiloli a wannan tsari". Ta hanyar tsoho, wannan littafi ne na Work Work (xlsx), amma zaka iya canja wannan fadada zuwa mai zuwa:
- Littattafai na kwarai 1993-2003 (xlsx);
- Littafin aikin Excel da goyan bayan macro;
- Samfura mai kyau
- Shafin gidan yanar gizo (html);
- Rubutun rubutu (txt);
- CSV da sauransu da yawa.
A fagen "Mayar da bayanan dawo da bayanai" yana tsara hanyar da aka adana kwafin fayilolin adanawa. Idan ana so, ana iya canza wannan hanyar da hannu.
A fagen "Wurin fayil na asali" yana nuna hanyar zuwa directory ɗin da shirin ke bayarwa don adana fayilolin asali. Wannan babban fayil ɗin yana buɗewa lokacin da kake danna maballin Ajiye.
Kashe aiki
Kamar yadda aka ambata a sama, kwafin ajiya na atomatik za a iya kashe shi. Don yin wannan, kawai ɓoye abin "Ajiye kowane" kuma danna maballin "Ok".
A gefe guda, zaka iya kashe ajiyayyar sigar karshe ta karshe lokacin rufewa ba tare da adanawa ba. Don yin wannan, cire alamar saiti daidai.
Kamar yadda kake gani, gabaɗaya, saitunan adana bayanai a cikin Excel masu sauƙi ne, kuma ayyukan da suke tare da su suna da hankali. Mai amfani da kansa, la'akari da bukatunsa da ƙarfin kayan aikin komputa, na iya saita adadin ta hanyar ajiye fayil ta atomatik.
