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 […]
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.
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
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
Got a pair of 3D glasses? If you want to discover only 3D videos on youtube, add 3D to your search query Example: gravity, 3D movie, 3D
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 […]
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 […]
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 […]
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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | Sub combineMultipleColumnsData() ' This macro combines data in multiple columns into a single column ' In this example, i took numOfColumns=10, you can change it as per your requirement Dim rng As Range Dim iCol As Integer Dim lastCell As Integer Dim numOfColumns As Integer Set rng = ActiveCell.CurrentRegion iCol = 1 numOfColumns = 10 Range("A1").Activate Cells.Sort Key1:=ActiveCell, Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom lastCell = rng.Columns(iCol).Rows.Count + 1 For iCol = 2 To numOfColumns Application.Columns(iCol).SortSpecial SortMethod:=xlPinYin Range(Cells(1, iCol), Cells(rng.Columns(iCol).Rows.Count, iCol)).Cut ActiveSheet.Paste Destination:=Cells(lastCell, 1) lastCell = lastCell + rng.Columns(iCol).Rows.Count Next iCol End Sub |
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.
1 2 3 4 5 6 | Sub removeBlankRowsInsidecell() Dim cellWithBlankRows, cellWithoutBlankRows 'Remove blank rows inside cell cellWithBlankRows = ActiveCell.Value ' example cellWithoutBlankRows = Replace(cellWithBlankRows, Chr(10), "") ' removing blank lines inside cell End Sub |
In the above code Chr(10) […]