Page 113 - FUNDAMENTALS OF COMPUTER

NPP

NPP MS-Word & Excel 113

If we uncheck the 'Allow editing directly `{X h_ 'AcmC E{S>qQ>J S>m`aoŠQ>cr BZ goëg' ~m°Šg
in cells' box, we will not be able to edit directly AZMoH$ H$aVo h¢, h_ S>m`aoŠQ>cr goëg _| E{S>Q> Zht H$a
in the cells. Only one option, remains is to edit nmE§Jo& Ho$dc EH$ Am°ßeZ \$m°_y©cm ~ma _| E{S>Q> H$aZm eof
in the formula bar.
ahoJm&
Some important points to be remembered goc _| E{S>Q> H$aVo g_` Hw$N> _hËdnyU© q~XþAm| H$m
while editing cell contents are: Ü`mZ aIZm hmoJm:
1. To start a new line within the cell press 1. goc Ho$ A§Xa ZB© cmBZ àma§^ H$aZo go nhco, Ohm§ go
ALT+ENTER where you want to begin new Amn ZB© cmBZ àma§^ H$aZm MmhVo h¢, AëQ> + B§Q>a
line.
àog H$a|&
2. By pressing ESC we can cancel the current 2. EñHo$n àog H$aHo$ Amn goc _| H$a§Q> E{S>Q²>g H$mo
edits in the cell. H¢$gc H$a gH$Vo h¢&
3. We need to adjust the cell column width 3. H§$Q>|Q²>g aIZo hoVw h_| goc H$m°c_ H$s Mm¡‹S>mB© H$mo
to keep the contents else we see #### in ES>OñQ> H$aZm hmoJm, daZm goc _| h_| #### {XIoJm&
the cell. By properly increasing the H$m°c_ H$s Mm¡‹S>mB© AnojmZwê$n ~‹T>mE§J| Vmo ghr H§$Q>|Q²>g
column width, the correct contents are
displayed. We can select the Home tab àX{e©V hmo OmE§Jo& {MÌ-2.36 _| Xem©E AZwgma {d{^ÝZ
and Cells group and click on the Format àH$ma go h_ hmo_ Q>¡~ Ed§ goëg J«wn {gcoŠQ> H$Q> VWm
option to set column width in different \$m°_}Q> Am°ßeZ na pŠcH$ H$a H$m°c_ H$s Mm¡‹S>mB© goQ>
ways as in fig-2.36. H$a gH$Vo h¢&

Fig. 2.36: Changing Cell Column Width and Row Height

We can change the width and height by n§p³V H$s hmBQ> Ed§ H$m°c_ Mm¡‹S>mB© Am°ßeZ {gcoŠQ> H$a
selecting Row Height and Column Width {dS²>W Ed§ hmBQ> _| n[adV©Z H$a gH$Vo h¢& Am°Q>mo {\$Q> Am°ßeZ Ho$
option. AutoFit option allows the size to be
automatically adjusted as per the contents. Ûmam H§$Q>|Q> AZwgma gmBO Am°Q>mo_o{Q>H$ ES>OñQ> hmo OmVr h¢&
4. Wrap text: It allows multiple lines of the 4. a¡n Q>oŠñQ>: BgHo$ _mÜ`_ go goc E[a`m _| Q>oŠñQ> H$s
text to be displayed in the cell area. For AZoH$ cmBÝg àX{e©V hmo OmVr h¡& BgHo$ {cE h_|
that we need to select the cell and go to goc H$mo {gcoŠQ> H$a hmo_ Q>¡~ Ed§ AcmBZ_oÝQ> goŠeZ
'Wrap text' option in the Home tab and
Alignment section. _| 'a¡n Q>oŠñQ>' Am°ßeZ na OmZm hmoJm&