Here is a quick trick for selecting empty cells. If you have a large table with dozens of blank blocks scattered throughout the table, it will take you ages to do it manually. How to select empty cells in Excel worksheetsīefore filling in blanks in Excel, you need to select them. Fill empty cells with 0 or another specific value.
I will show you one quick and one VERY quick way to fill empty cells with different values in Excel 20. There are different methods to solve this problem.
In this case you need to fill in all the blanks. On the other hand, Excel empty cells can get you into trouble when you sort, filter the data or create a pivot table. On the one hand, your table looks neater and more readable when you don't clutter it up with repeating values. To fill or not to fill? This question often touches blank cells in Excel tables. In this article you'll learn a trick to select all empty cells in an Excel spreadsheet at once and fill in blanks with value above / below, with zero or any other value.
