Loaʻa iā ʻoe nā faila me nā pepa he nui? He nui maoli - he mau kakini? ʻO ka hele ʻana i ka ʻaoʻao ʻākau i loko o ia puke hiki ke hoʻonāukiuki - a hiki i ka wā e ʻike ai ʻoe i ka ʻaoʻao ʻaoʻao kūpono, a hiki i kou kaomi ʻana ma luna ...
Hana 1. Nā kī wela
Nā hui Ctrl+PgUp и Ctrl+PgDown hiki iā ʻoe ke hoʻohuli koke i kāu puke i hope a i waho.
Kaʻina 2. Ka hoʻololi ʻana i ka ʻiole
E kaomi wale ka pono kaomi i nā pihi ʻōwili ma ka ʻaoʻao hema o nā ʻaoʻao pepa a koho i ka pepa i makemake ʻia:
Maʻalahi a nani. Hana ma nā mana a pau o Excel.
Keʻano 3. Papa o nā mea
He hana paʻakikī kēia ʻano, akā nani. ʻO kāna kumu, ʻo ka hana ʻana i kahi pepa kūikawā me nā loulou e alakaʻi ana i nā pepa ʻē aʻe o kāu puke a hoʻohana iā ia ma ke ʻano he "ola" papa o nā ʻike.
E hoʻokomo i kahi pepa ʻole i loko o ka puke a hoʻohui i nā loulou i nā pepa āu e pono ai me ke kauoha Hoʻokomo – Hyperlink (Hoʻokomo - Hyperlink):
Hiki iā ʻoe ke hoʻonohonoho i ka kikokikona i hōʻike ʻia i loko o ke kelepona a me ka helu wahi o ke kelepona kahi e kaomi ai i ka loulou.
Inā he nui nā lau a ʻaʻole makemake ʻoe e hana i kahi hui o nā loulou me ka lima, a laila hiki iā ʻoe ke hoʻohana i ka macro i mākaukau no ka hana ʻana i kahi papa o nā mea.
- Pehea e hana ai i papa ʻikepili no kahi puke hana Excel e hoʻokele wikiwiki i ka pepa i makemake ʻia
- Hana ʻakomi i kahi papa puke o nā ʻike ma kahi pepa ʻokoʻa me nā loulou (PLEX add-on)