Momwe mungachotsere masanjidwe patebulo mu Excel?

Echo Dot Smart speaker

Zomasulira zaposachedwa za Microsoft Excel zimapereka zida zowoneka bwino komanso zachangu, monga zosintha zapamwamba kwambiri zamatebulo. Ndibwino, koma ndidawona tsiku lapitalo kuti ndizosatheka kuphatikiza ma cell, mwachitsanzo, potembenuza tebulo.

Ndipo, pof! …palibe njira yochotsera masanjidwe oipawo 😕 ...Palidi [CTRL+Z]…koma mwadzidzidzi kusintha kulikonse kwapakati kumatayikanso.

Kwenikweni, inde, ndizotheka. Koma kwenikweni deductible.

Momwe mungachotsere masanjidwe patebulo mu Excel

Momwe mungachotsere masanjidwe patebulo mu Excel?

Kuti mubwerere koyambira, mawonekedwe a tebulo amapangidwa kuchokera pagawo loyambira:

  • sankhani ma cell a tebulo lanu
  • dinani pa "Conditional Formatting"> "Mapangidwe a Table". Zomwe muyenera kuchita ndikudina mtundu womwe mwasankha:

Zotsatira zokongoletsa, ndi mwayi wokonzekera ndi mizati, subtotals, etc.

Kuchotsa malingaliro amafomatiwa kungatipangitse kugula batani la "Chotsani Zokonda" kapena "Chotsani Masitayilo". Inde alipo! Koma osati deductible kwambiri:

  • dinani pa tebulo cell
  • Dinani pa "Creation" tabu, pansi pa "Zida Zamakono" zomwe zidawonekera kumanja kumtunda
  • Dinani pa "Quick Styles"
  • ndipo potsiriza alemba pa "Chotsani" pansi pa menyu amene anali malo.

Koma apa izo ziri. Makongoletsedwe achotsedwa, koma mawonekedwe a tebulo akadalipo! M'mawu ena, palibe njira yophatikizira maselo, mwachitsanzo :)

Ndipo apa ndi pomwe chinyengo chimabwera (TADAAA 8)!):

  • Bwerezani masitepe awiri oyamba pamwamba kuti mufike pa "Zida Zopangira" patebulo lanu
  • Ndipo pamenepo (ayenera kudziwa…), dinani "Sinthani ku Range"

Ndipo pali chozizwitsa! Mumapeza tebulo loyambirira (ndi mitundu yabwino ngati kuphatikiza ngati simunachotse kalembedwe).

Tommy Banks
Tidzasangalala kumva zomwe mukuganiza

siya yankho

TechnoBreak | Zopereka ndi Ndemanga
Logo
Yambitsani kulembetsa mumakonzedwe - onse
Ngolo yogulira