Startup hacks and engineering miracles from your exhausted friends at Faraday

Obvious once you see it: 1-click Excel autofilter + split

Seamus Abshere on

This is part of our series on things that are obvious once you see them. Duh!

Excel's autofilter and freeze panes are a big reason we keep buying Microsoft Office. Add both with 1 click (hint: the smiley face)

the macro in action

Sub faraday_io_autofilter_split()  
  Rows("1:1").Select
  Selection.AutoFilter
  Rows("2:2").Select
  ActiveWindow.FreezePanes = True
  Cells(1, 1).Select
End Sub  
  1. Tools -> Macro -> Visual Basic Editor -> double click Module1 of Personal Macro Workbook
  2. Paste the code above (starts with Sub faraday_io_autofilter_split())
  3. File -> Save Personal Macro Workbook
  4. Excel -> Close and Return to Microsoft Excel
  5. Right-click toolbar -> Customize Toolbars and Menus -> Commands -> Macros -> drag Custom Button to the menubar (it's a ☺)
  6. Right-click new button -> Assign Macro... -> select 'Personal Macro Workbook'!faraday_io_autofilter_split

a screencast of the instructions