Forum Discussion

NelsonYan's avatar
NelsonYan
New Member
2 years ago

How to load query to specific sheet in excel for Mac

Hi team,   I know that we can choose to load query to specific sheet in excel for windows, but I can't find this function in excel for mac!   not sure if i miss something, any input are welcome...
Need Help
PwerQueryKees's avatar
PwerQueryKees
Icon for Super User rankSuper User
2 years ago

And just load to new tab and then do a rename?

  • PwerQueryKees's avatar
    PwerQueryKees
    Icon for Super User rankSuper User
    2 years ago

    Or load to a new tab and then MOVE the table to the location you want. In windows this also moves the data needed for refresh.