Tuesday, June 25, 2019

How to switch two rows in Google Sheet?


Creating tables in Google Sheets is very entertaining. You can use this free application for online spreadsheets. But it is not compulsory to use the Google Sheets power to switch two rows in the column when they are near each other. Go through the different ways to switch two rows in Google Sheet follow these procedures.
Steps to Switch Two Rows in Google Sheets by Dragging and Dropping
•    You need to left-click on the 6 number provided in the Ogre cell. Through this procedure, you can choose the whole column.
•    You need to left-click on the column again.
•    After that, keep pressing on the left-click mouse button.
•    Pull the whole Ogre column into one direction.
•    Now, you will get a silver color outline of the Ogre column.
•    Free the left-click mouse button after the Ogre column which covers the Goblin column.
Steps to Switch Two Rows in Google Sheets by Copying and Pasting
•    You need to left-click on the 3 number given near to the Extremely low-frequency option.
•    Click on the Control and C keys together on the system keyboard.
•    Choose the column from the outer of the table.
•    Let’s take an example; the 10 number column will work fine. So, you need to left-click on the number 10.
•    After that, choose the Goblin column.
•    Click on the Control and C keys together provided in the system keyboard.
•    Choose the 3 number column and choose the original column with the Extremely low-frequency statistics.
•    Click on the Control and V keys.
There is an additional way to switch two rows in Google Sheets by copying and pasting method. The starting procedure will be the same as the steps mentioned above. Go through the steps listed below:
•    You need to right-click on the 3 number which is known as Extremely low-frequency column.
•    Choose the Copy button by going to the pull-down list.
•    You need to right-click on the 10 number column.
•    Click on the Paste button.
•    You have to right-click on the 6 number column which is known as Globin column.
•    Click on the Copy button.
•    You need to right-click on the 3 number column which is known as Extremely low-frequency column.
•    Press on the Paste button.

Steps to Switch Two Rows in Google Sheets Using Power Tools
•    Click on the Control option.
•    Choose the Dwarf name given on the column.
•    Press on the Add-ons option given in the Menu list over the table.
•    Press on the Power Tools button located in the pull-down list.
•    Press on the Start option given in the adjacent pull-down list.
•    Press on the three small dots symbol located in the menu list.
•    Choose the flip symbol, which is on the right-hand side of the display.
•    Click the “Flip entire rows” button by going to the pull-down list.
Anna Mathew, writer of this blog loves to write and create awareness related to day-to-day internet threats. Major topics of her interest are Printer support like Canon Printer Support, HP Printer Support, Epson Printer Support, Lexmark Printer Support, Brother Printer Support etc.

Tuesday, June 18, 2019

How to remove location from iPhone photo?


When you capture a picture and upload it on your social media account, then it displays your current location to the viewers. Your uploaded details can be used to create a threat to the privacy of your social media account, So, it is good to remove the location from iPhone photo by following the steps mentioned below.
Steps to Remove Location from iPhone Photo
•    Go to the Settings application.
•    Go down and press on the Privacy option.
•    This privacy option resembles a white hand given on an azure color wallpaper symbol.
•    Click on the Location Services option located at the upper side of the display.
•    Find the camera symbol by going to the menu list of all the installed applications.
•    After finding the camera symbol, press on it.
•    Click on the Never option located in the “Allow Location Access” column to turn on the geotagging.
•     You will get a highlight to the right-hand side of the Never button after completing this procedure correctly.
•    You will notice that when you turn on the location services option for the Camera application, then it will not delete the geotag details from the pictures which you have already captured.
•    If you turn off in this way will work with a specific Camera application.
•    The third-party camera applications star adding the geotagging in case you are not disabled for the application.
•    In case you use third-party apps such as Instagram and Facebook to capture pictures, these applications can access the camera and capture pictures by adding the location data.
In case you have captured many pictures, and you can delete the geotag from the applications, then you wish to go through every picture for the location data.
To check that the picture is geotagged or not, then you need to follow the steps mentioned below:
•    Open the Photos application.
•    Press to launch the picture you wish to see.
•    In case the picture is already geotagged, then you will get the geographical details on your screen.
•    Slide up on the picture to go to the Places menu.
•    Now, you can see a particular location on the map where you have captured the picture.
•    In case your picture does not have the location data, then you can see the time and data over the picture.
•    When you slide up, it will not show a Places column.

