Spelling & Grammer :- iska use Sheet me Spelling & Grammer Mistakes ko Correct karne k liye kiya jata

a jata hai.

Steps:
1. Iske liye Spelling & Grammer command me jate hai ,jisse ek Dialog Box open ho
jata hai.
2. Is Dialog Box me Wrong Spelling k liye Correct Sugestion Show hote hai.
3. Suggested option me se koi bhi ek spelling par click, karke Change par click karte
hai.
4. Writtent Text ki Wrong spelling Spelling Correct ho jati hai.
agar kisi Spelling suggestion ko ignore karna ho to Ignore Once or Ignore All par click
karte hai.

Research :- iske use se sheet par Word se related Dictonary, Encyclopedia, Translation commands ko open
kiya ja sakta hai.

Steps:
1. Sabse pahle Research par click karte hai, jisse ek window screen k Right side me ek
Research Pane open ho jata hai.
2. Yaha Search For k neeche click karke jis bhi word se related suggestion or Dictonary etc.
chahiye, wo world likhte hai, eg. Computer, Good, Boy.
3. fir side me bane Green Arrow par click ya fir ENTER ( ) press karte hai.
4. isse word se related Suggesion show ho jate hai.
5. Is Research Pane ko side se close() par click karte hai.

Therausrus :- iske use se kisi bhi word k same or similer meaning words ko show hote hai.
 Steps:
1. Sabse pahle Therausrus par click karte hai, jisse window screen k Right side me ek
Research Pane open ho jata hai.
2. Yaha Search For k neeche click karke jis bhi word similer meaning world chahiye, wo world
likhte hai, eg. Computer, Good, Boy.
3. fir side me bane Green Arrow par click ya fir ENTER ( ) press karte hai.
4. isse word se similer meaning show ho jate hai.
Is Therausrus Pane ko side se close() par click karte hai.

Translate : kisi bhi English word ka translation kisi dusri language me karne k liye Translate command ka
use kiya ata hai. eg French, Spanish etc.

Steps:
1. Sabse pahle Translate par click karte hai, jisse window screen k Right side me ek Research
Pane open ho jata hai.
2. Yaha Search For k neeche click karke jis bhi word ka translation dusri language me karna
hai, wo world likhte hai, eg. Girl, Good, Boy.
3. ab English to French or French to English or Spanish, jaise bhi Translation dena hai click
karte hai.
4. fir side me bane Green Arrow par click ya fir ENTER ( ) press karte hai.
5. isse word se Translative words show ho jate hai.
Is Pane ko side se close() par click karte hai.

New comment :- kisi bhi cell me New comment k use se naya comment likh sakte hai. jisme cell k bare me ya
selected area k bare me kuch bhi information likh sakte hai. jisse us cell par Mark lag jate hai.
shortcut (SHIFT+F2)

Delete :- selected comments kop Delete karne k liye iska use kiya jata hai.

Previous :- selected comment k peeche wale or previos comment par cursor le jata hai.

Next :- selected comment k agle or Next Comment par cursor le jata hai.

Show/Hide comment :- selected comment ko Show or Hide karne k liye iska use kiya jata hai.

Show All Comments :- sheet me lage huye sabhi comments ko ek sath Show or Hide karne k liye iska use kiya
jata hai.

Protect Sheet :- Sheet par Password lagaker Lock karne k liye Protect Sheet ka use kiya jata hai, jisse
bina Correct Password k sheet par kuch bhi editing nahi ki ja sakti.

Steps:
1. Protect Sheet par click karte jisse ek Dialog Box khul jata hai.
2. ab yaha par sheet ko protect karne k liye Password likhte hai.
 3. fir dusre Dialog Box me Password ko Re-Enter or dobara repeat kar k OK karte hai.
4. isse sheet Lock ho jati hai, or sheet par kuch bhi editing nahi ki ja sakti.
5. Sheet ko vapas normal karne k liye, Unprotect sheet par click karte hai.
6. Fir Correct Password enter karke , OK karte hai.

Protect Workbook :- iske use se File ki Workbook ko Protect kiya ja sakta hai, isse Workbook par Lock lag
jata hai, jisse new sheet ko Insert, ya existing sheet ko Delete or Rename nahi ja
sakta.

