VBA for filtering columns. I'm using Excel 2011 on a Mac. Let's see if I get the autofilter working. How to lock a column until it's last row with data. To sort a column, click a single cell in the column you want to sort. For example, to sort the A column, click any cell in that column, then click the 'Data' tab on the toolbar, locate the Sort & Filter section and click the 'Sort A to Z' or 'Sort Z to A' button.
![For For](http://www.gogofinder.com.tw/books/anita/35/s/1318479754QSx5PsmY.jpg)
![How To Sort Column In Excel 2011 For Mac By Year When There Are Months Included In The Data How To Sort Column In Excel 2011 For Mac By Year When There Are Months Included In The Data](https://www.techonthenet.com/excel/filters/images/sort2_2011_004.gif)
• Convert your data to proper date format first. To do so perfom following steps:- a.Simply select your dates in column A > Data tab of the ribbon > Text to Columns to open the Wizard: Step 1 of the Wizard: Choose ‘Delimited’ Step 2 of the Wizard: uncheck all Delimiters (just to be safe) Step 3 of the Wizard: Choose 'Date' from the 'Column Data Format' options and choose your date format from the drop down list, and click the Finish button: Tip: Note how the ‘Date’ drop down list above has many different combinations of D M Y, you simply choose what order your dates are formatted in from the list. Now sort your data and it will work as you want it to.