195
Hello Everyone,
Good day!
I have an excel file in SharePoint and I would like to seek your help regarding:
- Is there anyway I can create table from excel data which is in rows. Which means the excel data value does was not in table format.
Is there any way to do this? Thanks in advance for your help.
If you are asking is there a way to make the table adjust based on how many rows are in the spreadsheet, then the answer is no there isn't. What I've always had to do was create the table larger than I expect it to ever be. and then filter out empty rows when I use the table later.
Hi @Pstork1 ,
I have tried this one. The Range I set did set is $A1:$G7 but what if the $G7 is dynamic? how to do that?
Share
Report
All responses (
Answers (
