Faka imigqa eminingi kuseli eyodwa ye-Excel

Uma udinga ukufaka inani elikhulu lombhalo kuseli eyodwa ye-Excel, khona-ke kuzoba yisixazululo esihle kakhulu sokuyihlela emigqeni eminingana. Kodwa kanjani? Phela uma ufaka umbhalo kuseli, utholakala kulayini owodwa, noma ngabe mude kangakanani. Okulandelayo, sizobonisa ukuthi ungafaka kanjani umugqa wombhalo ongaphezu kowodwa kunoma iyiphi iseli ekhasini lokusebenzela le-Excel.

Izinyathelo Ezi-5 Zokuthuthukisa Ukwakhiwa Kwedatha

Ake sithi ithebula lakho linekholomu enamagama abhalwe ngokugcwele. Ufuna ukwenza isiqiniseko sokuthi amagama okuqala nesibongo asemigqa ehlukene. Izinyathelo ezilandelayo ezilula zizokusiza ucacise ukuthi ukunqamuka komugqa kufanele kuye kuphi:

  • Chofoza kuseli lapho ufuna ukufaka khona imigqa eminingi yombhalo.
  • Faka umugqa wokuqala.
  • Cindezela inhlanganisela Alt+Enterukuze udale omunye umugqa kuseli.Chofoza I-Alt + Enter izikhathi ezimbalwa ngaphezulu ukuhambisa ikhesa lapho ofuna ukufaka khona umugqa olandelayo wombhalo.
  • Faka umugqa olandelayo wombhalo.
  • Ukuze uqedele ukufaka, cindezela Faka.

Khumbula inhlanganisela yokhiye kahle I-Alt + Enter, ngayo ungafaka ukunqamuka komugqa noma kuphi lapho ufuna kuseli, kungakhathaliseki ububanzi bawo.

shiya impendulo