QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to use Autofill in MS Excel 2016?

By Neha T 1 Comment

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 let us learn How to use Autofill in Ms Excel 2016?

Steps to use Autofill in MS Excel 2016:

Step 1: Before proceeding further, you must be aware of enabling or disabling the feature of autofill in MS Excel 2016. For that first, you have to open a document in MS Excel 2016. Go to the File and click on the Options tab present on the left side of the screen.

Autofill-step-1Step 2: A pop-up dialog box Excel Options will get opened on your screen. You will find the Advanced Tab on the left column of the box click on Advanced tab.

Autofill-step-2Step 3: In Advanced tab under Editing Options search for the checkbox “Enable fill handle and cell drag and drop“. Click on that check box and then click OK. It will enable the autofill feature in MS Excel 2016.

Autofill-step-3Step 4: Come back to the Home tab. Now, we will learn how to use the autofill feature of Excel. For demonstration purpose, I wrote a date 2/16/2016 in the MM-DD-YYYY pattern in a cell of a spreadsheet. Using mouse pointer select the cell containing the date. Now observe carefully you will find a small box at the bottom right corner of the selected cell. Click and drag that small box till you want the number of cells to get autofill and leave the cursor when the number of cells you want to autofill is reached.

Autofill-step-4Step 5: The cells you selected are now autofilled. Now if you want some changes in the entries of the cells. Click on Auto Fill Options button that appears on the right corner of the selected cells.

Autofill-step-5Step 6: You will find several options like Copy Cells, Fill Series, and Fill Formating Only, Fill Without Formatting, Fill Days, Fill Weekdays, Fill Months, Fill Years and Flash Fill.

Autofill-step-6Copy Cells option copies all the selected cells with the same value.

Fill Series option fills all the selected cells with the series in ascending order.
Fill Formatting Only option fills the selected with some format.
Fill Without Formatting option fills without any format.
Fill Days will change the days of the date and arrange it ascending order/
Fill Weekday option will omit Saturday’s Sundays and prints the rest on the selected cells in ascending order.
Fill Months option will change the months of the date and arrange it in ascending order.
Fill Years Option will change the year in all the dates and arrange them in ascending order.

For demonstration purpose, I selected Fill Months option, and you can see in the image below that it changed only the month values and arranged them in ascending order.

Hope you find the article useful. Keep reading.

You Might Also Like:

how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro in MS Excel 2016?

Comments

  1. Mary Lynn Mason says

    April 24, 2017 at 7:08 pm

    Thank you. I appreciate your help.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Print an Email in Gmail
  • How to Disable Right Click on Wordpress using Plugin
  • How to Calculate Age in Excel?
  • How to Open Registry Editor in Windows 7
  • How to Create a Password Protected PDF file

Copyright © 2023 · QueHow · Contact Us