Home
Videos uploaded by user “pc shastra”
Protect Selected Cells #Type on Specific Area - Excel
 
02:25
Need some help to lock individual cells in a Worksheet, this tutorial will definitely help you. To lock certain cells or ranges in a spreadsheet first of all we have to make a little change by going through in protection tab of formatting cells then follow the same procedure of locking sheet. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 14518 pc shastra
How to Set Password on a Folder Already Existing WinRAR Archive
 
02:43
How to Set Password on a Folder Already Existing WinRAR Archive: This tutorial will show how to put password on a folder which is already existing in Winrar format. You can do it following some easy steps. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 24489 pc shastra
Text Turns to Red when Editing - MS Word
 
01:37
Sometimes we face this problem when edit or delete some texts and get trouble. This tutorial will show how to get rid of it. This problem is related to our document setting named track changes. Whenever it turns on by mistakenly we irritate so much. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 5247 pc shastra
Insert Picture into an Excel Cell
 
01:41
How to add or fit an image into a cell in Microsoft Excel. This tutorial will help you to insert/set a picture as a background in an Excel cell. Once inserted, the picture would move and size with the cell. You can do it with two ways, insert a picture as comment, or insert picture directly into a resized cell but I have shown easiest way. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 64275 pc shastra
How to Disable Pattern Lock in OPPO
 
01:21
If you want to turn off/remove lock screen password or pattern from your OPPO android device, this video will definitely help you. For this open your setting app then tap lockscreen and password. Now draw pattern and tap lockscreen password. Then disable lockscreen password. If it says to clear credential storage then go back and follow next steps.
Views: 111402 pc shastra
How to Recover Deleted Contacts from Gmail
 
01:40
How To Restore Lost Or Deleted Contacts On Android Smartphone:- If you deleted, synced, imported, or merged contacts in the last 30 days, you can undo those changes to retrieve your contacts. Note: When you recover contacts to a certain time, such as one week ago, any contacts added after that time won't show up. 1. Go to Google Contacts. 2. Click More and then Undo changes. 3. Choose a time to go back to. 4. Click Confirm.
Views: 33277 pc shastra
क्रिकेट में राज करने वाले ब्राह्मण क्रिकेटर
 
02:20
Cricketer Caste/Brahmin Cricketers - भारतीय क्रिकेट में ब्राह्मणों का दबदबा: Brahmins dominance in Indian cricket | भारतीय क्रिकेट में ब्राह्मणों का क्रिकेट पर राज़
Views: 7068 pc shastra
Protect Different Ranges with Different Password in a Worksheet
 
02:56
Excel Password Protection: - Allow Users to Edit Ranges that is the option which helps us to apply different password/permission for separate ranges in the same sheet. You can protect specific areas and allow certain users to edit cells range in one spreadsheet. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 11350 pc shastra
How to Move Cursor Inside a Cell with Keyboard in Excel
 
01:25
Shortcut key to move cursor within a cell in Excel. Some of the keyboard shortcut has been brought for you. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 14154 pc shastra
Print Background Color & Image in Word
 
02:21
To print background colour or image, we need to mark on the option that contains "Print background colors and images" in the file option. After that we can print any document with its background color and picture. Let's watch this tutorial and make it possible. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 35457 pc shastra
How to Save Text as a Picture in MS Word
 
01:58
You know how to save Text as a Picture in MS Word. Watch this tutorial and save your picture in PNG format. You can also it as jpg. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 25692 pc shastra
Add Different Colour for Each Page - Microsoft Word
 
03:09
This way you may able to add or change the background color of single page in Microsoft Word and you can also apply multiple colors for different pages very easily. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 138447 pc shastra
How to Move Taskbar in Windows 10
 
01:27
How to Change Taskbar location in Windows 10:- In this video you'll learn how to move taskbar from bottom to left, right or top windows 10. Click a blank portion of the taskbar and click on Taskbar settings. Now go to "Taskbar location on screen" and choose a location from drop down. Another way, unlock the taskbar by right click on a blank area of the taskbar. Hold down the primary mouse button, and then drag the mouse pointer to the place on the screen where you want the taskbar.
Views: 12888 pc shastra
Make YouTube Comments Bold, Italic & Strikethrough
 
