Share via

Can't find 'From table/range' option in Data tab.

Anonymous
2021-06-14T18:35:43+00:00

Excel on Mac, version 16.49.

Can't find ''From table/range'' option in Data tab.

I was looking for this 'From Table/Range' option in Data tab

However, my excel doesn’t have this option in the Data tab

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
Answer accepted by question author
  1. Anonymous
    2021-06-15T03:11:21+00:00

    Hi GinaD,

    Thank you for posting your question in this community.

    The option From Table/Range from your first screenshot is a part of Power Query feature in Excel for Windows platform.

    Although Excel for Mac app support some Power Query features, such as import txt or csv files, the PowerPoint query feature isn’t powerful as Excel for Windows platform does.

    For your information:

    Use Power Query in Excel for Mac

    In this scenario, I kindly suggest you can raise the idea in Excel for UserVoiceandsubmit Excel for Mac in-app feedback, which it can let the related team be aware of this scenario and further improve on the Power Query feature for Excel for Mac app. Sorry for the inconvenience caused.

    Best regards,

    Dihao

    10 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest