Share via

Autocomplete for Excel table column headers

Anonymous
2013-03-30T11:08:44+00:00

Hi

How do I get autocomplete to also index Excel table column headers?

E.g. if Table1 has 3 columns: Country, Region, City

When typing any formula referencing that table e.g. "=Match(B3,Table1[" autocomplete should suggest the corresponding column header names for Table1 i.e. "Country, Region, City"

At least it does in the Windows version - is this a settings issue in the Mac version or is the feature not available (yet)??

FYI I have activated all the autocomplete options and using table references in formulas as well.

Thanks for your help

Kai

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-03-30T14:36:28+00:00

    I not sure exactly what you mean.

    I'll give it a Try.

    If say you have the three heading as described.

    You can index with up to three criteria at a time

    Open > Data > Sort. when you open the sort window there are three columns you can sort by.

    in your case there would be

    Country First

    Region Second

    Third City.

    If sorted wrong reverse the order.

    Was this answer helpful?

    0 comments