01:39
How to Make Bold Letters on YouTube. This tutorial will also help you to apply italic & strike-through formatting on YouTube comments. You can easily make comments on YouTube videos in bold, italic or strikethrough format if you want instead of the normal default format and post the comment as you normally do. The comment will appear in bold format or what instructions followed by you. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 48159 pc shastra
Get Rid of Black Blinking Cursor
 
01:45
Black blinking cursor fix it now in VBA. If this problem related to your system change its setting with control panel. In VBA when you are creating codes your cursor turns in black box because of hitting wrong key mistakenly but this problem is happening in all other program change cursor size with setting. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 38815 pc shastra
Hide/Unhide a File or Folder in Windows 10
 
02:47
Locate the file or folder you want to hide or display on Windows. Select properties by right clicking and enable hidden check box. After that open windows explorer and make some changes here and completely hide your files & folders. You can unhide them with the same way. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 3792 pc shastra
Keyboard Shortcut to Hide and Unhide, Row and Column in Excel
 
01:04
Shortcut key for hide row and column in Excel. In this tutorial you will also learn unhide row and column. This video will definitely help you. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 8467 pc shastra
How to Hide and Protect Formulas - Excel
 
04:01
If you want to prevent other users from seeing or modifying your formulas you will have to go through format cells option. In the protection tab make some changes before applying or locking a worksheet. After these changes put password on spreadsheet and protect you formulas from others. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 23681 pc shastra
Convert Text to a Table or a Table to Text   Word
 
02:26
Converting text to a table or a table to text in Microsoft. For this procedure first of all you have to arrange your data by data separator like tab key or using comma then select data in change it into a table. Note:- If you want to get back your data same as you arranged, you'll have to click on to tab or comma. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 4497 pc shastra
How to Resize an Image in Microsoft Paint
 
02:03
Reducing the Size of an Image File using Microsoft Paint. Open your picture/photo with Microsoft Paint, On the Home tab find the button Resize and click it. You'll see the Resize and Skew box, where you can change picture size by percentage/pixels. You need this trick when you are filling an online form and you have to attach an image and your signature. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 14192 pc shastra
How to Adjust Letter Spacing in Word
 
02:48
Learn how to change spacing between characters in MS Word. In this tutorial you will also see how to manage space between lines & paragraphs. For this first you have to go on the Home tab, click the Font Dialog Box Launcher, and then click the Character Spacing tab. In the Spacing box, click Expanded or Condensed, and then specify how much space you want in the By box. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 169154 pc shastra
Excel Conditional Formatting #Use of Len Function
 
04:26
Excel Conditional Formatting: - Highlight invalid entry in a field with the help of len (Length) formula. Sometimes whenever we are making entry we make some mistakes. These mistakes can be highlighted with the help of conditional of conditional of conditional format and correct it at once. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 2156 pc shastra
Freeze or Lock Row and Column Separately or Together in Excel
 
02:26
It's very simple to freeze row and column at the same time in excel. You can lock multiple rows and column together in Excel. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 56117 pc shastra
How to Import Contacts from Phone to Gmail
 
01:20
How to Import Contacts from Phone to Gmail:- If you want to copy contacts from android to gmail follow these simple steps. Some smartphones have different method but this video helps you to transfer your contacts on OPPO android device. To do this open setting app then tap contacts. Now tap on Import/export contacts then Export to storage device. After exporting contacts, tap Import from storage device then select your google account then go ahead. Here you can see contacts is selected you need to tap OK.
Views: 58224 pc shastra
Apply Superscript & Subscript in Excel
 
02:39
Learn how to use Superscript and Subscript in Microsoft Excel. These features are invisible in home menu like MS Word. These features are available in Format Cells option in Font tab. And there are no shortcut keys for both. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 40139 pc shastra
Microsoft Excel - Keyboard Shortcuts to Group or Ungroup Rows and Columns
 
02:12
These shortcuts will help you to group or ungroup selected rows and columns in Microsoft Excel. After grouping rows and columns you can easily hide or unhide a batch or rows and columns when you need it. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 3247 pc shastra
Tricks for Custom Number Format in Excel (Must watch)
 
