Page 122 - FUNDAMENTALS OF COMPUTER

NPP

122 Fundamentals of Computers NPP

Inserting Rows n§p³V B§gQ>© H$aZm
To insert a single row just select one cell of EH$ qgJc n§p³V B§gQ>© H$aZo Ho$ {cE n§p³V Ho$ EH$ goc
that row or entire row and right-click, and `m g§nyU© n§p³V H$mo {gcoŠQ> H$a Am°ßeZ B§gQ>© na pŠcH$
click on the option Insert. A dialog box will H$a|& {MÌ-2.46 _| Xem©E AZwgma EH$ AZwgma S>m`cm°J
appear as in fig-2.46. Select 'Entire Row' and
click OK. The row will be inserted above the ~m°Šg {XIoJm& 'E§Q>m`a amo' {gcoŠQ> H$a AmoHo$ pŠcH$ H$ao&
selected row. {gcoŠQ>oS> n§p³V Ho$ D$na n§p³V B§gQ>© hmo OmEJr&

Fig. 2.46: Insert Dialog Box
When we want to insert multiple rows, O~ h_| _pëQ>nc amoO H$mo B§gQ>© H$aZm hmo, amo {gcoŠQ>
select the row and go to Cells group in Home H$a {MÌ-2.47 _| Xem©E AZwgma hmo_ Q>¡~ _| goëg J«wn na
tab as in fig-2.47. Now, choose Insert button OmE§& A~ amo B§gQ>© H$aZo hoVw B§gQ>© ~Q>Z Ed§ 'B§gQ>© erQ²>g
and 'Insert Sheet Rows' to insert row. Perform
these actions as many times as you wish to amo' H$m M¶Z H$a|& Bg {H«$¶m H$mo V~ VH$ O~ VH$ AmnH$mo
insert multiple rows above a selected row. {gbo³Q>oS> amo Ho$ D$na amo B§gQ>© H$aVo OmZm h¡&

Fig. 2.47: Using the Insert button of the Home tab
Inserting Columns H$m°c_ B§gQ>© H$aZm
To insert a column we have two options H$m°c_ B§gQ>© H$aZo hoVw h_mao nmg n§p³V B§gQ>© H$aZo
similar to inserting rows. First way is to select Ho$ g_mZ hr Xmo Am°ßeÝg h¢& nhcr {d{Y go goc `m \w$c
a cell or full column and right-click. Select the H$m°c_ {gcoŠQ> H$ao Ed§ amBQ> pŠcH$ H$a|& {MÌ-2.46 _|
Insert option to see a dialog box as in fig-2.46. Xem©E AZwgma S>m`cm°J ~m°Šg XoIZo hoVw B§gQ>© Am°ßeZ
Choose 'Entire Column' to insert a blank column {gcoŠQ> H$a|& {gcoŠQ>oS> H$m°c_ Ho$ coâQ> _| ãc¢H$ H$m°c_
in the left of a selected column. Another way is B§gQ>© H$aZo hoVw 'E§Q>m`a H$m°c_' H$m M`Z H$a|& AÝ` {d{Y
to go to the cells group under the Home tab and