Ho fetola pakeng tsa maqephe a Excel. Li-hotkeys

Hangata, basebelisi ba mohlophisi oa spreadsheet ba hloka ho etsa mokhoa oa ho fetola pakeng tsa maqephe. Ho na le mekhoa e mengata ea ho kenya ts'ebetsong mokhoa ona o bonolo. Ketso ena e tlameha ho khona ho e etsa maemong ao tokomane ea spreadsheet e nang le palo e kholo ea lipampiri tsa mosebetsi. Mekhoa ea ho fetola e kenyelletsa: ho sebelisa motsoako o khethehileng oa li-hotkey, ho sebelisa scroll bar, le ho tsamaea u sebelisa li-hyperlink. Sehloohong sena, re tla sekaseka e 'ngoe le e' ngoe ea mekhoa ka botlalo.

Mokhoa oa Pele: Ho Sebelisa Li-Hotkeys Tse Khethehileng

Li-hotkeys li u lumella ho kenya ts'ebetsong liketso tse fapaneng hang-hang ho mohlophisi oa spreadsheet. Ho kenya tšebetsong phetoho lipakeng tsa maqephe a mosebetsi, ho sebelisoa metsoako e 'meli ea linotlolo tse chesang:

• Motsoako oa pele: "Ctrl + Page Up".
• Motsoako oa bobeli: "Ctrl + Page Down".

Metsoako ena e 'meli e fana ka phetoho ea hang-hang pakeng tsa maqephe a mosebetsi a tokomane ea spreadsheet leqephe le le leng morao kapa ho ea pele.

Mokhoa ona o loketse haholo maemong ao buka ea tokomane e nang le palo e nyane ea lipampiri tsa mosebetsi. E boetse e ntle bakeng sa ho sebetsa le maqephe a haufi a tokomane ea spreadsheet.

Mokhoa oa Bobeli: Ho Sebelisa Sebaka se Tloaelehileng sa Meqolo

Mokhoa ona o eletsoa ho sebelisoa haeba tokomane ea spreadsheet e na le palo e kholo ea lipampiri tsa mosebetsi. 'Nete ke hore haeba ho na le maqephe a mangata faeleng, joale tšebeliso ea linotlolo tse khethehileng tse chesang li tla nka nako e ngata ea mosebedisi. Ka hona, e le ho boloka nako haholo, o hloka ho sebelisa sebaka sa moqolo se tlase ho sebopeho sa Excel spreadsheet. Taelo e qaqileng ea ho fetola maqephe u sebelisa scrollbar e shebahala tjena:

1. Re fetela botlaaseng ba sebopeho sa mohlophisi oa tafole. Mona re fumana bar e khethehileng ea moqolo.
2. Tobetsa ho scrollbar ka konopo e nepahetseng ea toeba.
3. Pontšo e bontšitse lenane le lenyenyane, le bontšang maqephe ohle a mosebetsi a tokomane ea spreadsheet.
4. Re fumana leqephe leo re le hlokang ebe re tobetsa ho lona LMB.

5. E lokile! Re kentse tšebetsong phetoho lipakeng tsa maqephe a mosebetsi a tokomane ea spreadsheet re sebelisa scroll bar.

Mokhoa oa Boraro: Ho Sebelisa Li-hyperlink ho Tokomane ea Spreadsheet

Mokhoa ona o thata o kenyelletsa ho theha leqephe la tlatsetso la tlatsetso, le tla ba le lethathamo la litaba tse ka sebelisoang ho sebelisoa li-hyperlink tse khethehileng. Li-hyperlink tsena li tla khutlisetsa mosebelisi maqepheng a hlokahalang a tokomane ea spreadsheet.

Mokhoa ona o na le liforomo tsa ho theha li-hyperlink. Lenane la mahokelo a dihokelo le thehwa ho sebediswa opareitara ya GET.WORKBOOK. Litaelo tse qaqileng li shebahala tjena:

