Page 112 - FUNDAMENTALS OF COMPUTER

112 Fundamentals of Computers NPP

Fig. 2.34: Cell 'B2'

2.20 Editing cells 2.20 goëg H$s E{S>qQ>J
If we want to edit the contents of a cell we `{X Amn goc Ho$ H§$Q>|Q²>g H$mo E{S>Q> H$aZm MmhVo h¢
will have to set the Excel in 'Edit mode'. When Vmo AmnH$mo EŠgoc H$mo 'E{S>Q> _moS>' _| goQ> H$aZm hmoJm& O~
the cell is in the Edit mode the word 'Edit'
appears in the bottom left corner of Excel goc E{S>Q> _moS> _| ahoJm {MÌ-2.35 _| Xem©E AZwgma
window as in fig-2.35. NPP EŠgoc Ho$ ~m°Q>_ coâQ> H$m°Z©a _| E{S>Q> eãX {XI OmEJm&

Fig. 2.35: 'Edit' word to show that the cell is in edit mode
There are two ways the contents of the cell goc Ho$ H§$Q>|Q²>g H$mo Xmo àH$ma go E{S>Q> {H$`m Om
can be edited. The simplest way is to click on gH$Vm h¡& gac {d{Y `h h¡ {H$ Cn`wŠV goc na pŠcH$
the desired cell and then click on the formula H$a|, ~mX _| \$m°_y©cm ~ma na pŠcH$ H$a|& A~ h_ \$m°_y©cm
bar. Now, we can edit the contents of the cell in ~ma _| goc Ho$ H§$Q>oQ²>g H$mo E{S>Q> H$a gH$Vo h¢& Omo ^r h_
the formula bar. Whatever we type, is entered
in the cell. Another method is to edit directly in Q>mBn H$a|, goc _| B§Q´>r hmoJr& AÝ` {d{Y go goc _| S>m`aoŠQ>
the cell. For that double click on the desired cell E{S>Q> H$a gH$Vo h¢& CgHo$ {cE Ano{jV goc na S>~c
and start editing the contents within the cell. {ŠcH$ H$a| VWm goc Ho$ A§Xa H§$Q>|Q²>g H$mo E{S>Q> H$aZm
Another way is to click on the cell and press F2. àma§^ H$a|& AÝ` {d{Y _| goc na pŠcH$ H$a| Ed§ F-2 àog
For editing the contents directly in the cell, we H$a|& goc _| S>m`aoŠQ>cr H§$Q>|Q²>g _| E{S>qQ>J hoVw h_| {ZåZ
have to check the box 'Allow editing directly in nmW Ûmam 'AcmC E{S>qQ>J S>m`aoŠQ>cr BZ goëg' ~m°Šg
cells' at the following path:
MoH$ H$aZm hmoJm:

Office button → 'Excel Options' → ‘Advanced' → 'Allow editing directly in cells'