The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole Number for Allow:, greater than or equal to for Data:, and -700 for Minimum:.

By smartly using cell borders, shading, data validation, and other formatting techniques, you can improve the visual appeal of your Excel spreadsheet.

Explore Excel templates library Being the oldest spreadsheet software, there is no shortage of templates for Excel. Whenever I want to start a new workbook, I first head to the official templates ...