"GeN'' YZjh T U YNL

GeN YZjh U YNL R YY

file UYh. CR X V FileL[ \eL. AY EYeLTyP
RLYL[ T N Ye L[
LyP T NYe L[,
LyP T N[ RLYL[ PL
X WL G|e L[ zf\.
CR U YNV TP-1 LQX.
R Ms-excel G\ TVW fe NR EP
U UP izV Ye qy W
R. AR File G\ TVW fe
NR TP-1 RY T\ U TVL[e LQX.
(new): CR G\ U YNV] RL J GeN File-V \ AR
X RLYL[ EYefe L[ ERf\.CY UY RR|
TRh TXL, ctrl G\ TyP] N G\ TyP] JW SW
A] iP V GeN TX \eL z. V GeN file B] TX LyPjLP
izV, ARY NLP izV Ye qy BL Ceh. AR SUeh YzV
RLYL[ P N L[X.
open: CR UY fe NR AR X HL]Y EYeLTyP File J\
\ A E[ RLY[e L| TX YXL[o NVX. ARY open
G\ U TVW fe NRP

My documents
CR TP LP LyP W R. CRh AR G]Y\ SU
file my document G\ CPX, AX desktop G\ CPX Ceh.
ERWQUL CR my document G\ TVW fe NR AR gZ, TX File
L TVL R. AY HRY J] R G|e L[X.
AR File-V fe NR EP]zVL, AR File \eL Ty| A] RLYL
W LQT|. CR] GRLo NV Y|U\ ctrl G\TyP], o
G\ TyP] N A] AR File \eLT|.
h[ (close): CR close G\ TVW fe NR S \ YX N
LzR PT|. ARY S RT YX N
L| CR File ETVL zeh Yf\ GT ARUh.
N (save): Yeqy J\ \ AR TX RU] YXL[o NR \h,
AR TWUL T N Ye L[ YzV L AYpV. AR
SW CR save G\ TyP] fe NR T Yeqy ATzV
S TV ATzV TYf|.

save As : C J efVU] NYVh. H] N], pX NUVjL S

