Title:
Fix Blank Cells in Excel
Video:
Description:www.contextures.com In most Excel files, it's important to know which cells are blank, and which cells contain data. In this example, data has been copied from an Access database, and cells that look blank are being counted, as if they contain data. To fix the problem, so the cells are recognized as blank, use the Replace command, as shown in this short Excel video tutorial. Record a macro while you fix the cells, and run that macro later, if you encounter a similar problem.
Published:
13/Apr/2011
Fix Blank Cells in Excel
Video:
Description:www.contextures.com In most Excel files, it's important to know which cells are blank, and which cells contain data. In this example, data has been copied from an Access database, and cells that look blank are being counted, as if they contain data. To fix the problem, so the cells are recognized as blank, use the Replace command, as shown in this short Excel video tutorial. Record a macro while you fix the cells, and run that macro later, if you encounter a similar problem.
Published:
13/Apr/2011
No comments:
Post a Comment