How to create table in different worksheets?

[xlzs]

I have a list [food, drink, transport], and create sheets from the list.

Now I need create table in every sheets.

(create table food in sheet food)

but there is no field to select worksheet in action [create table]

How to create the tables?

ps:

The first time I submitted it, I wasn't logged in, so I was redirected to the login screen, and at the end of my login, I noticed that my post had disappeared without being sent or saved....

[SunshineK · Accepted solution]

Hi xlzs, 

I am not 100% sure what you require - however guessing you want to create a table in excel worksheet? 

In excel - select insert, and select table. 

then for instance if you want to create a record in excel from SharePoint List you can do so 🙂

Cheers, 
Summer

[xlzs]

thank you for your help

I have solved this problem.

In the [create table] option, just fill [table range] with a value in sheetName!A1 format.

such as food!A1