1: How to Move in Diffrents Cells(Rows and Columns)?
Move UP = Press UP Arrow From Your keyborad
Move Down = Press Down Arrow From Your keyborad
Move Left = Press Left Arrow From Your keyborad
Move Right = Press Right Arrow From Your keyborad
Move to Start of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+UP Arrow)
Move to End of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Down Arrow)
Move to Left of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Left Arrow)
Move to Right of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Right Arrow).
 |
3rd Class of Excel Training Video Tutorials in Urdu and Hindi |
2: How to Auto Genrate the Series in X(axis) and Y(axis)?
Type the any numaric NO in Your Selected Cell
For Example: ( 1 )
Select Your Cell and Press the left Button From Your Mouse and Press the (Ctrl) Button From Your Keyboard and Draw... in X(axis) OR Y(axis).
3: How to Auto Genrate Randomly Series in X(axis) and Y(axis)?
Type the Two numaric NO in Your Selected Cell
For Example: (3 and 6)
Select Your Randomly Numbaric NO Cell and Press the left Button From Your Mouse and Press the (Ctrl) Button From Your Keyboard and Draw...in X(axis) OR Y(axis).
4: How to Make the Custom Lists and Auto Genrate the Lists Text?
Click the office Button and go to (excel options) and Select the (Popular) Tab and Click the (Edit Custom Lists...) and create your list and click the save button.
Select the Cell And Type the any text from your list and Press the left Button From Your Mouse and Draw...in X(axis) OR Y(axis).