darasin zabin tebur a cikin Excel

An tsara shirin Excel don yin lissafin lissafin lissafi daban-daban, ƙirƙirar tebur, jadawalai da sigogi. Don yin kowane ayyuka tare da tebur, dole ne ku iya zaɓar shi daidai.

Dangane da girman teburin, kasancewar kowane ƙima a cikin yankuna makwabta, akwai zaɓuɓɓuka 3 don zaɓar tebur a cikin Excel. Don zaɓar mafi karɓuwa, wajibi ne a yi la'akari da kowannensu dalla-dalla.

Zabin 1: haskaka tebur tare da linzamin kwamfuta

Hanyar ita ce mafi sauƙi kuma mafi kowa. Amfaninsa, ba shakka, sauƙi ne da fahimta ga ɗimbin masu amfani. Rashin ƙasa shine gaskiyar cewa wannan zaɓin bai dace ba don rarraba babban tebur, amma, duk da haka, yana da amfani.

Don haka, don zaɓar tebur ta wannan hanyar, kuna buƙatar danna maɓallin linzamin kwamfuta na hagu, sannan ku riƙe shi, zaɓi yankin tebur gaba ɗaya daga kusurwar hagu na sama zuwa kusurwar dama ta ƙasa.

Bugu da ƙari, za ku iya fara zaɓar da motsa linzamin kwamfuta duka daga kusurwar hagu na sama da kuma daga kusurwar dama na ƙasa, zaɓin diametrically kishiyar ɗaya a matsayin batu na ƙarshe. Daga zabin farkon da ƙarshen maki, ba za a sami bambanci a sakamakon ba.

Zabin 2: hotkeys don zaɓar

Don zaɓar manyan tebur, ya fi dacewa don amfani da gajeriyar hanyar keyboard "CTRL + A" ("Cmd + A" - don macOS). Af, wannan hanya tana aiki ba kawai a cikin Excel ba, har ma a wasu shirye-shirye.

Lura cewa don zaɓar tebur ta amfani da wannan hanyar, akwai ƙaramin nuance - a lokacin da aka danna maɓallan zafi, dole ne a sanya siginan linzamin kwamfuta a cikin tantanin halitta wanda ke cikin ɓangaren tebur. Wadancan. don samun nasarar zaɓar yankin tebur gabaɗaya, kuna buƙatar danna kowane tantanin halitta a cikin tebur kuma danna haɗin maɓallin “Ctrl + A” akan maballin.

Danna maɓallan zafi iri ɗaya zai sake zaɓar duk takardar.

Idan an sanya siginan kwamfuta a wajen tebur, latsa Ctrl+A zai zaɓi dukan takardar tare da tebur.

Zabin 3: Zaɓi tare da maɓallin Shift

A cikin wannan hanyar, matsaloli kamar yadda suke a hanya ta biyu bai kamata su tashi ba. Kodayake wannan zaɓin zaɓin yana ɗan tsayi kaɗan dangane da aiwatarwa fiye da amfani da hotkeys, ya fi dacewa a wasu lokuta, kuma ya fi dacewa fiye da zaɓi na farko, wanda aka zaɓi tebur ta amfani da linzamin kwamfuta.

Don zaɓar tebur ta wannan hanyar, dole ne ku bi hanya mai zuwa:

1. Sanya siginan kwamfuta a saman tantanin hagu na tebur.
2. Riƙe maɓallin Shift kuma danna maɓallin ƙasa na dama. Sannan zaku iya sakin maɓallin Shift.
3. Idan tebur ya yi girma da yawa don dacewa da allon, da farko sanya siginan kwamfuta a kan tantanin farawa, sannan gungura ta cikin tebur, nemo ƙarshen ƙarshen, sannan bi matakan da ke sama.

Don haka, za a zaɓi dukan teburin. Ana iya yin alama ta amfani da wannan fasaha duka a cikin jagorar da ke sama da kuma a gaba. Wadancan. maimakon tantanin hagu na sama, zaku iya zaɓar ƙasan dama a matsayin wurin farawa, bayan haka kuna buƙatar danna saman hagu.

Kammalawa

Daga cikin zaɓuɓɓuka guda uku don zaɓar tebur a cikin Excel da aka bayyana a sama, zaku iya amfani da duka ukun. Kuma lokacin zabar wata hanya ta musamman, wajibi ne a yi la'akari, da farko, girman tebur. Hanyar farko ita ce mafi sauƙi kuma mafi fahimta, amma yana da kyau kuma mafi dacewa don amfani da shi a kan ƙananan tebur. Tun da zaɓin dukan yanki na tebur tare da linzamin kwamfuta zai zama da wahala sosai idan tebur ya ƙunshi adadi mai yawa na layuka, saboda haka dole ne ku riƙe maɓallin linzamin kwamfuta na hagu na dogon lokaci. Zabi na biyu tare da hotkeys shine mafi sauri, amma nuances na iya haifar da wasu matsaloli ga mai amfani. Hanya ta uku tana guje wa waɗannan matsalolin, amma yana ɗaukar ɗan lokaci kaɗan fiye da amfani da haɗin maɓallin da aka tsara a cikin zaɓi na biyu.