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

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...

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!

Install Kali Linux - Right from creating bootable USB drive to resolve wifi not connected issue post Kali installation

Install Kali Linux as Dual boot mode in Windows Table of Contents Create a bootable USB pendrive Set up partition for Kali OS using Kali Live Configure bootloader in BIOS Resolve Unable to Locate packages issue Resolve Wifi not working in Kali issue Resolve Bluetooth not working in Kali issue Create a bootable USB pen drive Download the following files Download Kali ISO Download Rufus Open Rufus exe as Administrator Select the USB drive location Select the Kali ISO image Set Volume name - any name Click Start and set write mode as "DD" not "ISO" mode to avoid any installation error Now your bootable USB drive is ready Set up partition for Kali OS using Kali Live You can use kali linux as live mode when you don't want to have a persistent install in your system. I would like to install it my PC in dual boot mode, So i can use GRUB bootloader to load kali or windows during system start To install kali linux in your system, ...

Tech Notes

Search This Blog