Steps:
1. Protect Workbook par click karte hai.
2. fir Protect structure and Wndows par click karte hai, jisse ek Dialog Box khul jata
hai.
3. ab yaha par Workbook ko protect karne k liye Password likhte hai.
4. fir dusre Dialog Box me Password ko Re-Enter or dobara repeat kar k OK karte hai.
5. isse Workbook Lock ho jati hai, or sheet par kuch bhi editing to ki ja sakti, but
Workbook Delete or Rename nahi kar sakte.
6. Workbook ko vapas normal karne k liye, Unprotect Workbook par click karte hai.
7. Fir Correct Password enter karke , OK karte hai.

Share Workbook :- iska use se File ki Same Sheet par Same time par ek se zyada users ek sath kisi bhi
workbook k work ko Share karke complete kar sakte hai. iske use se workbook k Data
ko merge karke ek sath bhi kiya ja sakta hai.

Steps:
1. Sabse pahle Share Workbook par click karte h ai, jisse ek Dialog Box Show Hota hai.
2. isme Allow Changes By More Than One Users At Same Time. This Also Allow The
Workbook Merging. k aage () click karna hota hai.
3. fir ek dusra dialog Box show hota hai isme OK karte hai.
4. command ko use karne k baad workbook ko vapas normal karne or command ko
OFF karne k liye () mark ho mouse se click karke hata dete hai, fir OK karte hai.

Note:
a. Share workbook k use k liye sabse pahle File Save karna hota hai.
b. Share Workbook command k use k liye Computer me LAN (Local Area Network)
kahona zaruri hai.
c. Kisi bhi workbook k Data me agar Table insert ki gayi hai to us Workbook ko Share
workbook k use se Ek se Zyada users k beech Share nahi kiya ja sakta hai.
d. Share Workbook command k ON hone se MS-EXCEL ki Menu ki Linking Commands
work nahi karti hai, eg. Conditional Formatting, Insert, External Data, Advance
Filter, Remove Duplilcates, Group etc.
Protect Shared Workbook :- Share workbook k use se share kiye gaye Data ko Password k use Protect karne
k liye iska use kiya jata hai, jisse Share Workbook or Track Changes Correct
Password k bina Turn Off nahi hoti hai.

Steps:
1. Sabse pahle Protect & Share Workbook par click karte hai, isse Dialog box
Open ho jata hai.
2. Yaha Sharing with Track Changes k aage () click karte hai.
3. yaha par Protect karte time Workbook or Track changes ko Password
dekar or bina password k bhi Protect kiya ja sakta hai, uske baad OK click
karte hai.
4. Fir Password ko Re-enter karte hai, or OK karte hai.
5. iske bad ek Dialog Box show hota hai , isme bhi OK karte hai.

Note:
a. agar Workbook Shared nahi hoti hai to hi ise Pasword dekar Protect kiya ja
sakta hai.
b. But agar Workbook already shared hai, to Password dekar Shareworkbook
ko Protect nahi kiya ja sakta ise bina Pasword k hi Protect karne k liye OK
karna padta hai.

Track Changes :- HighLight Changes : iska use file me kiye gaye changes ko Highlight karne k liye kiya
jata hai. file me kiye gaye changes jaise insertation ,
Deletation, Formatting etc. ko Track karke Highlight kiya ja
sakta hai.

Steps:
1. Sabse pahle Track Changes command me jaker, fir Highlight
Changes par click karte hai.
2. Screen par ek Dialog box open ho jata hai, isme Highlight Changes
while editing, This also Share Your Workbook ko () Cheaked
karte hai,
3. ab OK par click karte hai. fir dobara dusre Dialog box me bhi OK
click karte hai.

ab ager file me kuch bhi editing ki jayegi to un cells par Mark lag jate
hai, in Mark par cursor rakhne se cell me kiye gaye changes or use
related information jaise Time, Date, etc. Highlight hote hai.

Accept/Reject Changes : File me kiye gaye Highlight Changes ko Permanentaly accept

or Reject karne k liye is command ka use kiya jata hai.
 Steps:
1. Sabse pahle Track Changes pr click karte hai.
2. Fir Accept Or Reject Changes me click karne se ek Dialog Box Open
ho jata hai, yaha OK karte hai.
3. OK karte hi sceen apr ek dialog Box open hota hai, ager changes ko
Accept karna ho to Accept par click karte hai or ager changes ko
Reject karna ho to Reject par click karte hai.
4. Fir OK par click karte hai.
Iske bad Highlight changes command ko vapas OFF kar dete hai.
Note:
a. Track Changes Command ka use karne k liye File kop Save karne
Zaruri hota hai.
VIEW

Normal :- iska use Document ko Normal View me Dekhne k liye kiya jata hai.

