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!
Смотрите видео How To: Excel | Delete Blank Cells in 5 Quick & Easy Steps онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь tech is the new pink 20 Май 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 327 раз и оно понравилось 18 людям.