To make your Excel worksheet more efficient, use the drop-down list in the cell. It is easy to select from the list instead of typing in each cell particularly. It also saves time. In this article, I have tried to show you how you can easily make a cell into a drop-down list. So Let us proceed with steps of  How to Create a Drop-Down List in MS Excel 2016? Steps to Create a Drop-Down List in MS … [Read more...]

It is a very tedious job to fill the data in a spreadsheet manually. Excel provides a feature of Autofill that fills cells with the extended series that follow the pattern of the initially selected cell. Autofill feature fastens your work and saves your time. Your initial selection can be a number series , time, weekdays, months, years, date or even it can be any data that forms some pattern. So … [Read more...]

It becomes laborious when we have repeated data to be fed in the Excel spreadsheet. Flash Fill reduces your work of entering the data manually in each cell. It also saves your time.  Flash Fill automatically fills the values in the cell. For that, you just have to type one or two examples that help in recognizing the pattern of output you require. After recognizing the pattern of the examples, … [Read more...]