Kenya lihlooho le lihlooho ho Excel Worksheets

Eketsa Lihlooho tsa Preset kapa tsa Tsamaiso le Lihlooho ho Excel Worksheets

Ho Excel, lihlooho le maoto a maoto ke mela ea mongolo o hatisoang ka holimo (hlooho) le ka tlase (maoto a maoto) a leqephe le leng le le leng leqepheng la mosebetsi .

Li na le litemana tse hlalosang tse kang litlotla, matsatsi, le / kapa lipalo tsa leqephe. Kaha ha li bonahale ka tsela e tloaelehileng ea pono ea lipampiri, lihlooho le lihlooho li atisa ho kenngoa leqepheng la lipampiri le hatisoang.

Lenaneo le tla le hlophisitsoe ka lihlooho tse ngata tse behiloeng pele - tse kang likhaolo tsa leqephe kapa lebitso la buka ea mosebetsi oa boitsebiso -le bonolo ho eketsa kapa o ka hlahisa lihlooho tsa litloaelo le maoto a maoto a ka kenyelletsang mongolo, litšoantšo, kapa data e ' ngoe ea spreadsheet.

Le hoja li-watermark tsa 'nete li ke ke tsa bōptjoa Excel, "maqheka" a maqephe a marang-rang a ka kenngoa leqepheng la lipampiri ka ho eketsa litšoantšo ho sebelisa lihlooho tse tloaelehileng kapa maoto.

Lihlooho le Lieta-liphoo Libaka

• Sehlooho kapa maoto a ka ba le lintlha tse tharo tsa boitsebiso. Boitsebiso bona bo ka hlaha libakeng tse tharo tse leqepheng;
• Bakeng sa lihlooho, libaka ke sekhutlo se ka holimo le letšehali, setsi se ka holimo, le holimo ka ho le letona la leqephe;
• Bakeng sa maoto a maoto, libaka ke sekhutlo se ka tlase ho le letšehali, bohareng bo ka tlaase, le ka tlaase ea lehlakoreng le letona la leqephe.

Lihlooho tsa Preset / Footers Codes

Boholo ba lihlooho tsa li-preset le li-footer tse fumanehang mekhoeng ea ho kenya Excel - e kang & [Page] kapa & [Date] - ho kenya tlhahisoleseding e lakatsehang. Melao ena e etsa hore lihlooho le maoto a maoto li be matla - ho bolelang hore li fetoha ha ho hlokahala, athe lihlooho tsa moetlo le maoto a maoto li na le static.

Ka mohlala, & [ Code ] khoutu e sebelisetsoa ho ba le linomoro tsa maqephe a fapaneng leqepheng le leng le le leng. Haeba o kenngoa ka letsoho ka mokhoa o tloaelehileng, leqephe le leng le le leng le tla ba le nomoro e lekanang ea leqephe

Ho sheba lihlooho le maoto

Lihlooho le lihlooho li bonahala ka Pono ea Phatlalatso ea Leqephe empa, joalokaha ho boletsoe, eseng ka Pono e tloaelehileng ea sekhahla sa mosebetsi. Haeba u eketsa lihlooho kapa lihlooho ka lebokoseng la kemiso la Kemiso, khaotsa ho sheba Layout kapa u sebelise Print Preview ho ba bona.

Ho na le mekhoa e 'meli ea ho kenyelletsa tloaelo ea bobeli le lihlooho tsa lihlooho le li-footer ho sheetshete:

1. ho sebelisa leqephe la Layou t;
2. ho sebelisa lebokose la ho kenyelletsa leqephe la lebokose .

Ho eketsa Tlhaloso ea Tlhahlobo kapa Leoto la Maoto Tseleng ea Leqephe

Ho eketsa hlooho ea moetlo kapa hlooho ho Pono ea mohaho oa leqephe :

1. Tobetsa Thabeng ea tboni;
2. Tobetsa ho khetho ea Leqephe ka lebone ho fetohela ponong ea maqephe joalokaha ho bontšoa setšoantšong se ka holimo;
3. Tlanya le mouse ho e 'ngoe ea mabokose a mararo holimo kapa ka tlaase ho leqephe ho kenya hlooho kapa maoto;
4. Tlanya tlhahisoleseding ea sehlooho kapa maoto ho lebokose le khethiloeng.

Ho eketsa Sehlooho sa Preset kapa Leoto la Maoto ho Leqephe la Page

Ho eketsa e 'ngoe ea lihlooho tsa lihlooho kapa lihlooho ho Pono ea mohaho oa leqephe :

