Tomatoes originated from the Andes, in what is now called Peru, Bolivia, Chile and Ecuador - where they grew wild. They were first cultivated by the Aztecs and Incas as early as 700 AD.
1. Click any single cell inside a data set. 2. On the Data tab, click Filter. Arrows in the column headers appear. 3. Click the arrow next to Date. 4. Click on Select All to clear all the check boxes, click the + sign next to 2012, and click the check box next to January. 5. Click OK. Result.
A. There are several ways to do that, but by far the easiest is to use the IF and TODAY functions. Hereâs how. Assume the due date is in cell A3 and you want an alert five days in advance. The formula checks A3, and if the current date is at least five days away, it will display the alert. To make it more prominent, consider coloring the alert cell red (see screenshot below). To add a little pizzazz to the worksheet, you can program Excel to post the current date above the two columns.