Mapangidwe Okhazikika mu Excel

Mapangidwe okhazikika mu Excel amasintha mawonekedwe a selo kutengera zomwe zili mkati mwake. Mwachitsanzo, mutha kuwunikira ma cell ofiira omwe ali ndi zinthu zolakwika. Phunziroli liyang'ana kwambiri pamapangidwe azikhalidwe, chimodzi mwazinthu zosangalatsa komanso zothandiza mu Excel.

Tangoganizani kuti muli ndi pepala la Excel lomwe lili ndi mizere chikwi cha data. Ndikuganiza kuti zikhala zovuta pakati pazidziwitso zonse izi kuzindikira mawonekedwe kapena zofunikira. Monga matchati ndi mizere yong'ambika, masanjidwe okhazikika amakuthandizani kuwona m'maganizo mwanu zambiri ndikupangitsa kuti zikhale zosavuta kuziwerenga.

Kumvetsetsa Conditional Formatting

Kupanga kokhazikika mu Excel kumakupatsani mwayi wopanga ma cell potengera zomwe ali nazo. Kuti muchite izi, muyenera kupanga malamulo okhazikika. Lamulo likhoza kumveka motere: "Ngati mtengo uli wochepera $2000, mtundu wa selo ndi wofiira." Pogwiritsa ntchito lamuloli, mutha kuzindikira mwachangu maselo okhala ndi ndalama zosakwana $2000.

Pangani lamulo lokhazika mtima pansi

Muchitsanzo chotsatirachi, tsamba la Excel lili ndi zogulitsa za miyezi inayi yapitayi. Tiyerekeze kuti tikufuna kudziwa kuti ndi ogulitsa ati omwe akukwaniritsa zomwe akufuna kugulitsa pamwezi ndi omwe sali. Kuti mumalize dongosololi, muyenera kugulitsa zoposa $4 pamwezi. Tiyeni tipange lamulo lokhazikika lomwe lingasankhe ma cell onse patebulo okhala ndi mtengo wopitilira $4000.

1. Sankhani ma cell omwe mukufuna kuwona. Kwa ife, uwu ndi mtundu wa B2:E9.
2. Pa Advanced tabu Kunyumba press command Njira Zakukonzerani. Menyu yotsitsa idzawonekera.
3. Sankhani lamulo lofuna kusamalidwa lokhazikika. Tikufuna kuwunikira ma cell omwe mtengo wake Zambiri $ 4000.
4. A dialog box adzaoneka. Lowetsani mtengo wofunikira. Kwa ife, izi 4000.
5. Tchulani kalembedwe ka masanjidwe kuchokera pamndandanda wotsikira pansi. Tidzasankha Zobiriwira zobiriwira ndi zolemba zobiriwira zakuda… Kenako dinani OK.
6. Mapangidwe okhazikika adzagwiritsidwa ntchito pamaselo osankhidwa. Tsopano mutha kuwona kuti ndi ogulitsa ati omwe amaliza dongosolo la pamwezi la $4000.

Mutha kugwiritsa ntchito malamulo angapo okhazikika pama cell angapo nthawi imodzi, zomwe zimakupatsani mwayi wosinthika ndikuwona zomwe mukufuna.

Chotsani zosunga zokhazikika

1. Kankhani lamulo Njira Zakukonzerani. Menyu yotsitsa idzawonekera.
2. Sunthani cholozera cha mbewa pa chinthucho Chotsani Malamulo ndikusankha malamulo omwe mukufuna kuchotsa. Mu chitsanzo chathu, tidzasankha Chotsani malamulo papepala lonsekuti muchotse masanjidwe onse okhazikika patsamba lantchito.
3. Mapangidwe okhazikika adzachotsedwa.

Mukhoza kusankha chinthu Kasamalidwe ka malamulokuti muwone malamulo onse okhazikika opangidwa patsamba lino kapena pazosankha. Conditional Formatting Rules Manager amakulolani kuti musinthe kapena kufufuta malamulo achikhalidwe. Izi ndizothandiza makamaka ngati mwapanga malamulo angapo papepala lomwelo.

Preset Conditional Formatting Styles

Excel imabwera ndi masitaelo omwe adafotokozedweratu omwe mungagwiritse ntchito kuti mugwiritse ntchito masanjidwe okhazikika pa data yanu. Iwo agawidwa m'magulu atatu:

1. Гmbiri ndi mipiringidzo yopingasa yowonjezedwa ku selo iliyonse ngati tchati chosanjikiza.
2. Mamba amitundu sinthani mtundu wa selo lililonse kutengera zomwe ali nazo. Mtundu uliwonse umagwiritsa ntchito gradient yamitundu iwiri kapena itatu. Mwachitsanzo, mumtundu wa Red-Yellow-Green color, zotsika kwambiri zimawonetsedwa zofiira, zapakati pamtundu wachikasu, komanso zocheperako zobiriwira.
3. Chizindikiro chimakhalas onjezani zithunzi zapadera ku selo iliyonse kutengera makonda awo.

Kugwiritsa ntchito masitayelo okonzedweratu

1. Sankhani maselo kuti mupange lamulo lokhazikika.
2. Kankhani lamulo Njira Zakukonzerani. Menyu yotsitsa idzawonekera.
3. Yendetsani mbewa yanu pagulu lomwe mukufuna, kenako sankhani kalembedwe kake.
4. Mapangidwe okhazikika adzagwiritsidwa ntchito pamaselo osankhidwa.