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.
If we want to put the filter as per the Month and year, we need to follow below given steps:-. 1  Copy the range A1:A18 and paste it right side to Column A. 2  Select the date range A1:A18. 3  Copy the date column by pressing the key Ctrl+C on your keyboard.4  Select the cell A1 and press the key Ctrl++. Select the Month Column and press the Ctrl+1. 2  Format cells dialog box will appear. 3  Go to number tab and select custom. 4  In the type box, enter the format mmmm (to show the full name of month) and click on OK.