Yadda za a Sake Sunan rubutu a Excel

01 na 02

Sake Sunan rubutu a Excel

Sakewa da Ganawa Shafuka Tafarkin rubutu

Canje-canje biyu da suke sauƙaƙe don tsarawa da kuma gane saitunan aiki da kuma bayanai da suke dauke da su shine sake suna da takardun aiki da kuma canza launi na shafin aikin aiki wanda ya ƙunshi sunan a kasa na aikin aiki.

Sakewa da Rubutun Ɗabi'ar Excel

Akwai hanyoyi masu yawa don sake suna a takardar aiki a Excel, amma duk ko dai ya haɗa yin amfani da shafukan takardun a ƙasa na allo na Excel ko zaɓuɓɓukan da aka samo a kan shafin shafin shafin rubutun .

Zabin 1 - Amfani da Maɓalli Hoton Hotuna:

Lura : Maballin Alt ba dole a dakatar da shi ba yayin da wasu maɓallai sun guga, kamar yadda wasu gajerun hanyoyi na keyboard. 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 jerin - R - an danna kuma aka saki, sunan yanzu a kan takardar shafi na yanzu ko takardar aiki an haskaka.

1. Latsa kuma saki a cikin jerin hanyar haɗin maɓalli na gaba don haskaka sunan takardar aiki;

Alt + H + O + R

2. Rubuta sabon suna ga takardar aiki;

3. Latsa maɓallin shigarwa a kan keyboard don kammala sake sakewa da takardun aiki.

Kulle maɓallin Kayan aiki na Gyara Ƙunƙwasa

Hanyar hanya ta hanyar haɗi da aka danganta shi ne don sauyawa tsakanin ɗawainiya - tun da takardar aiki shine wanda za a sake suna ta amfani da haɗin haɗin haɗuwa a sama. Yi amfani da haɗin maɓallai masu biyowa don tabbatar da cewa za a sami sunan sunadaran daidai:

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

Takaddun shaida Tab na Zaɓuka

Za'a iya sake yin amfani da takardun aikin aiki ta danna kan takardar shafi tare da zaɓuɓɓuka biyu na gaba.

Zabin 2 - Biyu Danna Takardar Tabba:

1. Danna sau biyu a kan sunan yanzu a cikin shafin aikin aiki don nuna alama ga sunan yanzu a shafin;
2. Rubuta sabon suna ga takardar aiki;
3. Latsa maɓallin shigarwa a kan keyboard don kammala laima da sunan aiki;
4. Sabon suna ya kamata a bayyane a kan shafin aiki.

Zabin 3 - Danna Danna Tabbin Tab ɗin:

1. Danna madaidaiciya a kan shafin shafin aiki da kake son sake suna don buɗe menu mahallin;
2. Danna kan Sunaye a cikin jerin menu don haskaka sunan aikin aiki na yanzu;
3. Bi matakai 2 zuwa 4 a sama.

Zabi na 4 - Samun Rubin Ribbon tare da Mouse:

1. Danna kan shafi na takardar aiki da za a sake suna don sa shi takardar aiki
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin Zaɓin kan rubutun don buɗe jerin menu na saukewa
4. A cikin Shirye-shiryen Faɗakarwa na ɓangaren menu, danna kan Sunaye Sunaye don haskaka takaddun shafi a kasa na allon
5. Rubuta sabon suna don aikin aiki
6. Latsa maɓallin shigarwa a kan keyboard don kammala sake sakewa da takardun aiki

Duba Shafukan Wallafa a cikin Ɗabi'a

Idan littafi ya ƙunshi babban adadin ayyukan aiki ko kuma gungumen gungumen gungumen da aka kwashe a baya, ba duk takardun shafuka ba ne a bayyane a lokaci guda - musamman tun da takaddun sunaye sunyi tsawo, don haka yi shafuka.

Don gyara wannan halin,

1. Sanya maƙalin linzamin kwamfuta a kan rassan ellipsis (tsaye uku) a gefen gefen gungura mai kwance;
2. Mainter pointer zai canza zuwa arrow - wanda aka nuna a cikin hoto a sama idan an daidaita shi daidai;
3. Latsa ka riƙe ƙasa maɓallin linzamin hagu kuma ja da maɓallin zuwa dama don fadada yankin don shafukan takardun da za a nuna - ko a hagu don fadada barikin gungura.

