How to Remove Blank Space on a Excel Document [Quick Excel Tutorial]
Do you like our content? Buy us a cup of coffee! ☕
https://ko-fi.com/burntolearn
The next time you want to eliminate rows and columns that are blank do this:
Of course you can use the delete option to eliminate just a few blanks, but what happens when you have dozens or hundreds of blank rows and columns?
First select all your content by pressing Ctrl + A. Then being in the home tab click on the find and select button. Of the options available click on the go to special one. A new window is opened. Here, check the blanks option, then click ok.
Now, all the cells that are blank will be selected. Finally in the home tab click on DELETE, and all the rows will be deleted. Repeat the same process to delete the columns. And that’s it!
🔔 Subscribe to our YouTube channel
/ burntolearn
Burn To Learn - T-Shirts 👕
https://burntolearn.threadless.com/de...
Visit our website http://www.burntolearn.com to see all our tutorials.
Facebook: / burtolearn
Twitter: / btltutorials
Instagram - / btltutorials
LinkedIn - / burntolearn.com
Reddit - / burn-to-learn
------------------------ --------------------------- ------------------------------
#microsoft #excel #exceltutorial #quicktutorial #removecells #exceltips