Bitar bita a cikin Excel

A cikin wannan ɗan gajeren koyawa, za mu ci gaba da batun bin diddigin bita a cikin littattafan aikin Excel. Kuma a yau za mu yi magana game da yadda za a duba gyare-gyaren da wasu masu amfani suka yi, da kuma yadda za a cire su gaba daya daga takardun Microsoft Excel.

A gaskiya ma, duk gyare-gyare nasiha ce a cikin yanayi. Dole ne a yarda da su don aiwatar da su. Haka kuma, marubucin littafin yana iya ƙi yarda da wasu gyare-gyare kuma ya ƙi su.

Abin da kuke buƙatar bitar bita

  1. Tura umarni Tsarkarwa tab Nunawa kuma zaɓi daga menu mai saukewa Yarda / Kin Amincewa da Canje-canje.
  2. Idan an sa, danna OKdon ajiye littafin.
  3. Tabbatar cewa a cikin akwatin maganganu da ya bayyana Gyaran gyaran fuska duba da lokaci da zaɓin zaɓi Ba a duba ba tukuna… Sannan danna OK.Bitar bita a cikin Excel
  4. A cikin akwatin maganganu na gaba, danna maballin yarda da or Karyata ga kowane takamaiman bita a cikin littafin aiki. Shirin zai motsa kai tsaye daga wannan gyara zuwa wancan har sai an sake duba su duka zuwa ƙarshe.Bitar bita a cikin Excel

Don karɓa ko ƙin duk bita lokaci ɗaya, danna Yarda da duka or Kin yarda da kowa a cikin akwatin maganganu daidai.

Yadda ake kashe yanayin bin faci

Ko an karɓi bita ko an ƙi, ana iya bin su a cikin littafin aikin Excel. Don cire su gaba ɗaya, dole ne ku kashe bin diddigin facin. Don wannan:

  1. A kan Babba shafin Nunawa latsa umarnin Tsarkarwa kuma zaɓi daga menu mai saukewa Haskakawa gyare-gyare.Bitar bita a cikin Excel
  2. A cikin akwatin maganganu da ya bayyana, cire alamar Bibiyar gyare-gyare kuma latsa OK.Bitar bita a cikin Excel
  3. A cikin akwatin maganganu na gaba, danna A don tabbatar da cewa kuna son kashe bin diddigin bita kuma ku daina raba littafin aikin Excel.Bitar bita a cikin Excel

Bayan kashe bita bita, za a cire duk canje-canje daga littafin aiki. Ba za ku iya dubawa, karɓa ko ƙin yarda da canje-canje ba, ban da cewa duk canje-canje za a karɓi ta atomatik. Tabbatar yin bitar duk bita a cikin littafin aikin Excel kafin a kashe bin diddigin bita.

Leave a Reply