YX N L| Ceh YeqyP Y\ TV T NV
Yzeh. AR SW CR UY ETVf YY TVL T
N L[ C ERf\.
save As web page: pX NUVjL, S EYefV GeN File
L[ CQVR[ TeLjL[ TX T N L[ Yzeh. AR NUVjL
CR YN] ETVfeLX. CR TVW fe NR gLP TP-2
R.
CR \ X TX Yeqy|L APjfV J Ye e AX RVL J
Yeqy G C YLL J \VL T N L[X.
save work space :CR \ X, HL]Y TP 2- E[ T, B] file
name G\ CP SUeh YzV J TVW L|eLX. A TX save As
type G\ CP work space G CeL Y|. ARY CR X S
EYefV Yee J E[ RLYL[ Uy| J R File -BL T N Y
e L[X. CYV]R RR|e LP \h G\ TyP]
fe NR TU]. AR File name G\ CP E[ TV TYf|.
wep page preview :CQVR[ TeLUL T NR RLYL APjfV YeqyP, A
GY T NVTy|[ GTR preview G\ \ Te
L[X.
page set up : CR U YN X S J Yeqyz E[ RLYL[, J
TT TeL A[eh APeh Ty|, AR TeL A[L[ AUe
L[ C ERf\. H]\, pX NUV YeqyP y G|eL
Yzeh. AR NUVjL C T A[L[ AUe L[ YzV
sX HT| GT hPReL.
print Area : A|RRL YY R, CR print Area G\ UYh. CR] fe
N T CW| YLV] YNL R.J Set print Area G
U\ clear print Area G LQT|. CR Set print Area G\ U X
S y NV YzV file-V \T|R, clear print Area G\ TVW
TVT|, \T|V print Area -Y A P C ERf\.
y ( print ): CR U TV X RR|R File-V P X y
G|e L[ C ERf\. NRWQUL print G\ TVW fe
NRP, hyP file- E[ RLYL Peh ATT|f\. CR
YXV heh Y NV ctrl U p G\ CW| TyPL[ N
AR Y|. AT, LyP WX S ETVfe
Lzeh file-B] EP] Peh ATT|.
sent To : C J VNU] ETVL \VL LRT|f\. H]\,
S J Yeqy File-V CPSy X UXL A T CR
UX TVT|RX. CR] fe NR CW| TVL R. J mail

Receipient G U\ mail Receipient (asattachment)G AZeLT|

f\. ARY S \eh GeN X EYefV YeqyP, pX AYXL
Uy| YXLeLL AT Yzeh. AR NUVjL CR GeN File-B]
attachment G\ \, ARY S NRWQUL A UP
CQ Aproperties : CR YL U YN X TX RU] TL[ N
Ye L[ zf\. CR X T\T| LyP WV TP-3
LQX. properties G\ TVW fe NR EP CR TPR W
LQX.R Y General G\ U TVW fe NR, GR CP CR
LyP E[. BTWyzj pP LyP GT YTyP
T\ pX AzTP RLYL[e Ly|.
CWPYRL Y summary GT VPV LyP GR LTVo
NRY. CR UX[ V T\ RLYL[e L|eh. A|RRL Y
statistics GT CR G.G.B GT YTyP GT
U\jL NV TyP T\ AzTP RLYL[ Ly|.
A|RRL Y contents GT Yee X fPeh Yeqy|L[
TV RLYL[e Ly|. sheet1. sheet2, sheet 3, G\ YeqyL[
TV RLYL[e Lzeh.
A| Y custom G\ UY]. CR GeN TV TY RLYL[ h
Ye L[ ERf\. U RLYL GR Yz E[. text AX
Numbers T\ \ E[R GTR A L[ ERf\.
1 e1, 2 e2: CR AR G] Y\1 1 GT RXY Yeqy e1
G, CWPY Yeqy e2 G AZeLT|f\. AR] heh
R C EYeLTyP GT hP ReL.
exit: C J Yeqy EYef TXYXL[o NR \h AR] zeh L|
YW ERf\. CR] fe NR, GeN X File EYefV YX |
Ty| Y YWX.
GeN YZjh `Gzy' U YNL
TT|f\.
GeN YZjh `Gzy' U YNL
GeN GT J E]RU] UT GTR
LPR pX YWjL[L TzRR YR J zeh
YT. H]\, CR X
RLYL[ EYehY, AY\ TX YLL TVT|
Y efV LWQjL[h. CRLL YZjLT|
U YNL R UR file U GTRh.
AR X S T YN] T LPR YW

A LP. AR] RP, CR YW CWPYRL Y edit

U GTR] T A L[X.
edit U YNL
CR edit U GTR X RLYL[ TX YLL q N L
YNL[ Te LQX. edit U YNL[ TP-1 LQX.
R Y U U edit G\ TVW fe NR EP fPeh U
YN]R TP-1 Lf\. CYV]U GeN X
RLYL[ NL N pX Jjh T|R NTRU] YXL[o
NT R CYL TVT|f\].
undotyping : CR R YL undo YNV] L GR] J\h. H]\,
NL pX RLYL[, ARY YRL[V AX GL[V P
N LT, pX RY\] YXL[ N |Y E|. AR
NUVjL RY\] YX NRRh E[ RLYL[ T\ CR undo G\
TyP] fe NR, RT LPpVL NR YX U\ TZV
RLYL[V | T\ z. CR YXV heh Y NV Y|U]
`Ctrl' U `z' G\ CW| TyPL[ gTz N AR Y|.
repeat fillup AX redo : CRh RV \eh G U\V] Bh.
H]\, RLYL[ NL P NR \h, RY G] ] undo G\
TyP] fe N A |Y. B] EUXV, A RY\] RLYL
AX, U\L NV] RLYL[h. AR NUV CR redo G\ TyP] A]
AT] NV] RLYL[ | Te L[X. CR] heh YX
NV Y|U] `ctrl' U `y' G\ CW| TyPL[ gTz N
AR Y|.
cut,copy,paste : CR U, GR J UT[ ETVfeh T,
S LyPV TVT|ReizV U TVL[h. ARY cut G\ TVW
fe NR, J N E[ RLYX G| Y CP T NV RV T|
f\ G ARUh. H]\ J UT cut NR EP, A|RRL
LyPV Y J N T NV Y|. ARh paste G TV
E[ TyP] fe NV Y|. pX NUVjL cut NYRh TXL copy G\
TVW fe NR, J N E[ UT Y J Nh L N
RUL RR| paste G\ TyP] fe N U\ Nh
Ae L[X. CR YXL[ heh Y N L[X.
ERWQUL
cut G\ YX]o NYRh `ctrl' U `X' G\ TyP] Ae
L[ Y|. AR TX COPY NYRh `ctrl' U `c' G\ CW|
TyPL[ Ae L[ Y|. AR TX RR|RY\ Y J
N Ty|e L[`ctrl' U `v'G\ TyPL[ AR Y|.

fill A|RRL Y YNV], Yeqy ETVL TVT| efVU]

J\h. H] fill G\ TVW fe NR, down, Right, up U Left
G\ Sh U TVL R. CY down GT J N E[ RLY
gZ E[ U\ NL L NYRh , RLY Ceh N g E[ NX
`Select`N, down G\ UY fe NR, UX E[ RLY A]
g\ E[ NLeh L NVT|. AR TX, J RLY Ceh
N YX\ E[ NX Select N Right G\ TyP] fe NR,
AR RLYL YX \ NL L NVT|. AR TX up G\ TyP]
ETVf U\ NL, Left G\ TyP] TVT| CP\ Copy N
L[ z.
CR YXL[ iP heh Y N L[ z. ARY ` Ctrl' U
`D'G\ CW| TyPL[ N A] g\ NL, `Ctrl' U
`R'G\ TyPL[ N A] YX \ NL RLYL[ SWzVL
L N L[ z.
Clear: CR YL U YN X NL E[ RLYL[ AeL C ERf\.
CR ClearG\ TVW fe NR All. Fotmat, Contents U
Comments T\ TX RU] ETVLjL[ LQX. CY All G\
TVW fe NR, A] NL E[ RLYL[ AeL z. AR
TX Contents G\ TyP] fe NR J N HL]Y T
NVTyzeh RLYL[ AeL[TVT|. AR TX Comments
G\ TyP] fe NR, J N E[ RLYLeh [eL L|eh YL T
NVTyzeh Comment-L[ AeL[ ERf\.
Delete: CR TyP X J N E[ RLYL[ AeL z. AX TX
NL E[ RLYL[ U X RR|e L[ Y|. AR
DeleteG\ TyP] fe NR, RR|R NL E[ A] UL
A |.
Delete Sheet: CR YL U TV X J Yeqyz E[ A]
NL Ceh RLYL[ AeL C ERf\. NRWQUL Jee
RVeh T JeqyL Ceh. AYL Sheet 1, Sheet 2, U
Sheet 3 G Ceh. ERWQUL, Sheet 1 E[ RLYL[ AeL CR Lete
Sheet G\ TyP] ETVL T|R Y|.
Move or Copy Sheet: pX NUVjL Yeqyz RLYL[ EYeh
YX D|Ty|e Lzeh T, hyP N AX NL
E[ A] RLYL[ U\ Nh AX Ye qyzh L
NV Yzeh. AR SWjL CR] TVT|RX. CY MoveGT
KP C U\ CPh UYRh, Copy GT KP
C Y J CPh RLY L[ L NRYh TVT|.

Find and Replace: GeN YZjh U\ J ARU] YNR CR Find

and Replace GTRh. CY CR Find GT J Yeqyz
E[ RLYL SUeh YzV J YR AX RLY E[R G] LPV,
AR] Y J YR AX RLY L| Ue L[ CR YN
TVT|f\. ERWQUL, Find G\ YRV fe NRP g LP TP2 V LQX.
UX E[ U E[Tz, Find G\ U E[ Find What G\ CP S
L|zeL YzV YRV P N L[ Y|. AR RLY JY
YNVLeiP RPX. AR YR J \eh U E[R GTR LPV
Find Next G\ TyP] fe NV Y|. CY AR `Sonia' G\ YR,
J Yeqyz GR] CPjL E[ GTR LPR EP Cloes G\ TyP]
fe NR, YRV R| Y[ RT|.
AR `Sonia' G\ CP Y J YRV TP Y| U\ Replce G\ TyP] fe NV Y| AT Replace With G\ CP
SUeh YzV V TVW AX RLYX P N Ue
L[ Y|.
CR Replace U GY YX Nf\ GTR AV gZ E[ TP-3V
LQX. CR Edit G\ U Replace G\ TVW fe NR Y U
R gZ LyP Ty|[.
CR U E[ TX Find What G\ CP `Sonia' G P
NR, J Yeqyz GR] CP CR TV Yf\ GT he
L[T|. Replace With G\ CP RiniG\ TVW P NR
`Sonia' GTRh TXL Rini G\ TV U\ f\ GT
ARUh. CT, CR Sonia G\ TVW JW CP RiniG U\
] Replace G\ TyP] fe NV Y|. J Y[ Sonia G\ TV
GjLX Yf\R AjLX U\ ],replace All G\ TyP] fe
NV Y|. CY J YRV RzeL| z AR] SUeh RYT|
Y T Ue L[X.
CR Find UY TYRh heh Y ETVfeL YzV \V], Ctrl
G\ TyP] G\ TyP] N AR YzVRh. CT
Find U Y TR AR \]e LV[X. AR TX Re-place
UY heh Y TYRh Ctrl U G\ CW| TyPL[ J\L
A], AR U SWzVL Y |.
Go to: C U Edit LPp U LPp ETVLUh. CR X J
Ye qyz U\ Ye qyzL, AX GeN File - C
Y| File-eh NYRh, AX GeN TX TYTy G]T|File - E[
Slide-Leh pX RLYL[ L NYRh CR UY TVT|RX. CR]

heh Y NV `Cti'U `G' G\ CW| TyPL[ N AR

Y|.
GeN YZjh `' U YNL
GeN YZjh `' U YNL
G.G.B UT J\] GeN T A E[ p\L h LPR
pX YWjL[L T Yf\.
GeN UT AYXL TTYLeh L AVYpVU]Rh. CR
YW GeN UT E[ `' (View) U TV [eLjL[ LQX.
`' U TVT|L
R GeN Ueh N\ \h \YRL Y U TV R `'
(View) GTRh. CR] fe N T fPeh RLYL G] GTR
TP 1 LQX.
SU (Normal):
CR UY fe N T fPeh UY R TP-1 Ly|f\.
AR fPeh R ETVL R CR SU (Normal) G TV
LP YNVh.
CRh AR G]Y\ GeN WV LyP S ETVfeh T
TX YNLP g \, U \ TX TVLP izV UeL, pV TPjL
R. AY pX hyP YNL GeN Ye qy RVeh T
LyPV TVT|R Yz Ceh.
BLV CR (Normal) G\ TyP] fe N T AzTP YNL RW
U\ UeL U\ Th. AX h\Y] U YNL W Ceh
T CR (Normal) G\ TVW fe NR AzTP U YNL A]
W R.
Page break Preview:
C J VNU] ETVLUL LRT|f\. H]\ Yeqy
RVeh T ARPV RLYL TX TeLjL APeLe izV A[h TVRL
Ceh. AR NUVjL S y G|eL V\ AR RLYL JY TeL
NV] \ JjhT|R TPU Ceh.
AR NUVjL CR Page break Preview G\ TyP] fe N y G|eh
T JY TeL GR] YLP izV RLYL[ T N YeL
Y| GTR] AUe L[ z.

C efVU] cV G]Y\ CR] N T LyPP LyPV

P CQeL TyzeL Y|.
Tool bars: J GeN Yeqy RVeh T CR Tool bars G\ U
X TXRU] ETVLjL R YNL[ EYef L[X.
R YY Standard G\ TV LP U Yh. CR AzTP
RYV] Yeqy RVeLT| UeL[ R]LY W R\o
N NVTyP YZjhf\.
ARLL S NV YzV Standard G\ TVW U X fe
NR AR CP \ J ze (\/) h| R. CR T Standard
G\ U ETVL E[ GTRh.
A|RRL YY Formatting GTRh. CR TVT| Yeqy RVeh
T AL A[ TVT|f\. ERWQUL GeN WX CWPY
YNX GeL PX R G|eh U GeL A[Y
R G|eL TVT| U Bold BL GeL[ Ue L U
Italics G\ P GeL[ AUe L YN AzeL|
(Underline) YN T\YL[ CR Formatting G\ U YZjh. U
RLYL[ CP \, YX \ AX S| ThX JjhT| qW] \
AUe L YNL[ CR Formatting U R YZjhf\.
U Chart G\ U X TXRU] AyPYQL[ EYeh TPjLP izV
pV U YZjLT|f\. AR X RLYL[ VNU] \ AyPYQL
AUe L[ z. AR TX Clip board G\ TVW fe NR J
GeN Yeqyz E[ RLYL[ TXRU] Ye qy|Leh L NV
TVT|f\. CR] GV \ NV Clip board G\ U TPjLP YZjLT|
\.
A|RRL Control tool box G]T| U X rY Tpe X RVeLT|
TXRU] TyPL[ EYeh U W R. AR W R
U GX RU] TyPL YZjLT|. U X fe N Yeqyz
GR CP Y|U] AUe L[X. AR TX Drawing G\
U X HL]Y Y| X A LP TX GeN W Az
Draw G\ U R. CR X Yeqyz GXRU] AyPY]L
Ty|e LY, AX L|L Ty|e LY T\ A]
YXL[ N L[X. CY\ GRL N Ty| Drawing
G\ TVW fe N T Draw G\ U gZ R.
A|RRL Y External data GTR X J pV U TPP R.
AR X GeN Ye qyzh Y File- C AX Y CP
C RLYL[ G|e L[X. AR TX A| Y Forms G\ U
YN X cY Tpe G]T| U T[ EYeLT|. Forms L[

RVe L[X. CR Forms L[ RVeL U TPP W

YZjLT|. AR X TXRU] YNLP izV Forms L[ GeN Yeqyz
AUe L[X.
A|RRL YY Picture G]T| UYh. CR] fe N T
Picture G\ TVP izV pV U W R. CR X Clipart
T\ TPjL E[ Folder C TPjL[ G| SUeh RYV] CP
TPjL[ Ty|e L[X. U A|RRL Y Pilot table G\ TVW
fe NR VNU] AyPY] L[, VNU] YW TPjL[
(Chart) EYeh \L[ Step 1, Step 2U Step 3, G] TPjLP izV GV
\] YZjhf\.
CY AyPY] EYeh RjL, YW TPjL[ EYeh \L RYL
L|eLTy|[R, RL GeN Le LTYL GRL CY\
EYef L[X.
A|RRL YY Reviewing G\ UYh. CR X HL]Y GeN
Yeqyz P Neh LeL[ (Comments) Ue L[Y,
AX U\e L[Y, Ae L[Y C ERf\. AR TX
A| YY Visual basic G]T| UYh. CR] fe NR Visual
basic G\ TV pV UYe LQX. CR] TV T| cY Tpe
X NVT| Form EYehR U AY LyW
TyPL[ EYehR T\ A] YXL[ NV zf\. CR
p\TNN G]Y\ cY Tpe R]LY GeN EP CQeLTy|
[R, RL C D|T|TYL GY CWP CQT G hZT
RYX.
A|RRL YY Web G]T| UYh. CR X CQV R[ EYeh
YXLP RPPV UeL[ WX AUe L[X.
ERWQUL Web G\ TVW fe NR WX, GeN UY|
\Y YN, TX TVLP izV UeL[ LQX. CR] TX CQV
R[jLP Ye qyP CQe LY, AX
CQVR[ TeLjL[ EYeh T GeN YeqyP AR Ty|e LY
T\ TX YXL[o NVX. ARh A| YYR Word art
GTRh. CR X TXRU] YR L PL[ EYe feL[X.
LPpVL Y Tool bars EPV U YNR Customize G AZeLT|
f\. CR efV SeL U]. GeN WX UeL[ GY AU
e LY, TPjL TVRL YW Y|U AX pVRL YW Y|U
T\ Y\ N L[X.
Formula bar U Status bar: CR U YZjh A|R CW| YNL
R Formula bar U Status bar: GTRh. CR Formula bar G\
TVW fe NR WX TX ETVfeh T J\ AUeL
z. ARTX CT GR Ye qyz Cef\. G] YX N

 Lzef\ T\ TVT|L[ AV W AzTh Status bar

J\ AUe L[ C ERf\.
Header and footer: CR Header and footer: G\ YNL[ T
HL]Y Y| T TzRT R LP. CR efV TVT|
L[] Ye qyz RXL[, pX hL[ AUe
L[ ERf\.
Comments CR UY] GR N Ceh RLYXT pV
hL AUeL[ Y|U, AjL P N L[X. CR]
fe NT Y pV Tyz hL[ P N L[X.
Customs views: GeN Ye qyz RLYL[ EYef, SUeh YzV
R RLYL[ TeL CR Customs views G\ U ERf\. CR] fe
Nf\T, Y U X CR] N L[X.
Full screen CR YN X, WX U Th, g Th E[ U
TL[ U\ y| Yeqy TV A[ CehU AUe L[ zf\

Ye qyz EYeLTyP RLYL[ TV A[ TeL Y|U AX

pV A[ TeL Y|U GTR UeL NRRP izV UL
E[. ERWQUL 200% GTR] fe NR Ye qyP] CW|
UPjh TVRL R. CY HRY J\ RR| OK G fe
N L[X.
GeN YZjh `TUy' U YNL

GeN YZjh `TUy' U YNL

hTL U YNL[ T

R L| Yf\.
CR UeL[ T S\L R LP GeN ETVfT L
rXTUf |.
C S LQ Ceh UY] `TUy (f) GTRh. C J
TV A[h efVU]RL LRTPX G\ CR ETVLjL pX
NUVjL TVT|R YzV AYpV HT|f\.
Formet U YNL
GeN fe NVTyPP YWeizV U R CR TUy AU[.
CR TUy G\ U TVW fe NR Y YNL[R TP-1
Ly|f\. hTL CR TUy UY] GeN Yeqyz
E[ NL[ TT|RT|YRh AX pT|YRh, AX
JeqyP U\ YT T\ YXL[o NYRhR TVT|f\.
RXYRL Y U YNR cells G AZeLT|\. CR] T\ heh
Y , ctl U L G\ CW| TyPL[ A] U J pV U
WV LQX.

CR TUy cells G\ YN X Y U Number, Alignment, Font,

Borter, pattern U protection T\ YNL[e LQX. C Number GT
GeN NL GL[ GRR RjL P N LY, ARLL
NL[ GY YzYUe LY G\ YN] YZjhf\. AR TX
NLeh E[ RLYL[ GY CP \X, YX \X AX
S|X GY AUe LY GTR Alignment XUL N
L[X. A|RRL GeN NL P N GeL[ RRU]
Font L AUe LYR CR X N L[X. A| Y
Borter G\ YN X GeN YZjh Yeqyz Sh \ Y
GXeL|L[ GR R AUe L[ Y| GTR] C YZjhf\
.
U pattern G\ YN X NL E[ RLYL[ TX YQjL AUe
L Ty| LXL[ R G|e L YN] Te
L[X. AR TX protection G\ YN X J YeqyP U\
YeL (hidden) AX yz YeL (locking) CR] TVT|RX. H]\
U\YLP C NL E[ RLYL[ TLeL CR] TVT|RX.
A|RRL Y UY R Row G AZef \. CR Row G\
TVWe fe NR UYe LQX.
CR Row U R YY height G\ YNVh. CR efV SeLU]
GeN qyz E[ N EVWR ALUL AX h\YLY Ue
L[ C ERf\.
CR LyP A|RRL YY autofit GTRh. CR efV SeL.
TReLTyP NL[ | NRWQ A[h Ue L[ CR auto
fit G\ TV ERf\. C T\ YXL[ NY L. rXT.
H]\ GR cell V U\ Y|U AR N U X NXey N
L[ Y|. CRU TVL[ fe NR TU].
A|RRL YY hide GTRh. CR efV SeL, J YN E[ A]
NL[ U\e L[ C ERf\. ERWQUL CWPY
YN R N U TPW Y y| hide G\ UY fe
NR CWPY YN E[ NL U\ |. ARY R YNeh
\h \Y YN R W R.
AR T U\eL TyP AR CWPY YN E[ cell L[ |
W L| YW ], U TP X \Y YNV RS
G|R ] Unhide G\ TVW fe NR U\eLTyP AR CWPY
YNV] | WXV R. CY\L NL[ U\
AR] U TX YXL[o N L[X.
CR Formet U A| YY column G\ YNVh. CR X GeN
Yeqyz E[ cell EPV ALXR ALT|RY AX h\eLY z.

column G\ YRV fe NR EP Y U width Autofift selection,

hide, UnhideU standard widthT\ TVL[e LQX.
CY R Y width G\ TVW fe NR TP-2 R.
CRTP E[ TX column widthG\ TV Af E[ LyP U
8.43 G E[. CR] ALT|], N EPV ALUL CTRh
AR] h\R N EPV ALX h\YL CTRh YXL[o N
L[X. AR TX Autofift selection G\ UTVW fe NR
N EPV A[] S P N RLYeh RhRTX R]LY
TVRLY AX pVRLY UVUe L[X.
HL]Y TRT, CR Y U\ YNR hide GTRh. CR
X GeN qyz UX E[ A,B,C G\ YNL HR J\ U\e
L[ C ERf\. ERWQUL `A' G\ YNeh gZ U X cell V
NXey N L| hide G\ TVW fe NR `A' G\ YN U\
|.AR TX `B' G\ YN E[ N U TPW Y J NX
NXey NR \h hide G\ TVW fe NR `A' eh \h `C' G\
YNR Y `B' G\ YN U\| AX U\R \h | `A'eh \h
`B' G\ YNV WX L| YW ] EP] Unhide G\ TVW
fe NR TU]. EP] U\ YeLTyP N WX Y
|.
ART column U LPpVL YY standard width GTRh.
CRPV ETVL G]Y\, width G\ U YN X column EPV
ALXR ALULY AX h\R YR AR] | TZV
NRWQ A[h L| YW standard width G\ TVW fe NV Y|.
A|RRL YY Formet YZjh sheet G\ U YNVh. CR] fe
NT Rename,hide, UnhideU Background G\
TVL[ LQX. NRWQUL GeN ETVfeh T WX JW
SW sheet -L[ LQX. AYL sheet 1, sheet 2, sheet 3 G]
AZeLT|. CY TVW SUeh RYT|YTX Ue
L[R CR Rename G\ U ERf\. ERWQUL sheet 1 YX
N LzehT, Rename G\ TVW fe NR V
TVW Lyh. CT P NVT| V TVR sheet 1eh
LyPT| ARTX sheet L[ ETVfehT HRY J sheet
-V U\ YeL ] hide G\ TVW fe NRT
ERWQUL sheet 1 YX NYRL YeL Y. AR NUV
U\ sheet 2, U sheet 3 Uy| WX R.
CY WX U\ YeLTyP sheet 1 | RYT| NUV
Unhide G\ TVW fe NR, U\ YeLTyP sheet | WX
R. ARTX sheet U YZjh LPp YNR Background
GTRh. CR efV SeLU] GeN Yeqyz E[ A] \
YNL[ SUeh RYT|Y TX AUeL[ ERf\.

ERWQUL LXL[ UeL[, GeL A[L[ Ue

L[ ERf\.
A|RRL Y U YNR Auto Formet G AZeLT|f\. CR]
Formet U LQX. CR efV SeLU]. GeN Yeqyz
NL A[L[, U\ AUL[ GeN YZjh CVLV] Formet
YNLeh AUe LYRh. CR] NXey NYR U\ U\jL
GX | R CR Xeh U|. A|RRL conditional
FormatingGT Yeqyz RUeLT A[L[ AUL[
U VUeL[ C ER f\. TXRU] Yeqy EYeh \L
E[R AYL\TX, Yeqy AUL U| LPpVL
Y Formet YZjh YN R style G AZeLT|f \. CR] fe NR
UR YWjL[ W LQX.
CRTP LT TX J Yeqy EPV UR Background
RLYL[ AUe L[ zf\. C J Normal Yeqy AU
\L Bh.
GeN YZjh `P' U `a' U YNL
eN YZjh
`P' U `a' U YNL
GeN YZjh A] YNL[ TzR \h C TXeh, CR] ETVfeL
Y| G] BY YT EU.
CR GeN YZjh A] U ETVLjL[ T Sh A
LPX A[ S Tp T\RL EQW z. CR efVU] TX
U YNL[ T S HL]Y AR,
CR YW GeN U Y LPp CW| YNL[] `P` Windwo
U Help BfVY\ C LQX.
GeN YZjh U YN

GeN X Y U U
E[ YNL[ TP-1 E[Tz LQX.
AY `P` G\

TVW `a` G\
TVW fe N T Y YNL[ TP-1 (A,B) Ly|f\.
CR TP 1 (A) - LT TX Window G\ TVW fe NR EP Y
U ETVLjL[ T CT RYL LQX. R YY New
Window G NXe izV VR Ye qy EYeh Y\Vh.
CR New Window G\ TVW fe NR, Book 1.1, Book 1.2, Book1.3
G] YNVL VRL TX GeN Jeqy|L[ EYefe LP NXX
ARY Ye e 1 G] EYefV AR TX RU] Ye qy|
L[ EYefe L[ C ERf\. AR TX, A|RRL YY Ar-range
GTRh. CR] fe N T Arrange Window G\ UY W
LQX. CR X W E[ YeqyP TeL YU AUe
L[X. CR Titled, Harizontal, vertical U CasCade T\
YNL E[. AR J\ fe N OK G A], LyP W
Ye qyP A[ AUe L[ z.
A|RRL YY Hide G\ UYh. CR X Sheet1 G\ YeqyP
W YWR YQ U\e L[X. W E[Sheet 1 X New
Window G\ UY ETVf EYefV Book 1.1 , AX Book1.2, G]
GR Y|U] U\ L[X.
CY U\ YR YeqyP | W L| YW ]

CY U\ YR YeqyP | W L| YW ]
UnHeid G\ UY fe NR T. AR] fe NR Y UY
TP-2 LQX.
UX E[ TP E[ TX, GRR YeqyP Hide U X U\
YRU, AYV] WX R. AY HR J\ fe N
WX | R\o NVX.
J Y[ JW J YeqyP U U\ YR, AR J Yeqy
Uy| Book 1 G] R, CT Hide Window G\ UY fe N
AR X Y Book 1 G\ TVW fe NR | Book 1 W
R.
A|RRL Y U YN Split GTRh. CR] TT S ETVfT
CX G\. G]Y R L[X. CRSplit G\ TVW fe
NR EP Yeqy WV] Sh TLjL[L eLTy| WX
R. CT S RYeLT Sh TLjL[L ETVfe
L[X.
J Y[ Split T ETVfR YeqyP Split CXU ETVfeL
] | U E[ Remove split G\ TVW fe NV Y|.
CT Yeqy WV SLL CR U JW Ye
qyPL U |.
A|RRL YY Freeze panes GTRh. CR U YN S
HL]YTRSplit G\ YN] T\ R CR Yeqy WV
SLL |. A RYXV\ Un Freeze panes G\
TVW fe N L[X. ARh A|RRL Book 1 G\ RXTe
LQX. CR TV G]Y\ S GR Ye qy ETVfef\
GTR A L[ TVT| U YNVh.
CR GeN YZjh LPp U YN
help GTRh. CR help G\
TVW fe NR fPeh
U TVL[ TP-1 (B)
LQX. CR U E[
Microsoft Excel help U f 1 G\
YNVh. CR] fe NR type
your overies here, and then click
search G\ Y] W LQX.
CR X SUeh RYV]
ERL[ AX Excel GY TVT|
Y T\ LLeh TX Te L[X. AR TX A|
YY show the office assistant G\ UYh. CR] fe N T
pV TU T\ TP W R. ARP pX YLP izV
LV W LQX. pX NUVjL, CR TU W R

SUeh pX RRWL[e L|eh. AR NUV hide G NXeizV

TyP] fe NR TU U\ |.
A|RRL Y U YN what is Whis?G\ YNVh. CR] SWzVL T\
Shift G\ TyP] F1 G\ TyP] N A] TU]. CR
what is Whis? G\ TVW fe NR W (?) LehP izV h|
W R. CR Le hV GR TP U AX TV U
SL Yef\U, AR TP AX TV ETVLjL[ TV
YWjL[ A L[X. ERWQUL Ye qyz E[ N U CR
Le h hyP YR, EP]zVL N GT Work Area G\ TV
[eLjL L|eLT|. AR TX W E[ File G\ TV U CRe
LehyP YRFile U TV [eLjL[ R L[X.
AR TX Ye qyz UX E[ TX T CP CR Le h
TPR YR TX T GY ETVfT, AR
GY TXY P NY T\ [eLjL[e L|eh. CR] GRL
ETVf W E[ A] YNL[ T A L[X.
A|RRL YY office on the webG\ U YNVh. CR] fe N
T, EP]zVL SU LyP CPSy CQ X G.G.B
UTeh EV CQV R[h CQeLTy|, S] TX ETVLjL[ SUeh
L|eh. C J AUV] YNVh. CRh efVU] RYV], SU
LyP CPSy YN CeL Y|.

A|RRL Lotus 123 Help GTRh. CR] T pXeh ReL

YX. ARY CR Lotus 123 GT G.G.GeN T, CRh
ETVL C YR J NyYWh. LyP ETVf
YR TX CR] ShAYL. ATzTyPYL GeN ETVfeL T|
T GeN X pX lotus LyP[L[ GY ETVfT GTz
GTR AV CR] ETVfeLX.
CR TP E[ TX lotus 123 U YNL pX W L|eLTy|
[. CT Range > G\ TVW fe NR, GeN X Range>
G\ UY GY ETVfeLX TRL] [eLjL[ LQX.
AR TX Graph >G\ UY fe NR Lotus 123 X YWTPjL
YWRR TX GeN X GY YWTPjL YWVX GTRL]