Delete Hidden objects in Excel

If you are a user who uses google sheets and meddling around with it a lot would have faced this problem of excessive lag while working with MS Excel.

Often the reason would be the hidden objects in the excel sheet.

How to remove it?
1.Press Ctrl+G (or) F5 to launch the 'Go to' window

2.Click on 'Special' and Select 'Objects'

3.Click 'OK'. Now you can see the objects in excel sheet are highlighted

4.Press 'Delete' Or 'Backpace' key to delete all the hidden objects
5.Save the document and Start working with it

You can experience the faster response with the excel sheet now. :)

Comments

Analyse Battery Usage using Battery Historian Tool in Android Phones

Battery Historian: Battery Historian is a tool to inspect battery related information and events on an Android device running Android 5.0 Lollipop (API level 21) and later, while the device was not plugged in. Battery Historian Tool: Ideally you should be hosting this tool in local server, since that takes time we can use this tool freely available online https://bathist.ef.lc/ Steps to do before taking battery logs: To reset the existing battery logs for a phone adb shell dumpsys batterystats --reset Now use the application which you want to take the battery analytics. After you reach the desired time you can connect the phone to your PC to take the Bug Report file. Command to use: For devices Android 7.0 & higher $ adb bugreport bugreport.zip For devices Android 6.0 & lower $ adb bugreport > bugreport.txt Start Analyzing now Open https://bathist.ef.lc/ Upload the bugreport.txt Filter the app using the package name to get ...

Deploy your portfolio site from GitHub using Netlify

Prerequisite: You must have a github account Create project and clone to your local Create a github project in github.com Clone your code from github cloud to local git clone https://username:password@github.com/alexjohn/project1.git Git init Make changes to your code Git add . Git commit -m "commit message" Git push origin master Above steps will make you push your local changes to github cloud Log in to your Netlify account & Click New site from Git Step 1 Step 2 Select your repository and publish your site You will be given a random generated URL from Netlify. You can update the replace the URL with your custom domain name To map your custom domain name to Netlify site Add a A record to your domain in your domain registrar site (godaddy/namecheap) A record Host @ IP Address: 104.198.14.52 If your DNS provider does not support CNAME-style resolution for apex domains , you must con...

Localhost is not intercepted by Burp Suite

To set your burp suite proxy to listen to your locahost you need to follow the steps mentioned below Go to Menu -> Options Navigate to 'Network Settings' Click on 'Settings' Set Manual configuration as shown in the image below Also Remove all the entries in 'No Proxy for' window (highlighted)

Tech Notes

Search This Blog