Share via

How to use Auto-fill series in excel web app?

Question

Thursday, October 1, 2015 11:06 PM

Hi,

I am using excel WebApp on Sharepoint 2013.

I have a table and one of the columns has numbers.

How do I use the auto-fill series option to populate numbers 1,2,3... automatically?

The click and drag option isn't working and couldn't find a command in the menu. :)

Thanks.

http://answers.microsoft.com/en-us/office/forum/officeonline-excel_online/how-to-use-auto-fill-series-in-excel-web-app/87ea9e2b-a83e-4161-9ba3-038950ceeaf3?tm=1443683435960

All replies (2)

Wednesday, October 7, 2015 7:16 AM âś…Answered

Hi Avinash.Rao,

Based on your description, did you mean you want to use Autofill series option in Excel web app?

I tested it in my own environment and I cannot find Autofill options in Ribbon of Excel. I suppose this option is not supported in Excel web app.

I suggest you refer to the article about the differences between using a workbook in the browser and in Excel:
https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6#__toc347836461

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Support

Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

Monday, November 2, 2015 4:54 AM

Hi Emi,

Yes, your understanding is right. I am trying to use auto-fill option in excel web app and as you have rightly spotted, there isn't a option in the ribbon. :)