1. Tobetsa Thabeng ea tboni;
2. Tobetsa ho khetho ea Leqephe ka lebone ho fetohela ponong ea maqephe joalokaha ho bontšoa setšoantšong se ka holimo;
3. Tlanya le mouse ho e 'ngoe ea mabokose a mararo ka holimo kapa ka tlaase ho leqephe ho kenyelletsa hlooho kapa maoto sebakeng seo - ho etsa joalo ho boetse ho eketsa Taba ea Design ho Ribbon joalokaha ho bontšitsoe setšoantšong se ka holimo;
4. Ho eketsa mohlooho oa setlhopha se setle kapa leoto la maoto sebakeng se khethiloeng se ka etsoa ka:
   1. Ho tobetsa ho Sehlooho sa Header kapa Footer lethathamong ho bula lenaneo la theoha la khetho e qalileng;
   2. Ho tobetsa ho e 'ngoe ea likhetho tse behiloeng ka pele holim'a Ribboni - tse kang Nane ea Leqephe , Nako ea Hona joale , kapa Lebitso la Fumana;
5. Ngola tlhahisoleseding ea hlooho kapa ea maoto.

Ho Khutlela Pono e Tloaelehileng

Hang ha u ekelitse hlooho kapa maoto, Excel e tlohela u sheba Pono ea Leqephe . Le hoja ho ka khoneha ho sebetsa ponong ena, u ka 'na ua batla ho khutlela ho Pono e tloaelehileng . Ho etsa joalo:

1. Tobetsa ho sele leha e le efe kahare ea mosebetsi ho tsoa sebakeng sa hlooho / maoto;
2. Tobetsa ho Thabeng ea Pono ;
3. Tobetsa ka kgetho e tloaelehileng ka hare.

Ho eketsa lihlooho tsa Preset le maoto a maoto ka lebokoseng la Dijo la Ho Setjha

1. Tobetsa ho Taba ea ho hlahisa leqephe la letlapa ;
2. Tobetsa ho Setjha sa Leqephe sa lebokose la lebokose la lebokose la menyetla ho tloha menu ho bula lebokose la lebokose la Setha sa Leqephe ;
3. Ka lebokoseng la lebokose, khetha lebokose la Sehlooho / Leoto la maoto ;
4. Khethoa ho tloha sethaleng sa setlhompho kapa moetlo oa sehlooho-dikgetho tsa maoto joalokaha ho bontšoa setšoantšong se ka holimo;
5. Tobetsa OK ho koala lebokose la lebokose;
6. Ka ho feletseng, lihlooho tsa lihlooho le li-footer li thehiloe leqepheng la lipampiri;
7. Hlahloba hlooho / maoto ka Phatlalatso ea Print .

Tlhokomeliso : Lihlooho tsa maiketsetso le maoto a maiketsetso li ka boela tsa kenngoa lebokoseng la lebokose ka ho tobetsa lihlooho tsa mekhoa-hloko kapa lieta-maoto - tse bontšitsoeng setšoantšong se ka holimo.

Ho sheba Sehloohong kapa maotong a Ponahalo ea ho hatisa

Tlhokomeliso : O tlameha ho ba le mochine oa khatiso o kentsoeng k'homphieutheng ea hau ho sebelisa Print Preview.

1. Tobetsa ho Files menu ho bula menu e theoha ea dikgetho;
2. Tobetsa ho Senya ho menu ho bula fensetere ea ho hatisa;
3. Lethathamo la lipampiri la hona joale le tla hlaha ka lehlakoreng la pele ho le letona la fensetere.

Ho tlosa lihlooho kapa maoto a maoto

Ho tlosa lihlooho ka bomong le / kapa lihlopha ho tloha leqepheng la lipampiri, sebelisa mehato e ka holimo bakeng sa ho eketsa lihlooho le lihlooho ho sebelisa pono ea Phatlalatso ea Leqephe le ho tlosa lintlha tse hlahang ka sehloohong / maoto.

Ho tlosa lihlooho le / kapa likotoana ho tloha lipapaling tse ngata hang-hang:

1. Khetha lipampiri;
2. Tobetsa ho Taba ea Sebaka sa Leqephe;
3. Tobetsa ho Setjha sa Leqephe sa lebokose la lebokose la lebokose la menyetla ho tloha menu ho bula lebokose la lebokose la Setha sa Leqephe ;
4. Ka lebokoseng la lebokose, khetha lebokose la Sehlooho / Leoto la maoto ;
5. Khetha (ha ho le mong) mohloling oa preset le / kapa lebokose la maoto;
6. Tobetsa OK ho koala lebokose la lebokose;
7. Lintlha tsohle tsa sehlooho le / kapa litlhaku li lokela ho tlosoa maqepheng a khethiloeng.