Page 131 - FUNDAMENTALS OF COMPUTER

NPP

NPP MS-Word & Excel 131

2. We can put the Print preview icon in Quick 2. h_ {ŠdH$ EŠgog Qy>c~ma _| qàQ> [àì`y AmBH$m°Z aI
Access Toolbar and select quickly select gH$Vo h¢, VWm Vwa§V Ohm± ^r Amdí`H$ hmo, AmBH$m°Z
that icon whenever needed. A preview
window appears as in fig-2.60. {gcoŠQ> H$a gH$Vo h¢& {MÌ-2.60 AZwgma àX{e©V
[àì`y qdS>mo

Fig. 2.60: Print Preview
Printing the Title Rows Q>mBQ>c n§p³V¶m| H$mo qàqQ>J H$aZm

If we want to repeat certain row of a table `{X h_| àË`oH$ noO na erQ> _| Q>o~c H$s Hw$N> n§p³V¶m|
in the sheet on each page, we can use this feature H$mo [anrQ> H$aZm Mmh| EŠgoc Ho$ Bg \$sMa H$m h_ Cn`moJ
of excel. For example, when we create time H$a gH$Vo h¢& CXmhaU Ho$ {cE, H$m°coO H$s H$B© H$jmAm| Ho$
table of many classes in the college and want Q>mB_-Q>o~c h_| ~ZmZm hmo VWm AmJm_r g^r n¥îR>m| na àW_
to repeat the lecture timing row of the first noO Ho$ coŠMa g_` H$s cmBZ H$mo [anrQ> H$aZm MmhVo h¢,
page at all subsequent pages. Following steps {ZåZ ñQ>oßg CR>mZm Amdí`H$ hmoJm:
are needed for repeating rows in each page:
1. Select the Page Setup group in Layout 1. coAmCQ> Q>¡~ _| noO goQ>An J«wn {gcoŠQ> H$a|
tab and click on the 'Print Titles' VWm qàQ> Q>mBQ>ëg ~Q>Z na {ŠcH$ H$a|& {MÌ-
button. A Page Setup box with its
Sheet tab open will be visible as in 2.61 _| Xem©E AZwgma EH$ noO goQAn ~m°Šg
fig-2.61. CgH$s erQ> Q>¡~ g{hV {XIoJm&
2. Go to 'Rows to repeat at the top' field 2. "amoO Qw> [anrQ> EQ> {X Q>m°n' {\$ëS> na OmE VWm
and click on the spreadsheet icon. ñàoS>erQ> AmBH$m°Z na pŠcH$ H$a|&
3. Now, select the rows to be repeated 3. A~ àË`oH$ na [anrQ> H$s OmZo dmcr n§p³V H$mo
on every page and press OK. Rows'
reference will be automatically {gcoŠQ> H$a| VWm AmoHo$ àog H$a|& gob [a’$a|g
inserted in the field. ñdV… Am OmEJm&