Skip to main content

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

Post a Comment

Popular posts from this blog

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 ...
Post a Comment
Read more

Run DVWA in a docker environment

DVWA is a Damn Vulnerable Web Application created for users to use (exploit) while learning web security testing. Requirement: Docker installed in your system Steps to install the DVWA app in Docker: Launch Docker Run 'docker pull vulnerables/web-dvwa' (To pull the DVWA file from Docker Hub) Once pull succeeds, Run the command 'docker run --rm -it -p 80:80 vulnerables/web-dvwa' Now your DVWA app is running in docker which can be accessed by 'localhost:80' or '127.0.0.1:80' Hit the URL to open the DVWA app in your browser   Just click on the Create / Reset database button and it will generate any additional configuration needed. Login with default credentials To login you can use the following credentials: Username : admin Password : password Set the difficulty level The default difficulty level is the impossible level, you can change it in DVWA Security item in the left menu. Happy Hacking!
Post a Comment
Read more

Create Google Account Using your work email ID

Google allows user to create a google account using any work email ID Visit this URL https://support.google.com/accounts/answer/27441?hl=en Click on 'Create a Google Account' shown in Step 1 Enter first name, last name and desired email name And click on "Use my current email address instead" Now you should be able to create a google account using work email.
Post a Comment
Read more