Ƙuntataccen Yankin Rubutun Yanayi na Excel

Akwai wasu ƙuntatawa game da sake sunawa wani aikin aiki na Excel:

• Sunan ba zai iya wuce haruffa 31 a tsawon ba
• Ba za a iya barin sunan rubutu ba
• Ba za a iya amfani da waɗannan haruffa a cikin suna: \ /? : * [

Amfani da Sunan Ayyuka a Formats na Excel

Sake maimaita takarda aiki ba kawai ya sa ya zama sauƙaƙa don ci gaba da lura da takardun mutum a babban ɗigon littafi ba, amma yana da ƙarin amfani da yin sauƙi don fahimtar takaddun da ya zana ɗakunan rubutu masu yawa.

Lokacin da wani tsari ya hada da tantancewar salula daga ɗayan aiki daban-daban da sunan aikin aiki an haɗa shi a cikin tsari.

Idan an yi amfani da sunaye na aiki na asali - irin su Sheet2, Sheet3 - wannan tsari zaiyi kama da wannan:

= Sheet3! C7 + Sheet4! C10

Bayar da takardun mujalloli wani sunan da aka kwatanta - kamar na Mayu da kuma Kudin Yuni - zai iya sa batun ya fi sauƙi ya yanke. Misali:

= 'Ƙarin kuɗi'! C7 + 'Kudin Yuni'! C10

02 na 02

Canji Takaddun Launuka Tab

Canji Takaddun Launuka Tab Tabbarorin

Don taimaka maka samun takamaiman bayani a cikin fayiloli na manyan fayiloli, yana da amfani ga launi launi da 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.

Don Canja Launi Tab na Ɗaukar Saitunan Ɗaya

Zabin 1 - Amfani da Maɓalli Hoton Hotuna:

Lura : Kamar yadda aka sake yin amfani da maɓallin aiki ta amfani da makullin maɓallin , maɓallin Alt ba dole a riƙe shi ba yayin da sauran maɓallai aka gugawa, kamar yadda wasu gajerun hanyoyi na keyboard suke. Kowace maballin an goge shi kuma an sake shi a bayansa.

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

Alt + H + T

2. Ta hanyar tsoho, launi mai launi a saman hagu na kusurwar palette - fari a cikin hoton da ke sama - an zaba. Danna maɓallin linzamin kwamfuta ko amfani da makullin maɓallin keɓaɓɓiyar keyboard don motsawa cikin hasken da ake so;

3. Idan kana amfani da maɓallin arrow, danna maɓallin shigarwa a kan keyboard don kammala sake sakewa da takardun aiki;

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

Zabin 2 - Dama Danna Tabbin Tabba:

1. Dama a kan shafin na takardun aikin da kake son sake sake launi don sanya shi takardar aiki da kuma bude menu mahallin;
2. Zaɓi Taɓa Tab a cikin jerin menu don buɗe launi na launi;
3. Danna kan launi don zaɓar shi;
4. Don ganin ƙarin launi, danna kan Ƙari Launuka a kasa na launi na launi don buɗe launi na launi na al'ada.

Zabin 3 - Samun Rubin Ribbon tare da Mouse:

1. Danna kan shafi na takardun aiki da za a sake suna don sa shi takardar aiki;
2. Danna kan shafin shafin shafin rubutun;
3. Danna maɓallin Zaɓin kan rubutun don buɗe jerin menu na saukewa;
4. A cikin Shirye-shiryen Fayil na menu, danna 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 don buɗe launi na launi na al'ada.

Don Canja Launi Tab na Maƙallan Kasuwanci

Lura: Duk ɗayan shafukan da aka zaɓa za su kasance iri ɗaya.

1. Don zaɓar ɗawainiyar ɗawainiya ta ɗayan ayyuka, riƙe ƙasa da maɓallin Ctrl akan keyboard kuma danna kan kowane shafin tare da maɓallin linzamin kwamfuta.
   Danna madaidaici akan daya daga cikin shafukan da aka zaɓa don buɗe menu da aka sauke.
2. Zaɓi Taɓa Tab a cikin jerin menu don buɗe launi na launi.
3. Don ganin wasu launuka, danna kan Ƙari Launuka a kasan launin launi don bude Launi na Custom Color.

Sakamako

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 aikin aiki na aiki a cikin launi da aka zaba.
   • Duk sauran shafuka na ayyuka suna nuna launi da aka zaɓa.