E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole

Hāʻawi ʻo Excel i nā mea hana he nui e kāohi i ke ʻano o kahi puke hana. Ma ka haʻawina hope loa, ua aʻo mua mākou pehea e hoʻomaloʻo ai i nā lālani a me nā kolamu. Ma kēia, e noʻonoʻo mākou i kekahi mau mea hana e hiki ai iā ʻoe ke hoʻokaʻawale i kahi pepa i kekahi mau ʻāpana, a me ka nānā ʻana i kahi palapala ma nā puka makani like ʻole.

Inā loaʻa i kahi puke hana Excel ka nui o ka ʻikepili, paʻakikī paha ka palapala ʻana i nā ʻāpana like ʻole. Loaʻa iā Excel nā koho ʻē aʻe e maʻalahi ai ka hoʻomaopopo a hoʻohālikelike i ka ʻikepili. No ka laʻana, hiki iā ʻoe ke wehe i kahi puke ma kahi puka aniani hou a i ʻole e hoʻokaʻawale i kahi pepa i nā wahi ʻokoʻa.

Ke wehe nei i ka puke o kēia manawa ma ka puka makani hou

Hiki iā Excel ke wehe i ka puke hana like ma nā puka makani he nui i ka manawa like. Ma kā mākou laʻana, e hoʻohana mākou i kēia hiʻohiʻona e hoʻohālikelike i ʻelua pepa hana like ʻole i ka puke hana like.

  1. E kaomi i ka View ma ka Ribbon, a laila koho i ke kauoha pukaaniani hou.
  2. E wehe ʻia kahi puka makani hou no ka puke o kēia manawa.E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole
  3. I kēia manawa hiki iā ʻoe ke hoʻohālikelike i nā pepa o ka puke like ma nā puka makani like ʻole. Ma kā mākou laʻana, e koho mākou i ka hōʻike kūʻai 2013 e hoʻohālikelike i nā kūʻai ma 2012 a me 2013.E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole

Inā loaʻa iā ʻoe nā puka makani he nui, hiki iā ʻoe ke hoʻohana i ke kauoha Hoʻonohonoho i nā mea a pau no ka hui wikiwiki o nā puka makani.

E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole

E hoʻokaʻawale i kahi lau i nā wahi ʻokoʻa

Hiki iā Excel ke hoʻohālikelike i nā ʻāpana o ka pepa hana like me ka hana ʻole i nā puka makani hou. Hui Māhele hiki iā ʻoe ke hoʻokaʻawale i ka pepa i nā wahi ʻokoʻa i hiki ke ʻōwili kūʻokoʻa i kekahi i kekahi.

  1. E koho i ke kelepona kahi āu e makemake ai e hoʻokaʻawale i ka pepa. Inā kohoʻoe i kahi pūnaewele ma ke kolamu mua a iʻole ka lālani mua, a laila e māheleʻia ka pepa i 2 mau'āpana, iʻole e māheleʻia i 4. Ma kā mākou hiʻohiʻona, e koho mākou i ka cell C7.E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole
  2. E kaomi i ka View ma ka Ribbon, a laila kaomi i ke kauoha Māhele.E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole
  3. E hoʻokaʻawale ʻia ka lau i nā ʻāpana he nui. Hiki iā ʻoe ke ʻōwili i kēlā me kēia wahi me ka hoʻohana ʻana i nā scrollbars. Hiki iā ʻoe ke hoʻohālikelike i nā ʻāpana like ʻole o ka pepa like.E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole

Hiki iā ʻoe ke kauo i nā mea hoʻokaʻawale kūpaʻa a me ke ākea e hoʻololi i ka nui o kēlā me kēia ʻāpana. No ka wehe ʻana i ka māhele, kaomi hou i ke kauoha Māhele.

Waiho i ka Reply