06:40
Custom Number Formatting in Excel:- Apply custom numbers/texts format on cells or range. You can create your own number format. Excel provides several built-in formats. You can convert General format into Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and modify with your choice. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 24162 pc shastra
सचिन नहीं बल्कि इस बल्लेबाज से खौफ खाते थे शोएब अख़्तर
 
01:53
Shoaib Akhtar was afraid of this batsman instead of Sachin: Shoaib Akhtar's name comes in the fastest bowlers in cricket history. Even the good batsmen were afraid to face Shoaib Akhtar's balls. Akhtar had injured many batsmen from his lethal bowling attack to the hospital but there was also a batsman in the Indian cricket team who was not afraid to bat in front of Shoaib Akhtar. Rather Shoaib Akhtar himself was afraid to bowl in front of that batsman. In an interview given to Vision India, Shoaib Akhtar said that I am thankful to Sachin Tendulkar, Sachin made me a star. There is no doubt that Tendulkar is a great batsman and he was like a scary dream for any bowler to bowl in front of him. But in the course of my career, the batsman I was most afraid of bowling in front of me is Rahul Dravid. With Dravid landing on the crease, I used to intimidate myself. When bowling in front of me, I felt that I should now practice 2 sessions and practice. According to Shoaib Akhtar, it was even more difficult to dismiss Dravid in Tests, because Dravid completely breaks the bowler completely. Bowlers who bowl in front of Dravid are tired. Dravid was like boxing legend Mohammed Ali, who knocked him out after his opponent got tired.
Views: 1522 pc shastra
Show or Hide all Comments and Comment Indicators in Excel
 
01:45
Hide/Unhide all comments when you move your cursor around cells containing comment in Excel. If you don't want to display comments for some reasons like while inspecting elements you get disturbed. In such case you can hide all comments using Excel option. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 11146 pc shastra
How to Sign Out from Gmail in Android Mobile
 
01:34
How to Log Out from Gmail Account in Smart Phone:- This quick tutorial will help you to Sign out from a Google Account in a Smart Handset Device. In Android Mobile there is no option available to sign out. Finally we have to delete/remove our account. When you remove an account, it removes the account from all apps on the device. When your account is removed, you won’t be signed in to any Google products, like Maps or YouTube. This option is good if you want to remove personal information from your device before you give it to someone else. Note: Removing the account from your phone or tablet won't delete the account itself, so you'll still be able to use it on a computer or other devices.
Views: 147664 pc shastra
How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel
 
02:13
With the help of transpose option in paste special option you can make it very easily. In this tutorial I have explained it very simple manner. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 73328 pc shastra
Excel PMT Function: Calculating Loan Payments
 
02:13
Excel PMT Function: PMT, one of the financial functions, calculates the payment for a loan or investment based on constant periodic payments and a constant interest rate. PMT is a fastest way to calculate EMI . 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 4033 pc shastra
Insert a Formula in a Table Cell - MS Word
 
02:47
How to use Formula in MS Word. Learn how to work with Function in a Word's Table: -Formula in table watch now if you want to insert a formula in a Table cell must watch this tutorial. To create formula in a table this tutorial would remove the doubts about the formula. Select desired cell where you want to add formula then follow steps directed in this video. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 16770 pc shastra
Auto Fit Text in Excel including Shortcut Key (Three Ways)
 
01:22
There are three ways of auto fit text in excel described in this tutorial including keyboard shortcut. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 19493 pc shastra
Turn On/Off Speak Cells Command - Excel 2007
 
03:05
Enable or disable Speak Cells Command in Excel 2007. Speak cells a feature that allows users to hear the cell value. You can use Speak cells by columns/rows or make it speaking on enter. There is an option that stops speaking cells. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 6426 pc shastra
How to Create New Folder without Name
 
01:27
Create a Nameless Folder on you PC. Create a new folder or right click on a folder already exist then select rename. Now hold "Alt" key from Numeric keypad, press 0160 and release "Alt" key then hit Enter. This works once on a same location. So you can try second process to do it. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 5870 pc shastra
How to Create Facebook Shortcut on Desktop
 
01:50
Creating Facebook Shortcut:- How to Create/Add Websites Shortcut on your Desktop; This short video will show you in a few simple steps how to create a website shortcut like YouTube, Facebook or any your favorite site on your computer's desktop. For this open the webpage inside the browser for which you want to make a shortcut. Click on page menu which is given at the top right corner. On the drop down menu under more tools click on “Add a Desktop”.
Views: 40320 pc shastra
How to Move Windows Taskbar Around the Desktop
 
