Onjezerani mutu ndi zolemba ku Excel Worksheet

Onjezerani Zolemba Zapangidwe kapena Zopangidwira Mwapadera ku Zofalitsa za Excel

Mu Excel, mitu yoyendetsa ndi miyendo ndi mzere wa malemba omwe amasindikiza pamwamba (mutu) ndi pansi (mapazi) a tsamba lirilonse pa tsamba la ntchito.

Zili ndi malemba ofotokoza monga maudindo, masiku, ndi / kapena tsamba la tsamba. Popeza sichiwoneka pawonekedwe lamasewera lamasewera, mitu yamutu ndi maulendo nthawi zambiri amawonjezeredwa ku pepala lamasewera lomwe likusindikizidwa.

Pulogalamuyi imabwera ndi makalata angapo omwe ali pamasom'pamaso - monga nambala za pepala kapena dzina la zolemba - zosavuta kuwonjezera kapena mukhoza kulenga mutu ndi zolemba zomwe zingathe kuphatikizapo malemba, zithunzi, kapena deta ina .

Ngakhale ma watermark enieni sangathe kulengedwa mu Excel, "mawu osasamala" mafilimu amatha kuwonjezeredwa pa tsamba lolembapo powonjezera mafano pogwiritsira ntchito mitu yoyendetsa mwambo kapena mapazi.

Mutu ndi Zogulitsa Malo

• Mutu kapena chopondapo chingakhale ndi mfundo zitatu. Uthenga uwu ukhoza kuwonekera m'malo atatu pa tsamba;
• Kwa mutu, malowa ali pamwamba pa ngodya yapamwamba, malo apamwamba, ndi ngodya yapamwamba ya tsamba;
• Kwa maulendo, malowa ali kumunsi kwa ngodya, kumbali yapansi, ndi kumunsi kwa kumanja kwa tsamba.

Zokonzekera Mutu / Mapepala Amtundu