1. Qalong, re fetela ho "Motsamaisi oa Lebitso". Re fetela karolong ea "Formulas", fumana "Mabitso a hlalositsoeng" thibela 'me u kenye lebitso le lecha moo, mohlala, "List_sheets". Moleng "Range:" kenya foromo e latelang: =PELEPELO(GET.BORKBOOK(1),1, FUMANA(“]”,GET.BUKA YA MOSEBETSI(1)),””).

2. E ka boela ea sebelisoa e le foromo =FUMANA.BOKGETHO(1), empa joale mabitso a maqephe a mosebetsi a tla ba le lebitso la buka (mohlala, [Book1.xlsb]Sheet1).
3. Re hlakola lintlha tsohle ho fihlela sekoahelong sa lisekoere tse koalang ka ho fetesisa, e le hore qetellong ho sala feela lebitso la leqephe la "Sheet1". E le hore re se ke ra kenya ts'ebetsong mokhoa ona nako le nako ha re fumana lintho tsa "List_sheets" tse feto-fetohang re sebelisa liforomo, re sebelisa nako ena e le 'ngoe bakeng sa ntho e' ngoe le e 'ngoe.
4. Ka lebaka leo, mabitso a maqephe ohle a mosebetsi a tokomane ea spreadsheet a fumaneha ka har'a mofuta o mocha oa "LIST_SHEETS". Ka mantsoe a mang, re na le lethathamo le khethehileng la boleng. Re hloka ho ntša litekanyetso tsena.
5. Ho kenya ts'ebetsong ts'ebetso ena, o tlameha ho sebelisa opereishene e khethehileng ea INDEX, e u lumellang ho fumana ntho e fapaneng ka nomoro ea serial. Ho feta moo, re sebelisa opareitara e bitsoang STRING ho etsa linomoro tse tloaelehileng.

6. Boemong bo latelang, ho theha mokhoa oa ho tsamaea o bonolo haholoanyane, re sebelisa HYPERLINK opareitara. Re tla kenya ts'ebetsong mokhoa oa ho kenyelletsa li-hyperlink ho mabitso a maqephe a mosebetsi.

7. Qetellong, li-hyperlink tsohle li tla lebisa ho sele ea A1, e tsamaellanang le lebitso la leqephe la mosebetsi la tokomane ea spreadsheet.

Ho phaella moo, o ka etsa leqephe le nang le li-hyperlink ho sebelisa puo e kopanetsoeng ea lenaneo VBA.

Litaelo tse qaqileng li shebahala tjena:

1. Tobetsa motsoako oa konopo "Alt + F11".
2. Re theha mojule o mocha.
3. Kenya khoutu e latelang moo:

   Lenane la Leqephe la Mosebetsi(N Joalo ka Linaha Tse Kopanetsoeng)

   Lethathamo la maqephe = ActiveWorkbook.Maqephe a Mosebetsi(N).Lebitso

   Qetella Mosebetsi.

4. Re khutlela sebakeng sa mosebetsi, re sebelisa lenaneo le bōpiloeng, re kenya ts'ebetsong ho bōptjoa ha lethathamo la lipampiri tsa litokomane. Ho etsa sena, joalo ka mohlala o kaholimo, re sebelisa opareitara ea ROW ho theha linomoro tse tloaelehileng.

5. Re etsa pheta-pheto ea ho eketsa li-hyperlink.

6. E lokile! Re thehile leqephe le u lumellang hore u fetole kapele pakeng tsa maqephe a mosebetsi ho tokomane ea spreadsheet.

Qetello le liqeto le ho fetola lipakeng tsa maqephe a mosebetsi

Re fumane hore ho na le mekhoa e mengata e u lumellang hore u fetole pakeng tsa maqephe a mosebetsi ho tokomane ea spreadsheet. O ka kenya ts'ebetsong ketso ena ka ho sebelisa linotlolo tse chesang tse khethehileng, li-bar scrollbar, le ho theha li-hyperlink. Li-hotkeys ke mokhoa o bonolo ka ho fetisisa oa ho fetola, empa ha o tšoanelehe ho sebetsa ka boitsebiso bo bongata. Haeba tokomane ea spreadsheet e na le palo e kholo ea data ea tabular, joale ho loketse haholo ho sebelisa pōpo ea li-hyperlink, hammoho le mekoallo ea moqolo.