3 Hanyoyi don Canji Saitunan Tab na La'un rubutu a Excel

Nau'in Tab zai iya taimaka maka ka zauna a cikin ɗakunan rubutu

Don taimaka maka samun takamaiman bayani a cikin manyan fayilolin rubutu, yana da amfani ga launi launi takaddun shafuka na takardun aikin mutum wanda ya ƙunshi bayanai masu dangantaka. Hakazalika, zaku iya amfani da shafukan launi daban-daban don bambanta tsakanin zane-zane da ke dauke da bayanai marasa dangantaka.

Wani zabin shi ne ƙirƙirar tsarin launuka wanda ke samar da alamu na hanzari a kan mataki na kammala don ayyukan - irin su kore don ci gaba, da ja don gamawa.

Waɗannan su ne zaɓuɓɓuka guda uku don canza launin launi na launi guda ɗaya a cikin takarda:

Canja Launuka Tabbar Tafiyar amfani ta amfani da maɓalli Keyboard ko Mouse

Zabin 1 - Amfani da Maɓalli Hoton Hotuna:

Lura : Maballin Alt ɗin a cikin jerin da ke ƙasa ba dole ba a dakatar da shi yayin da sauran maɓallai suna gugawa, kamar yadda wasu gajerun hanyoyi na keyboard suke. Kowace maballin an goge shi kuma an sake shi a bayansa.

Abin da wannan saiti na keystrokes yana kunna umarnin rubutun. Da zarar maɓallin karshe a cikin jerin - T - an kunna kuma aka saki, ana buɗe launi na launi don canza launin launi na launi.

1. Danna kan shafin yanar gizon aiki don sanya shi takardar aiki - ko amfani da wadannan gajerun hanyoyin keyboard don zaɓar aikin aiki da ake so:

Ctrl + PgDn - matsa zuwa takardar a dama Ctrl + PgUp - matsa zuwa takardar a gefen hagu

2. Latsa kuma a saki a cikin jerin jerin haɗin da ke biyowa don buɗe launi na launi da ke ƙarƙashin Zaɓin Ƙari a kan shafin shafin shafin rubutun :

Alt + H + T

3. Ta hanyar tsoho, launi mai launi na launi na yanzu yana haskaka (kewaye da iyakar yankin orange). Idan launin launi bai taɓa canja wannan zai zama fari. Danna maɓallin linzamin kwamfuta ko amfani da makullin maɓallin keɓaɓɓen keyboard don motsawa cikin hasken da ake bukata a cikin palette;

4. Idan kana amfani da maɓallin arrow, danna maɓallin shigarwa akan keyboard don kammala layin launi;

5. Don ganin ƙarin launuka, danna maɓallin M a kan keyboard don buɗe launi na launi al'ada.

Zabin 2 - Dama Danna Tabbin Tabba:

1. Danna-dama a kan shafin shafin aiki da kake son sake sake launi don sanya shi takardar aiki kuma don buɗe menu mahallin;

2. Zaɓi Launi Tab a cikin jerin menu don buɗe launin launi;

3. Danna kan launi don zaɓar shi;

4. Don ganin ƙarin launi, danna kan Ƙari Launuka a kasan launin launi don bude launi na launi na al'ada.

Zabin 3 - Samun Rubin Ribbon tare da Mouse:

1. Danna kan shafin aikin aiki da za a sake suna don sa shi takardar aiki;

2. Danna shafin shafin rubutun;

3. Danna Zaɓin Zaɓin kan rubutun don buɗe jerin menu na saukewa;

4. A cikin Faɗakarwar Fannoni na ɓangaren menu, danna kan Tab Tab don buɗe launin launi;

5. Danna kan launi don zaɓar shi;

6. Don ganin ƙarin launi, danna kan Ƙari Launuka a kasa na launi na launi domin buɗe al'ada launi.

Canza launi Tab na Maƙallan Kasuwanci

Canza launi takaddun shaida don takardun aiki masu yawa yana buƙatar waɗannan waƙaƙai duk za a zaɓa kafin amfani da ɗaya daga cikin hanyoyin da aka tsara a sama.

Zanen da aka zaɓa na iya zama kwata-kwance - kusa da juna, kamar zane-zane daya, biyu, uku - ko takardun mutum ɗaya za a iya zaɓa, kamar su sha huɗu da shida.

Dukkan shafukan da aka zaɓa za su kasance iri ɗaya.

Zaɓin takardun aiki masu mahimmanci

1. Danna shafin shafin aiki wanda yake a gefen hagu na rukuni don a canza don sanya shi takardar aiki.

2. Riƙe maɓallin Shift a kan keyboard.

3. Danna kan shafin takardun aiki a gefen dama na rukuni - duk zaɓaɓɓun ɗawainiya tsakanin farawa da ƙarshen zane.

4. Idan an zaɓi zanen da yawa ta hanyar kuskure, danna kan takarda na ƙarshe - tare da maɓallin Shift har yanzu an ci gaba - don ƙayyade kayan aikin da ba'a so.

5. Yi amfani da ɗaya daga cikin hanyoyin da aka tsara a sama don canza launin launi don duk ɗakunan da aka zaɓa.

Zaɓin takardun aiki na mutum

1. Danna kan shafin daftarin aiki na farko don sanya shi takardar aiki;

2. Riƙe maɓallin Ctrl a kan keyboard kuma danna kan shafuka na duk takardun aiki don a canza - ba su da su zama ƙungiya mai rikitarwa - kamar yadda aka nuna tare da zane-zane hudu da shida a cikin hoton da ke sama;

3. Idan an zaɓi takardar da kuskure, danna kan shi a karo na biyu - tare da maballin Ctrl har yanzu a guga man - don yarda shi;

4. Yi amfani da ɗaya daga cikin hanyoyin da aka tsara a sama don canza launin launi don dukan zanen da aka zaɓa.

Dokar Tab Tab

Lokacin da takardar tab launuka suka canza, dokokin Excel ta biyo bayan nuna launuka masu launuka ne:

  1. Canza launi na launi daya aiki daya:
    • Ana kirkiro sunan aikin aiki a cikin launi da aka zaba.
  2. Canza launi na launi don shafukan aiki fiye da ɗaya:
    • Ana kirkiro shafin (s) aiki na aiki a cikin launi da aka zaba.
    • Duk sauran shafuka na ayyuka suna nuna launi da aka zaɓa.