Zambiri mwazolemba ndi zolemba zamakonzedwe zowonongeka zimapezeka muzotsatira zolembera za Excel - monga & [Page] kapena & [[Date] - kuti mulowe muzomwe mukufuna. Zizindikiro izi zimapangitsa kuti mutu ndi zolemba zikhale zolimba - kutanthawuza kuti amasintha monga momwe zimafunira, pamene mutu wachizolowezi ndi maulendo ali ozungulira.

Mwachitsanzo, & [Page] code ikugwiritsidwa ntchito kukhala ndi nambala zosiyana pa tsamba lililonse. Ngati mutalowa mwadongosolo pogwiritsa ntchito mwambowu, tsamba lirilonse lidzakhala ndi nambala imodzi ya tsamba

Kuwona Mutu ndi Zoponda

Mutu ndi maulendo akuwoneka pawonekedwe la Tsamba la Tsamba , monga momwe tanenera, osati muwonekedwe lachizolowezi la worksheet. Ngati wonjezerani mutu kapena masitepe ndi bokosi la Kukonzekera Page , phindulani ku Layou kapena muwone Print Preview kuti muwawone.

Pali njira ziwiri zowonjezera mwambo wonse ndi malemba oyang'aniridwa ndi zolemba pa tsamba:

1. pogwiritsa ntchito tsamba Layou t;
2. pogwiritsa ntchito tsamba lokhazikitsa tsamba .

Kuwonjezera Mutu wamtundu kapena Mapepala pa Tsamba la Tsamba

Kuwonjezera mutu wamakhalidwe kapena mutu wa tsamba la tsamba :

1. Dinani pa tsamba labuboni;
2. Dinani pa Tsambidwe la Tsamba pamaboni kuti muyambe kuona momwe tsamba likuwonetsera pamwambapa;
3. Dinani ndi mbewa pa imodzi mwa mabokosi atatu pamwamba kapena pansi pa tsamba kuti muwonjezere mutu kapena phazi;
4. Lembani nkhani zamutu kapena zamapepala m'bokosi losankhidwa.

Kuwonjezera Mutu wa Preset kapena Footer mu Tsamba la Tsamba

Wowonjezera chimodzi mwa mitu yoyimangidwe kapena mitu yoyang'ana pa tsamba la tsamba :

1. Dinani pa tsamba labuboni;
2. Dinani pa Tsambidwe la Tsamba pamaboni kuti muyambe kuona momwe tsamba likuwonetsera pamwambapa;
3. Dinani ndi mbewa m'modzi mwa mabokosi atatu pamwamba kapena pansi pa tsamba kuti muwonjezere mutu kapena phazi ku malo'wo - kutero kumaphatikizapo Tabu Lopangidwe ku riboni monga momwe tawonetsera pa chithunzi pamwambapa;
4. Kuwonjezera mutu wamasewero kapena chopondapo ku malo osankhidwa kungapangidwe ndi:
   1. Kusindikiza pa Mutu kapena Mtsinje wachitsulo pamakina kuti mutsegule menyu otsika omwe mwasankha;
   2. Kusindikiza pa chimodzi mwazomwe mungasankhe pa Ribbon - monga Tsamba la Tsamba , Tsiku Lino , kapena Dzina la Fayilo;
5. Lembani m'mutu wa nkhani kapena mutu wapamwamba.

Kubwerera ku Zachizolowezi

Mukangowonjezera mutu kapena phazi, Excel ikukutsani inu muwonekedwe wa Tsamba . Ngakhale kuti n'zotheka kugwira ntchitoyi, mungafune kubwereranso kuwona mwachilendo . Kuchita izi:

1. Dinani pa selo lirilonse pa tsamba la ntchito kuti musiye gawo la mutu / phazi;
2. Dinani pa tabu Yoyang'ana;
3. Dinani pa Chinthu Chachizolowezi mu kaboni.

Kuwonjezera Mitu ya Preset ndi Footer mu Bukhu la Kukonzekera Page

1. Dinani pa Tsambalo la Tsamba la tsamba;
2. Dinani pa Kukhazikitsa Tsamba la bokosi la bokosi la bokosi kuchokera pa menyu kuti mutsegule tsamba la Kukhazikitsa Page ;
3. Mu bokosi la bokosi, sankhani Tsambalo / Mutu Woponda ;
4. Sankhani kuchokera pazokonzedweratu kapena mwambo wotsatila - zosankha za mapazi monga zikuwonetsedwa pa chithunzi pamwambapa;
5. Dinani OK kuti mutseke bokosi la dialog;
6. Mwachikhazikitso, mitu yoyamba ndi mazondomeko amakhazikitsidwa pa tsamba lokumbukira;
7. Onetsani mutu wa mutu / phazi mu Kuwonetsa kwa Print .

Zindikirani : Mutu wamakono ndi maulendo angathe kuwonjezeredwa mu bokosi la bokosi mwa kudalira makutu a Custom Custom kapena footer - akuwonetsedwa mu chithunzi pamwambapa.

Kuwona Mutu kapena Mapepala mu Kuwonekera kwa Zithunzi

Dziwani : Muyenera kukhala ndi chosindikiza chosungidwa pa kompyuta yanu kuti mugwiritse ntchito Kuwonekera kwa Print.

1. Dinani pa Fayilo menyu kuti mutsegule masewera otsika a zosankha;
2. Dinani ku Print mu menyu kuti mutsegule mawindo osindikiza;
3. Tsamba lamakono lamakono lidzawoneka pazithunzi zowonekera pazenera.

Kuchotsa Mutu kapena Mapazi

Kuti muchotse mutu uliwonse ndi / kapena zolemba kuchokera pa tsamba, gwiritsani ntchito ndondomeko pamwambapa powonjezera mutu ndi zolemba pogwiritsira ntchito Tsamba la Tsamba la Tsamba ndikutsitsa zomwe zilipo pamutu / pamutu.

Kuchotsa pamutu ndi / kapena pamapepala kuchokera ku maofesi osiyanasiyana nthawi yomweyo:

1. Sankhani mapepala;
2. Dinani pa Tsambali la Tsamba la Tsamba;
3. Dinani pa Kukhazikitsa Tsamba la bokosi la bokosi la bokosi kuchokera pa menyu kuti mutsegule tsamba la Kukhazikitsa Page ;
4. Mu bokosi la bokosi, sankhani Tsambalo / Mutu Woponda ;
5. Sankhani (palibe) mu mutu wokonzedweratu ndi / kapena bokosi lapansi;
6. Dinani OK kuti mutseke bokosi la dialog;
7. Zonse zomwe zili pamutu ndi / kapena zolemba ziyenera kuchotsedwa kumasamba omwe amasankhidwa.