Ho fihlela joale, ka linako tse ling ka pososelo ke hopola e 'ngoe ea lithupelo tsa ka tsa pele tsa khoebo lilemong tse 10 tse fetileng.
Imagine: the open space office of the representative office of an international FMCG company, huge as a football field. Chic design, expensive office equipment, dress code, expats cooing in the corners â thatâs all ð In one of the meeting rooms, I start a two-day advanced training on the then current version of Excel 2003 for 15 key employees of the economic department, along with their leader. We get acquainted, I ask them about business tasks, problems, I ask them to show several typical work files. They show the kilometer length of unloading from SAP, the sheets of reports that they make on this, etc. Well, itâs a familiar thing â I mentally figure out topics and timing, adjust to the audience. Out of the corner of my eye, I notice how one of the participants, demonstrating a piece of his report, patiently pulls the cell with the formula down by the black cross in the lower right corner for several thousand lines, then skips the end of the table on the fly, pulls it back, etc. Unable to stand it, I interrupt him curling the mouse around the screen and show a double-click on the black cross, explaining about auto-completion down to the stop.
Hang-hang kea hlokomela hore bamameli ba khutsitse ka mokhoa o belaetsang âme bohle ba nchebile ka mokhoa o makatsang. Ke qamaka hohle moo nka khonang - ntho e 'ngoe le e 'ngoe e lokile, matsoho le maoto a ka a teng, ntsintsi ea ka e konopile. Ke khutlisa mantsoe a ka a ho qetela kelellong ha ke batla poleloana e mpe - ho ne ho se letho la botlokotsebe, ho bonahala. Ka morâa moo, hlooho ea sehlopha sena ea ema ka lenyele, e ntÅ¡oara ka letsoho âme e re ka sefahleho sa lejoe: âKea leboha, Nikolai. Koetliso ena e ka phethoa.
Hantle, ka bokhuts'oane, ho ile ha fumaneha hore ha ho le ea mong oa bona ea neng a e-na le leseli la ho penya habeli sefapanong se setÅ¡o le ho tlatsa ka boits'oaro. Ho ile ha etsahala ka tsela e itseng historing hore ho ne ho se motho ea ka ba bontÅ¡ang ntho e bonolo empa e hlokahalang. Lefapha lohle le ile la hula litlhahlobo tsa mela e likete, batho ba futsanehileng. Mme ke nna enwa. Sebaka sa oli. Hlooho ea lefapha e ile ea botsa haholo hore e se ke ea senola lebitso la k'hamphani ea bona ho mang kapa mang ð
Ka makhetlo a 'maloa hamorao ho ne ho e-na le maemo a tšoanang, empa feela ka bamameli ka bomong - boholo ba hona joale, ha e le hantle, ba tseba mosebetsi ona.
Potso e fapane. Kamora thabo ea pele ea ho tseba karolo e ntle hakana, basebelisi ba bangata ba utloisisa hore ho kopitsa liforomo ka boiketsetso ka ho tobetsa habeli sefapanong se setšo (autocomplete marker) ho na le lintlha tsohle tse ntle le tse mpe:
- Ho kopitsa ha se kamehla ho etsahalang qetellong ea tafole. Haeba tafole e se monolithic, ke hore ho na le lisele tse se nang letho likholomong tse haufi, joale ha se 'nete ea hore autocomplete e tla sebetsa ho fihlela qetellong ea tafole. Mohlomong, ts'ebetso e tla emisa seleng e haufi e se nang letho pele e fihla pheletsong. Haeba ho na le lisele tse hapiloeng ke ntho e ka tlase ho kholomo, autocomplete e tla emisa ho tsona hantle.
- Ha o kopitsa seleng moralo senya, hobane Ka kamehla, ha se foromo feela e kopitsoang, empa hape le sebopeho. Ho lokisa, tobetsa konopo ea likhetho ebe u khetha Feela litekanyetso (Tlatsa ntle le sebopeho).
- Ha ho na mokhoa o potlakileng oa ho otlolla foromo ka mokhoa o bonolo eseng tlase empa ho le letonahaese ho hula ka letsoho. Ho tobetsa habeli sefapanong se setšo ho theohile feela.
Ha re leke ho lokisa mefokolo ena ka macro e bonolo.
Tobetsa ho khaoletsa keyboard ka ho le letÅ¡ehali Alt + F11 kapa konopo Visual Basic tab ya Moqapi (Moetsi). Kenya module e ncha e se nang letho ka menu Kenya â Mojule 'me u kopitse mongolo oa li-macros tsena moo:
Sub SmartFillDown() Dim rng As Range, n As Long Set rng = ActiveCell.Offset(0, -1).CurrentRegion If rng.Cells.Count > 1 Then n = rng.Cells(1).Row + rng.Rows. Bala - ActiveCell.Row ActiveCell.AutoFill Destination:=ActiveCell.Resize(n, 1), Type:=xlFillValues ââEnd If End Sub Sub SmartFillRight() Dim rng As Range, n As Long Set rng = ActiveCell.Offset(-1, 0).CurrentRegion If rng.Cells.Count > 1 Joale n = rng.Lisele(1).Column + rng.Columns.Count - ActiveCell.Column ActiveCell.AutoFill Destination:=ActiveCell.Resize(1, n), Type: =xlFillValues ââEnd If End Sub
Li-macros tse joalo:
- e ka tlatsa eseng feela fatše (SmartFillDown), empa hape le ka ho le letona (SmartFillRight)
- u se ke ua senya sebopeho sa lisele tse ka tlase kapa ka ho le letona - ho kopitsoa foromo feela (boleng).
- lisele tse se nang letho tse haufi li hlokomolohuoa 'me ho kopitsa ho etsahala hantle ho fihlela qetellong ea tafole,' me eseng ho lekhalo le haufi le data kapa sele ea pele e tšoaretsoeng.
Bakeng sa boiketlo bo boholo, o ka abela likhechana tsa keyboard ho li-macros tsena o sebelisa konopo Macros - Likhetho (Macros - Likhetho) hona moo ho tab. Moqapi (Moetsi). Joale ho tla lekana ho kenya foromo kapa boleng boo u bo batlang ka seleng ea pele ea kholomo ebe o tobetsa konopo e boletsoeng hore macro e tlatse kholumo kaofela (kapa mola) ka bo eona:
Botle.
PS Karolo ea bothata ba ho kopitsa liforomo ho fihlela qetellong ea tafole e ile ea rarolloa ho Excel 2007 ka ho fihla ha "litafole tse bohlale". Ke 'nete hore hase kamehla li loketseng 'me ha lia tšoanela hohle. Mme ka ho le letona, Excel ha ho mohla e kileng ea ithuta ho kopitsa e le mong.
- Li-macros ke eng, li sebelisoa joang, u ka fumana Visual Basic code hokae le hore na u ka e beha hokae.
- Litafole tse bohlale ho Excel 2007-2013
- Kopitsa liforomo ntle le ho fetola lihokelo