Excel e fana ka lisebelisoa tse ngata ho laola ponahalo ea buka ea mosebetsi. Thutong e fetileng, re se re ithutile mokhoa oa ho hatsetsa mela le litšiea. Ho sena, re tla hlahloba lisebelisoa tse 'maloa tse u lumellang ho arola lakane ka likarolo tse' maloa, hammoho le ho sheba tokomane lifensetereng tse fapaneng.
Haeba buka ea mosebetsi ea Excel e na le lintlha tse ngata, ho ka ba thata ho etsa 'mapa oa likarolo tse fapaneng. Excel e na le likhetho tse ling tse etsang hore ho be bonolo ho utloisisa le ho bapisa data. Ka mohlala, u ka bula buka fensetereng e ncha kapa ua arola lakane libakeng tse arohaneng.
Ho bula buka ea hajoale ka fensetere e ncha
Excel e u lumella ho bula buka ea mosebetsi e tšoanang lifensetereng tse ngata ka nako e le 'ngoe. Mohlala oa rona, re tla sebelisa tšobotsi ena ho bapisa lipampiri tse peli tse fapaneng bukeng e le 'ngoe ea mosebetsi.
- Click ea View ho Ribone, ebe o kgetha taelo Fesetere e ncha.
- Ho tla buleha fensetere e ncha bakeng sa buka ea hajoale.
- Hona joale o ka bapisa maqephe a buka e le 'ngoe lifensetereng tse fapaneng. Mohlala oa rona, re tla khetha tlaleho ea thekiso ea 2013 ho bapisa thekiso ea 2012 le 2013.
Haeba u na le lifensetere tse 'maloa tse bulehileng, u ka sebelisa taelo Hlophisa Tsohle bakeng sa lihlopha tse potlakileng tsa lifensetere.
Ho arola lakane libakeng tse arohaneng
Excel e u lumella ho bapisa likarolo tsa leqephe le le leng ntle le ho theha lifensetere tse ling. Sehlopha Ho arola e o lumella ho arola lakane ka libaka tse arohaneng tse ka tsamaisoang ntle le tse ling.
- Khetha sele moo u batlang ho arola lakane. Haeba u khetha sele karolong ea pele kapa mola oa pele, joale lakane e tla aroloa likarolo tse 2, ho seng joalo e tla aroloa ka 4. Mohlala oa rona, re tla khetha sele C7.
- Click ea View Riboneng, ebe o tobetsa taelo Ho arola.
- Letlapa le tla aroloa libakeng tse 'maloa. O ka tsamaisetsa sebakeng se seng le se seng ka thoko ho sebelisa li-scrollbar. Sena se tla u lumella ho bapisa likarolo tse fapaneng tsa leqephe le le leng.
O ka hula likarohano tse otlolohileng le tse tšekaletseng ho fetola boholo ba karolo ka 'ngoe. Ho tlosa karohano, tobetsa taelo hape Ho arola.