Sankhani Maselo Osadziwika ku Excel Ndiyiyi ya Keyboard ndi Mouse

Pogwiritsa ntchito maselo angapo mu Excel mungathe kuchotsa deta, kugwiritsa ntchito maonekedwe monga malire kapena shading, kapena kugwiritsa ntchito njira zina kumadera akulu a tsambali panthawi imodzi.

Pamene mukukoka ndi mbewa kuti muwonetsetse msangamsanga maselo omwe ali pafupi ndi njira yofala kwambiri yosankhira selo imodzi, nthawi zina maselo omwe mukufuna kuwunikira sakupezeka pambali pawo.

Izi zikachitika, ndizotheka kusankha maselo osayandikana nawo. Ngakhale kusankha maselo osayandikana kungakhoze kuchitidwa kokha ndi kambokosi monga momwe tawonetsera m'munsimu, ndi kosavuta kugwiritsa ntchito kambokosi ndi mbewa palimodzi.

Kusankha Maselo Osakhala Odziwika mu Excel Ndi Keyboard ndi Mouse

1. Dinani pa selo yoyamba yomwe mukufuna kusankha ndi pointer ya mouse kuti mupange selo yogwira ntchito .
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani pa maselo ena onse omwe mukufuna kuwasankha popanda kumasula makiyi a Ctrl.
4. Pamene maselo onse okhudzidwa asankhidwa, kumasula makiyi a Ctrl.
5. Musayang'ane kwina kulikonse ndi ndondomeko ya mouse pokhapokha mutamasula makina a Ctrl kapena mutsegula chotsaliracho kuchokera kumaselo osankhidwa.
6. Ngati mutsegula makiyi a Ctrl mofulumira ndipo mukufuna kufotokoza maselo ambiri, imanikani ndi kubwezeretsanso Ctrl fungulo ndiyeno dinani zina (s) zina

Sankhani Maselo Osadziwika mu Excel Pogwiritsa Ntchito Chibodi Chokha

Masitepe omwe ali pansipa posankha maselo akugwiritsa ntchito kamphindi chabe.

Kugwiritsira ntchito Keyboard mu Njira Yowonjezera

Kusankha maselo osakhala pafupi ndi kamphindi kokha kukufuna kuti mugwiritse ntchito makinawo mu Njira Yowonjezera.

Njira yowonjezera imatsegulidwa mwa kukanikiza F8 key pa ikhibhodi. Mukhoza kutseka mawonekedwe otalikira mwa kukanikiza makiyi a Shift ndi F8 pa kibokosi pamodzi.

Sankhani Maselo Osakwatiwa Osakhala Odziwika mu Excel Pogwiritsira Ntchito Keyboard

1. Sungani selojekiti yanu ku selo yoyamba yomwe mukufuna kusankha.
2. Dinani ndi kumasula f8 fungulo pa makina kuti muyambe Njira Yowonjezera ndikuwonetsa selo yoyamba.
3. Popanda kusuntha cholozera cha selo, pezani ndi kumasula makiyi a Shift + F8 pa kibokosi pamodzi kuti mutsegule njira yowonjezera.
4. Gwiritsani ntchito mafungulo pa makiyi kuti musunthire selojekiti ku selo yotsatira yomwe mukufuna kuti muyike.
5. Selo yoyamba iyenera kukhala yosonyeza.
6. Ndi selo ya selo pa selo yotsatira kuti iwonetseredwe, bweretsani masitepe 2 ndi 3 pamwambapa.
7. Pitirizani kuwonjezera maselo ku mapulaneti ofunika kwambiri pogwiritsa ntchito mafungulo a F8 ndi Shift + F8 kuti muyambe ndi kuyima mawonekedwe opitilira.

Kusankha Magetsi Osavuta ndi Osakhala Odziwika mu Excel Pogwiritsa Ntchito Keyboard

Tsatirani ndondomeko ili m'munsiyi ngati mtundu umene mukufuna kuusankha uli ndi osakaniza a maselo omwe ali pafupi ndi omwe akuwonetsedwa pa chithunzi pamwambapa.

1. Sungani selojekiti ku selo yoyamba mu gulu la maselo omwe mukufuna kuwunikira.
2. Limbikirani ndi kumasula F8 key pa kibokosiyi kuti muyambe Njira Yowonjezera.
3. Gwiritsani ntchito makiyi a fungulo pa kibokosilo kuti muwonjezere mtundu womwe ulipo kuti muphatikize maselo onse mu gululo.
4. Ndi maselo onse a gululo akusankhidwa ndi kutulutsa Shift + F8 makiyi pa kibokosi pamodzi kuti mutsegule njira yowonjezera.
5. Gwiritsani ntchito mafungulo pa makiyi kuti musunthire selololo kuchoka ku gulu la osankhidwa.
6. Gulu loyambirira la maselo liyenera kukhala likuyikidwa.
7. Ngati pali magulu ambiri omwe mumagwiritsa ntchito, mukufuna kusunthira ku selo yoyamba mu gulu ndikubwezeretsanso masitepe 2 mpaka 4 pamwambapa.
8. Ngati pali maselo omwe mukufuna kuwonjezera pazithunzizi, gwiritsani ntchito malangizo oyambirira pamwambapa kuti muwonetsere maselo okhaokha.