Rubutun shafi da kuma jigo a cikin Shafukan Lissafi na Excel

A cikin Excel da Google Sheets, maɓallin shafi ko kuma rubutun shafi shine launin launin toka mai launin toka wanda ya ƙunshi haruffa (A, B, C, da dai sauransu) da aka yi amfani da shi don gano kowane shafi a cikin takarda . Rubutun shafi a saman jere 1 a cikin takardun aiki.

Hanya na jere ko jere jigo shi ne launi mai launin launin toka a gefen hagu na shafi na 1 a cikin takardun aiki wanda ya ƙunshi lambobi (1, 2, 3, da dai sauransu) da aka yi amfani dasu don gano kowane jere a cikin takarda.

Rubutun shafi da kuma jigon Hoto da Siffofin Siffar

Haɗuwa, ginshiƙan haruffa da lissafin jere a cikin rubutun guda biyu suna ƙirƙirar haɗin gizon da ke gano ɓangaren mutum wanda aka samo a tsakiyar tsaka tsakanin shafi da jere a cikin takarda.

Siffofin salula - irin su A1, F56, ko AC498 - ana amfani da su a cikin aikace-aikacen layi kamar su dabara da lokacin tsara sigogi .

Rubutun bugawa da Takardun Shafi a Excel

Ta hanyar tsoho, Excel da Shafukan Wallafa na Google ba su buga shafi ko jigogi da aka gani akan allon ba. Bugu da waɗannan jeren layuka sau da yawa ya sa ya fi sauƙi don biye da wurin samfurori a cikin manyan takardun aiki.

A cikin Excel, yana da sauƙi don kunna fasalin. Lura, duk da haka, dole ne a kunna kowane ɗayan rubutu don a buga. Kunna siffar a ɗayan ɗayan aiki a cikin takarda ba zai haifar da rubutun jeri da shafi na kowane ɗigon rubutu ba.

Lura : A halin yanzu, baza'a yiwu a buga shafi da kuma jigogi jeri a cikin Shafukan Google ba.

Don buga rubutun shafuka da / ko jere don aikin aiki na yanzu a Excel:

1. Danna maɓallin Layout na shafin rubutun .

2. Danna akwatin akwatin bugawa a cikin Ƙungiyoyin Zaɓuɓɓuka don kunna siffar.

Kunna Rubuce da Takardun Shafi A kan ko A kashe a Excel

Ba a nuna alamar jeri da na shafi a kan takarda ba. Dalilin da za a juya su zai kasance don inganta bayyanar aikin aiki ko don samun ƙarin allo a kan manyan ɗakunan rubutu - yiwu a lokacin ɗaukan kayan allo.

Kamar yadda bugawa, dole ne a kunna ko a kashe duk waƙoƙin jeri da shafi na kowane takarda.

Don kashe rubutun jeri da shafi a Excel:

1. Danna kan Fayil din menu don buɗe jerin abubuwan da aka sauke.
2. Danna Zaɓuɓɓuka cikin jerin don buɗewa Excel Zabuka maganganun.
3. A cikin ɓangaren hagu na akwatin maganganu, danna Na ci gaba.
4. A cikin Nuni Zaɓuɓɓuka don wannan sashin aiki - located a kusa da ƙasa na hannun dama na dama na akwatin maganganu - danna kan akwati kusa da Nuna zane da haɗin ginsunan don cire alamar bincike.
5. Don kashe saitunan jeri da shafi don ƙarin ɗawainiya a cikin littafin aiki na yanzu, zaɓi sunan wani aikin aiki daga akwatin da aka sauke a kusa da Zaɓuɓɓukan Nuni don wannan ɗigin aikin aiki da kuma share alamar rajistan shiga a cikin Siffofin jeri da kuma rubutun shafi. rajistan akwatin.
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

Lura : A halin yanzu, baza'a iya juya shafi ba kuma jere jigo a cikin Google Sheets.

R1C1 Sakamakon vs. A1

Ta hanyar tsoho, Excel yana amfani da tsarin ɗaukar A1 na tantancewar salula. Wannan sakamako, kamar yadda aka ambata, a cikin rubutun shafi wanda ya nuna haruffa a sama da kowane shafi fara da harafin A da jere na nuna lambobin farawa da ɗaya.

Tsarin madaidaici na tsarin rubutu - wanda aka sani da R1C1 - yana samuwa kuma idan an kunna, duk takardun aiki a duk littattafan aiki zasu nuna lambobi maimakon haruffa a cikin rubutun shafi. Lissafin jeri na ci gaba da nuna lambobi kamar yadda tsarin A1 yayi.

Akwai wasu abũbuwan amfãni ga yin amfani da tsarin R1C1 - mafi yawa idan ya zo da samfurori da lokacin rubuta rubutun VBA na Excel macros .

Don kunna tsarin R1C1 a kan - ko a kashe:

1. Danna kan Fayil din menu don buɗe jerin abubuwan da aka sauke.
2. Danna a Zabuka a cikin jerin don budewa Excel Zabuka maganganun.
3. A cikin ɓangaren hagu na akwatin maganganu, danna Formulas.
4. A cikin Aiki tare da ɓangaren ɓangaren ɓangaren hagu na dama na akwatin maganganu, danna kan akwati kusa da zaɓi na R1C1 don ƙarawa ko cire alamar rajistan.
5. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

Canza Fusoshin Faɗakarwa a cikin Takaddun Shafi da Sauti a Excel

A duk lokacin da aka bude sabon fayil ɗin Excel, za'a nuna shafukan jere da na shafi ta hanyar amfani da tsoho na layi na al'ada. Wannan nau'in tsarin layi na al'ada shi ne kuma tsoho da aka yi amfani dashi a cikin dukkanin fayilolin rubutu.

Don Excel 2013, 2016, da Excel 365, tsoho asalin rubutun shine Calibri 11 pt. amma wannan za a iya canzawa idan yana da ƙananan, maɗaukaka, ko dai ba don ƙaunarku ba. Lura cewa, wannan canji yana rinjayar duk takardun aiki a cikin takarda.

Don canza saitunan Yanayin al'ada:

1. Danna kan shafin shafin shafin Ribbon.
2. A cikin Ƙungiyar Styles, danna Ƙungiyoyin Cell don buɗe Siffar Filayen Siginan Cell.
3. Danna-dama a kan akwatin a cikin shagon mai suna Normal - wannan ita ce al'ada al'ada - don buɗe wannan menu na mahallin wannan zaɓi.
4. Danna kan Sauya a cikin menu don buɗe akwatin maganganun Style.
5. A cikin akwatin maganganu, danna kan Maɓallin Maɓallin don buɗe akwatin maganganun Siffofin Siffar.
6. A cikin wannan zance na zane na biyu, danna kan Font tab.
7. A cikin Font: sashe na wannan shafin, zaɓi sahun da ake so daga jerin jerin zaɓuɓɓuka.
8. Yi duk wasu canje-canje da ake so - kamar Font style ko size.
9. Danna Ya sau sau biyu, don rufe dukkanin maganganun maganganu kuma komawa zuwa aikin aiki.

Lura: Idan ba ku ajiye littafin ba bayan yin wannan canji canjin ba zai sami ceto ba kuma littafin zai dawo zuwa lakaran da suka gabata a lokacin da aka buɗe.