Page Layout :- iska use Document ko is tarah dekhne k liye kiya jata hai jaise wo Print me Show hoga. Isse
current Page ka start & ending Point bhi dekha ja sakta hai. ager Header & Footer lagane ho to
Use bhi yaha se lagaya ja sakta hai.

Page Break Preview :- iska use Document ka Page Break Preview Dekhne k liye kiyda jata hai. Print k time
jaha se Document alag-alag Pages me Break hota hai waha par Breaking Line Show
karta hai. or File k unused Part ho Grey colour me show karta hai.

Custom View :- Custom View k use se kisi bhi selected Area or Selected area Set ko Koi Bhi name Dekar Add
kiya ja sakta hai. selected cells Ek List me Purticuler name se Save ho jata hai, jise baad me
select karke wahi area dekha ja sakta hai.

Steps:
1. Sabse pahle area select karte hai, jise list add karna ho.
2. Agar Multiple Area select karna ho to CTRL key Press karke Area select karte hai.
3. Ab Custom View command me jakar Add par click karte hai.
4. selected area k liye koi bhi Name dete jis name se list me Add karna hota hai
5. OK click karte hai.
6. Jab bhi Dpcument me Add kiye Gaye area ko dekhana hota hai to vapas Custom View par
click karte hai.
7. Ab yaha pahle se Add kiye gaye Area ki list show hoti hai inme se kisi bhi list par click karte
hai jise dekhna hota hai.
8. Fir Show par click karte hai.
Full Sceen Reading :- Current Document ko Full Screen Mode me Dekhne k liye iska use kiya jata hai.

GridLines :- Current Sheet par Row or Column ki Lines ko Show Or Hide karne k liye is cpmmand par ()
Check kiya jata hai.

Formula Bar :- sheet k Formula Bar ko Show or Hide karne k liye Formula Bar k agge () checked kiya jata
hai.

Headings :- Sheet me show hone wali Row or column ki Heading ko Show or Hide karne liye iske aage
() checked or unchecked kiya jata hai.

Zoom :- Current sheet ko Zoom karne k liye iska use kiya jata hai, iske use se Sheet k Matter ko apne
according 25% se 400% tak ki limit me Zoom kiya ja sakta hai, Zoom to selection k use se kisi
Selected Cells ko Full Zoom me Dekha ja sakta hai.

New Window :- iske use se kisi bhi Open file ki jaise same windows Screen Open ki ja sakti haim, in
Duplicates Windows ka matter Original File se Bilkul Same hota hai but new Open ki huyi
Windows k name alag-alag hote hai. eg. Basic Computer, Basic Computer 1:1, Basic
Computer 1:2, Basic Computer 1:3 and So on…

Arrange All :- ek sath chal rahe sabhi Programms, Files, Windows, ek hi Sceen par ek sath Arrange karne k
liye is command ka use kiya jata hai. Programms ko apne according kisi bhi manner me Arrange
karne k liye Arrange All command me 4 (FOUR) options Show hote hai, Tiled, Horizontal,
Vertical, Cascade.

Freeze Panes :- Freeze Panes : iske use se sheet k kuch Part ko is tarah se Freeze kiya ja sakta
hai jisse Freeze kiye gaye Rows or Columns Fix ho jate hai, and move
or Scroll nahi karte but sheet ka baki Part Scrolling Karne se Scroll hota
hai.

Freeze Top Row : Sheet ki first Row ko Fix karne k liye ise use karte hai.

Freeze Top Column : Sheet k Top Column ko Freeze karne k liye ise use karte hai.
 UnFreeze Panes : Freeze kiye gaye Area ko vapas normal or UnFreeze karne k
liye iska use kiya jata hai.

Split :- Current Window ko 2 ya 2 se zyada Part (Multipale Parts) me Divide or Split karne k liye
iska use kiye jata hai,

Features:
a. Divide ki gayi windows resizable hoti hai, jisse windows k size ko Mouse se zarurat k according
Change kiya ja sakta hai.
b. iske use se ek hi Sheet k Long-Distance Area ko bhi Window k Multiple Parts me Distributes
karke ek sath Dekha ja sakta hai.

To MAKE SPLITS NORMAL

Split ki gayi Windows ko Vapas Normal karne k liye Us Cells par click karte hai jaha se window
ko split kiya gaya tha Fir Split par Click karte hai.

Hide :- kisi bhi Open Window ko Hide karne k liye Hide ka use kiya jata hai. isse File Close or Delete to
nahi hote But Hide karne k Bad Sceen Par Dikhayi nahi deti.