01:16
How to move Taskbar left, right, up and down in Windows. To change the default position of of the taskbar in Windows 8, follow some simple steps and solve this. Windows 7's setting is different to the Windows 8. This way you can set your taskbar horizontal to vertical and finally you bring it back to the bottom. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 4441 pc shastra
How to Remove Instagram from Facebook App in Android
 
01:27
How to Unlink Instagram from Facebook App & Facebook from Instagram App:- Do you know, Instagram allows you to share your own photos and other photos or post you like to your Facebook (FB) Timeline, which also may cause them to appear in your friends' Facebook news feed. If you want your Instagram activity to stop showing up on Facebook, you can easily disconnect your Facebook account from your Instagram app settings.
Views: 19697 pc shastra
How to View Multiple Pages with Shortcut Key in MS Word
 
01:12
There are three way to view multiple pages in MS Word. You will also learn about the keyboard shortcut in this tutorial. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 16884 pc shastra
Keyboard Shortcut for Text Alignment - Microsoft Excel
 
01:36
Align your text using with the help of these shortcut key. There isn't a perfect shortcuts available in Excel but these shortcuts will help to some extent. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 9324 pc shastra
Excel VBA - Autofit Cell Content
 
03:12
Excel VBA Macro: Autofit text on a Worksheet/Workbook with the help of VBA. This coding will help to fit cell content automatically. In other words you can say fit columns automatically in excel. After making a cell entry columns automatically adjusted. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 8318 pc shastra
Sort Data Horizontally in Excel
 
01:48
Sorting in Excel: - Sort data range horizontally according to row in Excel. In other words you can say reordering columns using horizontal sort from left to right. This way you can arrange a data range largest to smallest or smallest to largest from left to right. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 9571 pc shastra
How to Make Different Page Sizes in Microsoft Word
 
02:39
Different paper sizes on the same doc - Microsoft Word. Insert multiple paper size in a single Word document following some easy steps. You can change the size of paper forever not for temporary session. Following this way you are able to add different paper sizes like Letter, Tabloid, Legal, Statement, Executive, A3, A4, A5 etc. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 152990 pc shastra
How to Delete a Page in Microsoft Word
 
01:06
This tutorial will help you to delete a page in Microsoft Word. That page you want remove from the document with its content, Go to the find option and click on "Go To" and type backslash and page now close "Go To" and press "Delete" button from your keyboard. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 2146 pc shastra
Use the MIN, MINA, MAX & MAXA Function in Excel
 
02:25
This tutorial will help you to find the lowest and highest values with the MIN and MAX functions. Max formula returns the largest value in a set of values while Min does just opposite of the Max. MaxA function returns the largest value in a list of arguments. It counts "True" as 1 and "False" as 0. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 3883 pc shastra
How to Split full Name to First and Last Name in Excel
 
05:59
Extract first name and last name from full name easily. To split full name into first name and last name we need left, right, find and len function. Using these formulas we can able to separate first name and surname. This tutorial will explain how to follow these steps. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 64713 pc shastra
How to Insert Symbol in MS Word
 
02:40
Insert different kind of symbol in MS Word. Word facilitates to insert the symbol of your choice without going online as much as possible. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of MS Word ▶ How to Group Pictures in MS Word - https://www.youtube.com/watch?v=ZW61AlFO8tw ▶ How to Insert Tick Mark in MS Word 2010 - https://www.youtube.com/watch?v=01qNFUhpAmY ▶ How to Adjust Letter Spacing in Word - https://www.youtube.com/watch?v=f_rtfV5BD7I ▶ Draw & Resize Square, Round Circle and Straight Line in MS Word - https://www.youtube.com/watch?v=7YLwmFcCJuE ▶ Combine Multiple Word Documents into One - https://www.youtube.com/watch?v=R4p_y0K51lY ▶ Add, Change or Remove Page Borders in MS Word - https://www.youtube.com/watch?v=QJpYHgiWae8 ▶ Fill Text with Picture, Texture, Gradient or Pattern - Microsoft Word - https://www.youtube.com/watch?v=W4EW8hNiQTg ▶ Add Different Colour for Each Page - Microsoft Word - https://www.youtube.com/watch?v=Ogmh70IChX0 ▶ How to Insert Different Headers and Footers in Word - https://www.youtube.com/watch?v=sJHPGTwlFwk ▶ How to Make Different Page Sizes in Microsoft Word - https://www.youtube.com/watch?v=KSq7MXbvNbQ ▶ How to Insert and Delete Header or Footer in MS Word - https://www.youtube.com/watch?v=vpPj_kRP8jU ▶ Copy Multiple Text and Paste at a time in MS Word - https://www.youtube.com/watch?v=JuiZJ64CMRk ▶ How to Add or Remove Text and Picture Watermark in MS Word - https://www.youtube.com/watch?v=9J6U2DVUi50 ▶ Draw a Straight Line in MS Word and Change its Color - https://www.youtube.com/watch?v=lTs3I_pD18o
Views: 13992 pc shastra
Prevent Folder from being Copied & Deleted - Windows 8 & 10
 
