3 Steps to disable lock screen on windows


Disable lock screen on Microsoft windows operating system in 3 simple steps. You can prevent your PC from screen lock. Steps to disable windows lock screen 1. Goto C:\Windows\SystemApps 2. Look for Microsoft.LockApp_cw5nlh2txyewy3. add   .bak to end of that folder name That’s it. Windows lock screen is disabled. Notes: 1. You can’t disable this for […]

Find videos with subtitles only on YouTube

search keyword to filter videos with subtitles

If you want videos with subtitles only on YouTube, then add CC  to your search query. It displays only videos with subtitles. Example: Movie, CC Add long or short (comma separated) to filter long (> 20 min) or short (<4 min) videos.

How to find long videos only on YouTube?

query to find long videos on YouTube

Simple search query to find only long videos (more than 20 minutes) in YouTube search results. Add keyword long to the search query. Example: prank, long If you want only short videos (less than 4 minutes) in search results , then use keyword Short Example: short film, short

How to find 4K or HD videos only on YouTube?

search query to get 4K videos only on YouTube

If you want to see HD (High-definition) videos only in YouTube search results, then add keyword hd to the search query. Example: avatar, hd To get only 4K Ultra High Definition videos in search results, add 4K to the search query. Example: movie, 4K

Backup your WhatsApp data to Google Drive

You can backup your WhatsApp data (messages, photos, videos) to Google drive automatically. Follow below steps. On Android phone Open WhatsApp Goto Chats screen Click on Menu (right-upper corner, three dots in vertical) Goto Settings Click on Chats Click on Chat backup In Google Drive Settings, select your google account, how frequently you want to […]

How to install WhatsApp on Windows computer?

You can install WhatsApp on your computer if your PC operating system is Windows 8+ (or newer). Below are the simple steps. Goto https://www.whatsapp.com/download/ Click the WhatsApp download button for Windows PC. A file named “WhatsAppSetup.exe” is downloaded. Click on above downloaded exe file to install WhatsApp on your computer or PC or laptop Once […]

8 steps to install WhatsApp on Android Tablet without SIM card

Steps to install WhatsApp on Android tablet without SIM card. Goto Settings-> Security Select “Unknown sources” to enable your tablet to install apps from unknown sources Copy below secure link from official website of whatsapp and paste it into your browser such as Google chrome or any other browser    http://www.whatsapp.com/android/ Above link opens latest […]

Combine multiple columns data to single column [Excel VBA]


If you want to combine multiple columns data to a single column using excel VBA, then use below code. Below macro combines data of 10 columns and displays it in first column. Change numOfColumns variable value as per your requirement. Also see VBA macro to remove empty columns

Remove blank rows inside cell [excel VBA]


We can create new line/row inside a cell by pressing ALT+ENTER in MS Excel. If you come across a situation where you want to remove blank rows/lines inside the cell, then you can’t remove them using trim method. Below code helps you to remove them automatically using VBA code.

In the above code Chr(10) […]