Tse ka Hare
bothata
A re re re na le tafole e bonolo e kang ena, eo ho eona ho baloang lichelete bakeng sa khoeli le khoeli metseng e 'meli, ebe kakaretso e fetoloa li-euro ka tekanyo e tsoang ho sele e mosehla J2.
Bothata ke hore haeba u kopitsa lethathamo la D2: D8 le liforomo kae-kae leqepheng, joale Microsoft Excel e tla lokisa lihokelo tsa liforomo tsena, e li ise sebakeng se secha ebe e emisa ho bala:
Mosebetsi: kopitsa mefuta e mengata ka liforomo e le hore liforomo li se ke tsa fetoha 'me li lule li tšoana, ho boloka liphetho tsa lipalo.
Mokhoa oa 1. Lihokelo tse felletseng
Mokhoa oa 2: Koala liforomo ka nakoana
Ho thibela liforomo ho fetoha ha o kopitsa, o hloka (ka nakoana) etsa bonnete ba hore Excel e emisa ho li nka joalo ka liforomo. Sena se ka etsoa ka ho nkela lets'oao le lekanang (=) sebaka le sebopeho sefe kapa sefe se sa fumaneheng ka tloaelo liforomong, joalo ka lets'oao la hash (#) kapa li-ampersand (&&) bakeng sa nako ea kopi. Molemong oa sena:
- Khetha mefuta e nang le liforomo (mohlala oa rona D2:D8)
- Click Ctrl + H keyboard kapa ho tab Lehae - Fumana 'me U Khethe - Fetola (Lehae - Fumana & Khetha - Fetola)
- Ka lebokoseng la puisano le hlahang, kenya seo re se batlang le seo re se nkelang sebaka, le ho entsprechen (Dikgetho) seke oa lebala ho hlakisa Sebaka sa ho batla - Liforomo. Re hatella Tlosa kaofela (Fetola tsohle).
- Kopitsa lethathamo la sephetho ka liforomo tse koetsoeng sebakeng se nepahetseng:
- Kenya sebaka # on = khutlela ho sebelisa fensetere e ts'oanang, ho khutlisetsa ts'ebetso ho liforomo.
Mokhoa oa 3: Kopitsa ka Notepad
Mokhoa ona o potlakile haholo ebile o bonolo.
Tobetsa khaoletso ea keyboard Ctrl+Ё kapa konopo Hlahisa liforomo tab ya moralo (Liforomo - Bontša mekhoa), ho bulela mokhoa oa ho hlahloba foromo - sebakeng sa liphetho, lisele li tla bonts'a liforomo tseo li baloang ka tsona:
Kopitsa mefuta ea rona ea D2: D8 'me u e kenye ka mokhoa o tloaelehileng Lethathamo:
Joale khetha ntho e 'ngoe le e' ngoe e kentsoeng (Ctrl + A), e kopitse lebokoseng la lipapali hape (Ctrl + C) 'me ue behe pampiring sebakeng seo u se hlokang:
E sala feela ho tobetsa konopo Hlahisa liforomo (Bontša liforomo)ho kgutlisetsa Excel mokgweng o tlwaelehileng.
Tlhokomeliso: ka linako tse ling mokhoa ona o hlōleha litafoleng tse rarahaneng tse nang le lisele tse kopantsoeng, empa maemong a mangata a sebetsa hantle.
Mokhoa oa 4. Macro
Haeba hangata o tlameha ho etsa kopi e joalo ea liforomo ntle le ho fetola litšupiso, hoa utloahala ho sebelisa macro bakeng sa sena. Tobetsa ho khaoletsa keyboard Alt + F11 kapa konopo Visual Basic tab ya Moqapi (Moetsi), kenya mojule o mocha ka har'a menu Kenya – Mojule 'me u kopitse mongolo oa macro ena moo:
Sub Copy_Formulas() Dim copyRange As Range, pasteRange As Range On Error Resume Next Set copyRange = Application.InputBox("Khetha lisele tse nang le liforomo ho kopitsa.", _ "Kopitsa liforomo hantle", Default:=Khetho.Aterese, Mofuta := 8) Haeba copyRange E se Letho Joale Tsoa Sub Set pasteRange = Application.InputBox("Joale khetha mofuta oa ho peista." & vbCrLf & vbCrLf & _ "Lethathamo le tlameha ho lekana ka boholo le mofuta oa pele " & vbCrLf & _" oa lisele. ho kopitsa." , "Kopitsa liforomo hantle", _ Default:=Selection.Address, Type:=8) Haeba pasteRange.Cells.Count <> copyRange.Cells.Count Ebe MsgBox "Kopitsa le ho peista meqolo e fapana ka boholo!", vbTlhaloso, "Copy error" Tsoa ho Sub End Haeba pasteRange e se letho Ebe U Tsoa ho Sub Else pasteRange.Formula = copyRange.Formula End If End Sub
U ka sebelisa konopo ho tsamaisa macro. makhro tab ya Moqapi (Moetsi - Macros) kapa khaoletso ea keyboard Alt + F8. Kamora ho tsamaisa macro, e tla u kopa hore u khethe mofuta o nang le liforomo tsa mantlha le mofuta oa ho kenya 'me o tla kopitsa liforomo ka bohona:
- Ho shebella liforomo le liphetho habonolo ka nako e le 'ngoe
- Hobaneng ha mokhoa oa referense oa R1C1 o hlokahala ho liforomo tsa Excel
- Mokhoa oa ho fumana kapele lisele tsohle tse nang le liforomo
- Sesebelisoa sa ho kopitsa liforomo tse hlakileng ho tsoa ho tlatsetso ea PLEX