How to Quickly Delete All Blank Cells in Excel
Have you ever ended up with an Excel spreadsheet that contains a bunch of blank cells? Maybe you assembled the sheet by pasting in text from other sheets, or deleted a lot of rows. You could go through the list and individually delete every blank row, but this is a huge waste of time. There’s a better way. First, open the spreadsheet you need to edit and select every cell. You can do this quickly by clicking the little triangle in between the A column and the 1 row. Next, press F5 and click the Special button to open the…
Read the full article: How to Quickly Delete All Blank Cells in Excel