Steps to Strip the Geotag details from Pictures on iPhone
•    Go to the image editor on your iPhone to immediately go to the Camera Roll.
•    Choose the image you wish and start adding it the image editor.
•    Press on the Metadata symbol at the end of the display so that you can check or customize the metadata of the chosen picture.
•    Press on the Information symbol located at the upper right-hand side to get the metadata information of the picture.
•    Search for the Data Created option and press in it to adjust the time and date of the picture.
•    You can also edit and add to the current IPTC metadata of the picture. Here you will get all the saved location data.
•    After making all the changes, you can transfer the picture by going to the image editor application into the Photo application.
Anna Mathew, writer of this blog loves to write and create awareness related to day-to-day internet threats. Major topics of her interest are Printer support like Canon Printer Support, HP Printer Customer Support, Lexmark Printer Support, Brother Printer Support etc.

Wednesday, June 12, 2019

How to activate your Pluto TV?


Pluto TV is free to use and has many different channels on the roster. It also provides many movies and TV shows. In case you wish to change to Pluto TV, then follow the steps mentioned below to activate your Pluto TV. Here you will also get the steps for enabling closed captions on both the Amazon and Roku devices.
Steps to Activate Your Pluto TV
•    Start installing the Pluto TV on the device you are currently using.
•    Open the Guide.
•    Open Channel 02.
•    Additionally, you can press on the Activate option.
•    This activate option is provided on the left-hand corner of the Pluto TV guide.
•    Now, you will get the 6-digit activation key on the upper side of the display to activate your Pluto TV.
•    In case you have already signed in, then press on the MyPluto option given on the device which you are currently using.
•    If you have not signed in yet, or do not have an account, then you need to visit the online website www.pluto.tv/activate.
•    After that, type the activation key on the given section.
In case you have decided not to use the Pluto TV, then you can disconnect the device. Here are the steps mentioned below to finish this procedure:
•    Open the MyPluto application.
•    Press on the Activate option.
•    Choose the device where you wish to disconnect to the Pluto TV.
•    Press on the X key.
Steps to Activate Your Pluto TV to the Chromecast
Internet Browser
•    Open the Google Chrome browser on the system.
•    Press on the More symbol located at the upper right-hand side of the internet browser.
•    Click on the Cost button by going to the menu list.
•    Choose the Chromcast.
•    In case it is already paired, then its symbol shows the activated status on display.
Mobile Device
•    Open the Pluto TV on the mobile phone.
•    Visit the channel which you want to cast.
•    Press on the Cast symbol located at the upper right-hand side of the screen.
•    Choose the Chromecast by going to the menu list of the casting devices which are available now.

Steps to Enable Closed Captions on Android
•    Open the Settings tab.
•    Choose the Accessibility option.
•    Press on the Captions option.
•    Enable the closed captions.
•    Open the Pluto TV.
•    Press on the display.
•    Click on the CC option.
•    Choose language.
Steps to Enable Closed Captions on Amazon
•    Turn on the accessibility settings of the Fire TV.
•    Go to the Captions column.
•    Activate the captions.
•    Open the Pluto TV.
•    Click on the menu key provided on the TV remote.
•    Choose the language which you wish to display as your caption.
Steps to Enable Closed Captions on Roku
•    Open the Pluto TV provided on the Roku.
•    Now, you need to play any audio on Roku.
•    Click on the Star option.
•    It will open the Options menu on the screen.
•    Go to the Closed captioning window.
•    Click on the Right or Left arrow to choose by going to the menu list of all the captions which are available now.
Anna Mathew, writer of this blog loves to write and create awareness related to day-to-day internet threats. Major topics of her interest are Printer support like Canon Printer Support, Brother, Lexmark Printer Support and HP printer support etc.