Auto-fill in MS Excel, How to enable Auto-fill in ms excel

Auto-fill is a function in excel which provides an easy way to fill-in empty cells with either a repeat value, a series of value or just a cell format eliminating manual typing.

Steps :

1.  Go to “FILE” in Menu Bar (Upper-Left Corner)

2. Select “Options”

3. Select “Advanced”

4. Tick “Enable fill handle and cell drag and drop”

and click “ok” button. Now, Auto-fill option is enabled in your excel sheet.



About Taxshastra

Tax Shastra is a knowledge-sharing platform for Individuals, Businesses & Professionals, solely managed and guided by Ratan Sarraf, where you can learn your taxes and finance easily.

View all posts by Taxshastra →

Leave a Reply

Your email address will not be published.