Table Tools Add-in for Excel for the Mac

Briefly! Table Tools is a user friendly way to copy Table data and have more options to filter on Date columns.
Please suggest things that you like to do in an easier way on your Mac so I can try to add it to the add-in.

You have the following options now :

  • Toggle AutoFilter On/Off
  • Clear Filters (AutoFilter and VBA AdvancedFilter)
  • Default Filter Options
  • Default Sort Options
  • Option to Insert Sort column in your Table
  • Option to insert a slicer in your Table
  • Option to copy the visible data to a new sheet
  • Option to copy the visible data to a new workbook
  • Option to split your unique data in worksheets same workbook
  • Option to split your unique data in worksheets new workbook
  • Option to split your unique data in workbooks new folder
  • Many Date filter options when you open the Userform
  • Option te delete your visible data
  • Option to delete Table columns


Screenshot 2024-08-17 at 14.56.21

Screenshot 2024-08-17 at 14.54.46
Filter on Month-Year, Date to Date, Days, Iso week numbers, Weekdays, Nth weekday, Quarter


Download the Add-In for Mac Excel

Note: Table Tools is available as freeware. But you can use the Contact button in the menu if you want to support the development of this add-in.

Table Tools for Mac Excel (version 1, 17-Aug-2024)

How to install the Add

  • Open Excel
  • Use Tools>Excel Add-ins... in the menu to open the Add-ins dialog
  • Use the Browse button to select the add-in and choose Open
  • Press OK
  • Done

Note: If you store the Add-in in the Add-ins folder (the best place) it will be automatic in your Add-ins dialog list, read the information on this page if you want to know how to do this : Install an Excel Add-In in Excel for Mac

Note: On the Ribbon when your active cell is in a Table you see a new tab named 'RDB Table Tools'.

11/11/2024
Web design by Will Woodgate