Skip to main content
Question

How do I add new role to top of Microsoft Excel table?

I want to add a row from Airtable to an Excel spreadsheet to the top of the table, rather than the bottom (as it is automatically configured to do). Is this possible?

Hi @jamesharnett 

Good question.

Help: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier

 

 

Aw shucks. Is there some way to trigger an automatic sort in Excel so that, let’s say I’m inputting a date (MM/DD/YYY) in a table, the table sorts all of the dates in a given column from earliest to latest, inclusive of the row that was just added?

@jamesharnett 

Try using 2 tabs.

One tab for raw data added by the Zap.

One tab with formulas to pull data from the raw tab and sort.

https://support.microsoft.com/en-au/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c

Reply


Terms & Conditions