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:.

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 ...

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