How To: Excel | Delete Blank Cells in 5 Quick & Easy Steps
Hi All! Thank you for watching my very first tutorial! I hope you enjoyed it. Please leave me any comments or feedback.
See the steps below for How To: Delete Blank Cells in Excel:
Press F5 - "Special" - Select "Blank" - Ok
Now your blank cells will be highlighted.
Go to Cells on the Ribbon and select "Delete" - "Delete Cells"
Most common Use Cases:
1. Let's say you've copied over large amounts of data that has a lot of blank cells and you don't want to waste your time delete each row/column individually.
2. You publish a PDF file to Excel and spacing happens.
3. You created a spreadsheet that includes a good amount spacing/formatting and you've changed your mind, what a pain to go back and delete each line so this helps with quick reformatting.
Follow me @TechCafe_ and subscribe!!
Intro/Outro Music: 10K - Vapor
SoundCloud Link: soundcloud.com/10ksound/vapor-2
I appreciate you!
Watch video How To: Excel | Delete Blank Cells in 5 Quick & Easy Steps online without registration, duration hours minute second in high quality. This video was added by user tech is the new pink 20 May 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 327 once and liked it 18 people.