Unhide :- Hide ki gayi Window ko Vapas Show karne k liye Unhide ka use kiya jata hai.

View Side By Side :- 2 (Two) Documents ko is command k use se Campare kiya ja sakta hai. iske use se
Document Windows Side by Side View me Show hoti hai, jisse Document k Matter ko
aasani se Campare kiya ja sakta hai.

Synchronous Scrolling :- Campare kiye Gaye Document ki Scrolling ek sath karne k liye Synchronous Scrolling ko
Turn ON kiya jata hai. agar Campared kiye gaye Documents ki Scrolling ek sath nahi
karni to is command par vapas click karke Turn OFF kar dete hai.

Reset Window Position :- Campare kiye huye Documents ki Window Position ko Vapas Side by Side View me
Barabar(=) Size me Show karne k liye iska use kiya jata hai.

NOTE:
 a. View Side By Side command tabhi chalti hai, jab 2 files already Open hoti hai, kyuki Camparision k liye atleast 2
Files ka open hona zaruri hota hai.
b. Synchronous Scrolling and Reset Window Position commands View Side By Side command Turn ON karne k
baad hi Automatically ON ho jati hai, kyuki ye Dono commands View Side By Side ki Complementary and
Dependent Commands hai.

Save WorkSpace :- Save WorkSpace ka use Multiple Saved Files ko ek sath New Grouped Name se Save
karne k liye kiya jata hai. iske use se ek sath open ki huyi Windows ek New name se
save ho jati hai, is New file ko Open karne se isme Group ki gayi saari File ek Sath Open
ho jati hai.

Steps:
1. sabse pahle ek se Zyada Windows or Files Open karte hai, jinko Group kar k save karna
chahte hai.
2. fir Save WorkSpace Command par click karte.
3. Yaha Files ko Group me Save karne k liye ek New Name Likh kar File Save kar Dete hai.
4. Ab sabhi Open Files ko Close kar dete hai. (CTRL+W)
5. Fir New Grouped ki Gayi File ko Open karte hai.
6. Isse sabhi files ek sath Open ho jati hai.

Switch Windows :- Excel me Currently Open ki gayi Files ki List Show karta hai, yaha se kisi dusri Opened
File par Direct click karke Pahucha ja sakta hai.

Macro :- kisi New Macro ko Record karne k liye ya fir pahle se Bani huyi Macro ko Access karne k liye
Macro Cammand ka use kiya jata hai. iske use se KEYBOARD ki KEYS k Special Combination se
kise bhi Pre-determind Matter Or Data k ShortCuts create or Record kiya ja sakta hai

Steps:
TO RECORD NEW MACRO
1. Kisi bhi Cell par click karte hai, jaha par Recording karni hoti hai.
2. Fir Macro me Click karte hai.
3. Ab Start Recording par click karte hi ek Dialog Box Open ho jata hai.
4. Yaha par pahle Shortcut Keys k neeche CTRL k aage bane Box() me SHIFT k sath koi bhi ek
Combination key Press karte hai, ise Shortcut kid Tarah use kiya jata hai. eg. CTRL+SHIFT+P,
CTRL+SHIFT+S, etc.
5. ab OK click karte hai, jisse Dialog box Close ho jata hai.
6. ab selected Cell me kuch bhi matter Type karte hai, TYPE…
eg. Computer is an Electronic Machine which is Capable to solving Problems by
accepting Data, then after Processing Shows the Result of these Oprations.
7. ab ENTER ( ) key Press karte hai.
8. Fir Vapas Macro command me click karke, STOP recording par click karte hai.
9. Esa karte hi Cells me Written Matter Macro me Convert ho jata hai.
10. Kabhi bhi File k kisi bhi cell Shortcut or key combination (CTRL+SHIFT+P) ek sath Press karte
hai, matter automatically us cell me TYPE ho jata hai.
TO DELETE A MACRO
1. Macro me click karke, VIEW Macro me click karte hai.
2. Isse Sceen par ek Dialog Box open ho jata hai, is Box me Pahle se bane huye Macros k Name ki
list show hoti hai.
3. List me se jis bhi Macro ko Delete karna ho us Macro ko Choose karne k baad click karte hai.
4. Fir Dialog Box me se DELETE par click karke OK click kartehai.
5. Iske baad selected Macro permanently Delete ho jata hai or iske liye use ki jaane wali
Combination keys bhi koi work nahi karti.