Fill data automatically in worksheet cells
Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010
Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Note: This article explains how to automatically fill values into other cells. It does not explain how to enter data manually or simultaneously across multiple worksheets.
Find more videos on Mike Girvin's YouTube channel, excelisfun.
Select one or more cells you want to use as a basis for filling additional cells.
For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. For the series 2, 4, 6, 8..., type 2 and 4.
For the series 2, 2, 2, 2..., type 2 in first cell only.
Drag the fill handle Fill handle .
If needed, click Auto Fill Options Button image and choose the option you want.
38 freelancers are bidding on average ₹958/hour for this job
urgent requirement for money. I'm a fresher and looking for a long term job in [login to view URL] that i need experience so plz give an oppertunity to prove myself.. regards abdul rahman...
dear sir, spread sheets is one of my specialities. I have done a lot of spreadsheet work online so I am pretty confident that I can complete this task. please message me of you intend to hire me