1. Click on the Data menu.
2. Navigate to the Data Cleaning tool, and from the drop down choose Fill Missing Values
3. In the data cleaning tab, choose a column for the tool to pick up the empty cells from.
4. Once the tool is done picking up empty cells, please select one of the three options provided to fill the cells with a value that you want.
5. You can either choose to fill all the missing values with a specific value, or fill it with the content in the previous cell or you can choose to fill the cells with the most occurred value in the column.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.
Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.
Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.
Make the most of Zoho CRM with these useful tips.