03:21
How to Lock a Folder with Password: Stop users from being modifying, moving, copying, renaming and deleting your files and folders. Our important files and folders should be prevented from such actions mentioned above which accidentally being made by other users. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Chrome & YouTube ▶ How to Block Websites on Chrome - https://www.youtube.com/watch?v=318Lud0Pjcs ▶ How to Block Ads on YouTube in Chrome - https://www.youtube.com/watch?v=2JiIN-7FN28 ▶ How to Change New Tab Page in Google Chrome - https://www.youtube.com/watch?v=ZiMhCRIXlw0 ▶ How to Disable Pop Ups on Google Chrome - https://www.youtube.com/watch?v=pcjPLiovGnU ▶ How to Add an Antivirus Extension to Chrome - https://www.youtube.com/watch?v=jZnBiOfXs3g ▶ How to Download YouTube Videos - (Easy) - https://www.youtube.com/watch?v=fQEYzVRl9Rw ▶ Make YouTube Comments Bold, Italic & Strikethrough - https://www.youtube.com/watch?v=lI4Z4oqIjKw ▶ How to Insert Symbols into YouTube Comments - https://www.youtube.com/watch?v=qR8OSH8qIOU ▶ Keyboard Shortcut to Open YouTube in Full Screen - https://www.youtube.com/watch?v=LNTmbzc4Ni4 ▶ How to Apply a Theme on Google Chrome - https://www.youtube.com/watch?v=cRYaDrnFgp8 👉Some Helpful Videos of Windows ▶ Virtual Desktop Shortcuts in Windows 10 - https://www.youtube.com/watch?v=awQm-XWcgq8 ▶ How to Display Your Name on Windows Taskbar - https://www.youtube.com/watch?v=OtMmLbojp-8 ▶ How to Create New Folder without Name - https://www.youtube.com/watch?v=9D8L6lIAXHY ▶ Open Taskbar Apps with Keyboard in Windows 10 - https://www.youtube.com/watch?v=qEEzN2mWRbY ▶ Shortcut to Open Control Panel in Windows 10 - https://www.youtube.com/watch?v=5zqa-CTsku4 ▶ How to Move Windows Taskbar Around the Desktop - https://www.youtube.com/watch?v=rkjyDf5nrYc ▶ Adjust the Brightness in Windows 10 - https://www.youtube.com/watch?v=qt4CUAnkMF4 ▶ Prevent Folder from being Copied & Deleted - Windows 8 & 10 - https://www.youtube.com/watch?v=eywU5ukoDJA ▶ Resize the Taskbar Icons in Windows 10 - https://www.youtube.com/watch?v=sgMzI6DIn84 ▶ How to Minimize or Maximize Windows from Keyboard - https://www.youtube.com/watch?v=_sCfkH8v3-s ▶ How to Set Password on a Folder Already Existing WinRAR Archive - https://www.youtube.com/watch?v=oUGPoKwkiPA
Views: 36061 pc shastra
Data Validation #Prevent Duplicate Entries in Excel
 
04:54
Stop duplicate entries in a range with Data Validation. If you need to make an entry only one time in a field, this tutorial will help you how to do that. With the help of custom validation using countif function we prevent/restrict duplicate entries. This validation you can apply on a specific range, row, column or cell. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 8582 pc shastra