how to sort multiple column headers in excel 2016

#HOW TO SORT MULTIPLE COLUMN HEADERS IN EXCEL 2016 CODE#

Note: all phone numbers were randomly generated with the formula below. If you can't do that, you will have to manually select all the data prior to sorting. There is no way around this problem unless you add a dummy column as the first column. This also won't work if A1 is merged horizontally with B1, etc. While this will look fine, it's isn't semantically correct and could lead to problems in extreme edge cases if one assumes they are separate lines. This obviously won't work if your first column requires both lines for headers, unless you're willing to live with one merged cell with two separate lines of text. and Excel will now properly ignore both header rows when auto-selecting the sort area: If you are able to merge cells A1 and A2 using 'Merge & Center', then Excel will properly identify both rows as header rows.ĭoing an auto-sort on this will automatically (and improperly) select the second row: Yes there is, if you can make one small change to the first header column. Is there a way to make Excel treat the first two rows as headers?

Merge unmerged cells to restore original state Range('A1:A2').MergeCells = True Remove or hide FILTER Combobox for some columns Selection.AutoFilter Field:=GetColumnIndex('C'), VisibleDropDown:=Falseĭ. Add AutoFilter on all cells of row 2 Range('A2:Z' & nLast).AutoFilterĪutoFilter is generated for cells in all rows except row 1.Ĭ.

Unmerge vertically merged header cells to allow adding filter on rowī. '* return column's index from column lettersįunction GetColumnIndex(sColLetter As String) As Integerĭim iMax As Integer: iMax = Len(sColLetter)Ī. 'Merge unmerged cells to restore previous state Selection.AutoFilter Field:=GetColumnIndex('H'), VisibleDropDown:=False Selection.AutoFilter Field:=GetColumnIndex('G'), VisibleDropDown:=False Selection.AutoFilter Field:=GetColumnIndex('C'), VisibleDropDown:=False 'Remove (or Hide) filter combobox for some columns 'Unmerge merged cells to allow adding filter NLast = Range('A' & Rows.Count).End(xlUp).Row '* PUBLIC method to call to define CUSTOM AutoFilter I want to add some filters on explicit columns but not on row 1 only on row 2 as you can see in following screen's capture.

#HOW TO SORT MULTIPLE COLUMN HEADERS IN EXCEL 2016 CODE#

I know that I'm on SuperUser and not on StackOverflow, but the solution to this problem can be found in using VBA code on Excel 2016.

How to sort multiple column headers in excel 2016