In this post I am going to explain how to sort the rows in excel sheet by color. Excel provides an option to sort the rows in excel sheet by color.
In some large excel sheet rows we marked some important rows with different colors. If the excel sheet contain this type of important data with different colors and want to see all these imporant rows in one place then this sort by color is very useful option.
Below are the steps to do the sorting by color in excel sheet rows
Below is the Sample data with different color in excel sheet
In the Excel sheet click any single cell inside a data set.
On the Data tab, in the Sort and Filter group, click on Sort and the Sort dialog box appears. OR In the Home Page Editing group click on Sort and Filter and click on Custom Sort then the same Sort dialog box appears.
Sort by Customer Name (or any other column), sort on Cell Color and select the green color for the first level.
To add other colours then Click on 'Copy Level' three times and select the other colors. The Copy Level is show in the below screen shot.
Click Ok.
The result page is shows which are sort by the color. Please find the screen shot below.
You can also find the same sorting by color in excel in the below YouTube Link
Sort By Color in Excel
Saturday, December 19, 2020
Sunday, December 13, 2020
How to restore WhatsApp backup from Old Android Phone to New Android Android using Local Backup
In this article we are going to explain how to transfer Whatsapp messages from old Android phone to new Android Phone. In Whatsapp, by default Whatsapp automatically creates a backup daily at 2am. The folder is located in your device's internal memory Whatsapp/Databases. This local backup used to transfer WhatsApp messages between Android devices. Pleae follow the below steps..
NOTE: Both old and new phone should have latest whatsapp versions. If both are in latest version we will get the latest backup file i.e same cryp version of the backup file.
Old Phone :
Go to Whatsapp/Databases folder in old phone.
In Databases copy the latest msgstore.db.cryp12 and Send to your new phone through SD Card or Using Computer. Dont do any rename to the backup file.
If you have installed the WhatsApp on an external SD card, simply take the SD card out of your old phone, and put it into your new one
New Phone:
Install the latest whatsapp version.
It will create a folder called Whatsapp. Now copy the msgstore.db.cryp12 to the folder Whatsapp/Databases. If databases folder is not exist create a folder in Whatsapp foler with name Databases.
Now open the whatsapp and provide the number and OTP. After OTP is succesfull it will check for the back up and you would be notified that a message backup was foun and asks you to restore or skip the backup.
Now you click on the Restore option. Whatsapp will restore all you old phone data into your new phone.
You can also view the same in the below Youtube Link
https://youtu.be/DQGooYVwiO8
NOTE: Both old and new phone should have latest whatsapp versions. If both are in latest version we will get the latest backup file i.e same cryp version of the backup file.
Old Phone :
Go to Whatsapp/Databases folder in old phone.
In Databases copy the latest msgstore.db.cryp12 and Send to your new phone through SD Card or Using Computer. Dont do any rename to the backup file.
If you have installed the WhatsApp on an external SD card, simply take the SD card out of your old phone, and put it into your new one
New Phone:
Install the latest whatsapp version.
It will create a folder called Whatsapp. Now copy the msgstore.db.cryp12 to the folder Whatsapp/Databases. If databases folder is not exist create a folder in Whatsapp foler with name Databases.
Now open the whatsapp and provide the number and OTP. After OTP is succesfull it will check for the back up and you would be notified that a message backup was foun and asks you to restore or skip the backup.
Now you click on the Restore option. Whatsapp will restore all you old phone data into your new phone.
You can also view the same in the below Youtube Link
https://youtu.be/DQGooYVwiO8
Saturday, December 12, 2020
How to convert Capital Letters to Small letters in Excel Sheet
In this post I am going to explain how to convert text from Capital letter to small letter using built in Excel function LOWER and same is vice versa for the Small to Capital letter using the function UPPER. Like Microsoft WORD we dont have function in EXCEL to changing capitalization.We can use the UPPER and LOWER functions to automatically change the case of existing text to uppercase and lowercase. In Excel we have another function called PROPER which capitalizes only the first letter in each name.
Excel convertion from capital to small letter is explain below with the screen shots
In the below example we have two columns 1. CUSTOMER Names 2. Sample Codes.
To convert from Capital to Small letter first we hvave to insert a temporary column next to the column that contains the text you want to convert. Here we have added a new column B to the right of the CUSTOMER Names column. Please find the screen shot below in which the new column B is marked with green color.Now move your curson in cell B2 and type the function =LOWER(A2) and then press Enter. Please find the screen shot below with the function typed in the column B2.
Now the column B2 the text is converted into Small letters. Now we can apply the same to other values by dragging the small black square that appears in the lower-right corner of the cell or the quickest way to do this is by selecting cell B2 and then double-click the small black square that appears in the lower-right corner of the cell. Please find the screen shot below for the same.
Now the values are converted into small letters. Please find the screen shot below Now we can use this small letter and copy it to the required columns. Here when we copy to required columns then formulas also copied to column. So to avoid formulas and have only values we have to select the Option Only values in the Paste option. Please find the screen shot below. Note: The process is same if we want to convert from Small letters to Capital Letter by using the Function UPPER.
You can also we the same in my youtube channel link
How to convert Capital Letters to Small letters in Excel Sheet
Excel convertion from capital to small letter is explain below with the screen shots
In the below example we have two columns 1. CUSTOMER Names 2. Sample Codes.
To convert from Capital to Small letter first we hvave to insert a temporary column next to the column that contains the text you want to convert. Here we have added a new column B to the right of the CUSTOMER Names column. Please find the screen shot below in which the new column B is marked with green color.Now move your curson in cell B2 and type the function =LOWER(A2) and then press Enter. Please find the screen shot below with the function typed in the column B2.
Now the column B2 the text is converted into Small letters. Now we can apply the same to other values by dragging the small black square that appears in the lower-right corner of the cell or the quickest way to do this is by selecting cell B2 and then double-click the small black square that appears in the lower-right corner of the cell. Please find the screen shot below for the same.
Now the values are converted into small letters. Please find the screen shot below Now we can use this small letter and copy it to the required columns. Here when we copy to required columns then formulas also copied to column. So to avoid formulas and have only values we have to select the Option Only values in the Paste option. Please find the screen shot below. Note: The process is same if we want to convert from Small letters to Capital Letter by using the Function UPPER.
You can also we the same in my youtube channel link
How to convert Capital Letters to Small letters in Excel Sheet
Sunday, November 29, 2020
Waterfalls in Bhairavakona
Bhairavakona is a holy place situated in the Prakasam district of the Indian State of Andhra Pradesh.Located in the heart of the famous Nallamala hills in the Chandra Sekhara Puram Mandal of Prakasam district, Bhairavakona attracts several tourists from across the country. The place is famous for its rock-cut cave temple. The temple is carved from a single stone , Eka sila. Bhairavakona is 43 km from Udayagiri, a town in Nellore district. APSRTC's Udayagiri depot provides buses to Seetharamapuram which is 15 km from Bhairavakona. From Seetharamapuram one can take share Auto's to Bhairavakona. The distance from the Prakasam district head quater Ongolge is around 145 kilometers. This place is home to an ancient Shiva temple.
There is waterfall which falls from a height of 200 metres and there are eight temples carved in the hill there.
There is waterfall which falls from a height of 200 metres and there are eight temples carved in the hill there.
Tuesday, October 27, 2020
How to Disable comments in YouTube Channel
The YouTube Channel Comments can be disable by followning the below steps
You can also check the YouTube Channel comment disabled in the below
https://www.youtube.com/watch?v=MA7TzHCg5Bk
Steps:
- Sign in to YouTube Channel
- From the Right Side corner Google Account Select Youtube Studio
- From the left menu, select Videos.
- When we move the cursor over the Video it wills show the options like Details, Analytics, Comments etc.. Click on Details Option.
- It will open the Basic details of the Video. Now select the More options
- When you go down you will see a section called “Comments and ratings", there you can choose your comment settings.
- Select Save.
You can also check the YouTube Channel comment disabled in the below
https://www.youtube.com/watch?v=MA7TzHCg5Bk
Friday, September 18, 2020
How to do screen recording in Windows 10
In Windows 10 Xbox Game Bar is useful to do screen recording. Unfortunately, it can't capture some programs, such as the entire desktop, File Manager but it does work desktop apps.
Steps:
1) Type the word Xbox Game Bar in search box of Windos 10 or you can use short cut Windows and G at the same time to open it.
2) Click the Capture button in the application to start the recording
3) Click the red recording button to stop the recording. This will be on the top right of the window. ( If it disappears you use Windows + G)
4) The recorded videos will be sahred in the Videos folder ( i.e ex C:\Users\yourusername\Videos\Captures)
Steps:
1) Type the word Xbox Game Bar in search box of Windos 10 or you can use short cut Windows and G at the same time to open it.
2) Click the Capture button in the application to start the recording
3) Click the red recording button to stop the recording. This will be on the top right of the window. ( If it disappears you use Windows + G)
4) The recorded videos will be sahred in the Videos folder ( i.e ex C:\Users\yourusername\Videos\Captures)
Tuesday, August 4, 2020
Whatsapp - How to save Whatsapp Chat history
Bydefault in WhatsApp chats are automatically backed up and saved daily to your phone's memory. If you are uninstalling WhatsApp from the phone and don't want to lose your messages, be sure to manually back up your chats before uninstalling.
Whatsapp Back up chats
Go to WhatsApp > Settings > Chats > Chat backup > BACK UP.
If you want to export chat history please follow the below steps.You can use the export chat feature to export a copy of the chat history from an individual or group chat.
In Whatsapp open the individual or group chat. Click on three dots > More > Export chat.
Then it will ask to export with media or without media.
Selet option with media or without Media then an email will be composed with your chat history attached as a .txt document.
You can also check in the video link
https://www.youtube.com/watch?v=L1yVpT4WSKk
Whatsapp Back up chats
Go to WhatsApp > Settings > Chats > Chat backup > BACK UP.
If you want to export chat history please follow the below steps.You can use the export chat feature to export a copy of the chat history from an individual or group chat.
In Whatsapp open the individual or group chat. Click on three dots > More > Export chat.
Then it will ask to export with media or without media.
Selet option with media or without Media then an email will be composed with your chat history attached as a .txt document.
You can also check in the video link
https://www.youtube.com/watch?v=L1yVpT4WSKk
Subscribe to:
Posts (Atom)















