Ho hlahisa likhahla ka ntle ho Excel 2003

01 ea 05

Li-columns tsa ho thibela le mela e Excel le li-Panels Freeze

Ka linako tse ling ho thata ho bala le ho utloisisa li- spreadsheet tse kholo haholo. Ha u phalla hōle ho ea ka ho le letona kapa ka tlase, u lahleheloa ke lihlooho tse ka holimo le ho theoha ka lehlakoreng le letšehali la leqephe . Ntle le lihlooho, ho thata ho boloka lethathamo la hore na ke hokae moo u shebahalang teng.

Ho qoba bothata bona sebelisa marang-rang a hlahisoang ke Microsoft Excel. E nolofalletsa ho "senya" libaka tse ling kapa marang-rang a spreadsheet e le hore ba lule ba bonahala ka linako tsohle ha ba ntse ba phallela ka ho le letona kapa ka tlaase. Ho boloka lihlooho tse skrineng ho etsa hore ho be bonolo ho bala lintlha tsa hau ho pholletsa le spreadsheet eohle.

Thuto e amanang le eona: Excel 2007/2010 Mahlaseli a Khabiso .

02 ea 05

Ho hlahisa likhahla tse fapaneng ho sebelisa Cell e sebetsang

Ha o bula Freeze Panes Excel, mela eohle e ka holimo ho sele e sebetsang le melahare eohle ho ea ka letsohong le letšehali la sele e sebetsang e fetohile leqhoa.

Ho tobetsa feela litšiea le mela eo u batlang ho lula ho eona skrineng, tobetsa seleng ho ea ka ho le letona ho mela e ka tlaase ho mela eo u batlang ho lula ho eona skrineng.

Mohlala - ho boloka mela e 1,2, le tse 3 skrineng le lihlopha A le B, tobetsa ka seleng ea C4 le mouse. Ebe o khetha Window> Freeze Panes ho tloha menu, joalokaha ho bontšitsoe setšoantšong se ka holimo.

U hloka thuso e eketsehileng?

Ka mor'a moo, ke mohato o khutšoanyane oa mehlala ea hau o bontšang kamoo u ka sebelisang karolo ea mahala ho Microsoft Excel.

03 ea 05

U sebelisa Excel Auto Fill

Ho etsa hore ho behoa holimo ho bontšang pontšo e tsotehang haholoanyane, re tla kena ka potlako ka boitsebiso ka ho tlatsa Auto Fill e le hore ho le bonolo ho bona liphello tsa likhahlopha tsa mariha.

Tlhokomeliso: Thupelo ea ho etsa Tlhahlobo ea Excel Auto Fill e bontša hore na u ka eketsa lethathamo la hau joang la ho tlatsa Auto.

1. Tšoara "January" ka seleng ea D3 'me u tobetse ENTER ka lebokose.
2. Khetha seleng D3 mme u sebelise sebetsana se tlala sekhutlong se ka tlaase sa lisele tsa D3 ho auto ho tlatsa likhoeli tsa selemo tse qetellang ka October ka seleng ea M3.
3. Tšoara "Mantaha" ka seleng ea C4 'me u hatelle ENTER .
4. Khetha seleng C4 mme u sebelise mochine o tletseng koloi ho tlatsa matsatsi a bekeng a qetang ka Labobeli ka seleng ea C12.
5. Ngola nomoro "1" ka seleng ea D4 le "2" ka seleng ea D5.
6. Khetha lisele tse peli D4 le D5.
7. Sebelisa mochine o tletseng ka seleng ea D5 ho auto u tlatse ho seleng ea D12
8. Lokolla konopo ea mouse.
9. Sebelisa sebetsana ho tlatsoa ka seleng ea D12 ho ea koloi ho tlatsa ho ea ka cell M12.

Linomoro tsa 1 ho ea ho tse 9 li lokela ho tlatsa melaolo ea D ho ea ho M.

04 ea 05

Ho khabisa likhahla

Hona joale bakeng sa karolo e bonolo:

1. Tobetsa seleng D4
2. Khetha Window

Ho tla hlaha mola o motso o pakeng pakeng tsa C le D le mola o lekaneng pakeng tsa mela 3 le 4.

Melao ea 1 ho ea ho ea 3 le mekhahlelo A ho ea ho C ke libaka tse batang tsa skrine.

05 ea 05

Sheba Litholoana

Sebelisa metsu ea meputso ho bona phello ea li-panes tse khanyang holim'a spreadsheet.

Phetla ka tlaase

• Sebelisa motsu oa moqolo o otlolohileng Excel ho phallela fatše. Melao ea 1 ho ea ho 3 e lokela ho lula skrineng, ho kenyeletsa likhoeli tsa selemo ha linomoro tsa 1 ho isa ho tse 9 li nyamela leqepheng la spreadsheet.

Khutlela seleng ea D4

1. Tobetsa lebokose la lebitso ka holimo ho lebokose A
2. Tšoaea D4 ka Lebitso la Lebokose 'me u tobetse ENTER ka lebokose. Sele e sebetsang e fetoha D4 hape.

Moqolo hohle

• Sebelisa motsu oa moqolo o hahiloeng ho ea ho le letona. Column A e lokela ho lula skrineng, ho kopanyelletsa le linomoro, ha likhoeli tsa selemo li nyamela leqepheng la spreadsheet.