Viewing: Auto fill

Disable autocomplete suggestion feature in Excel

Excel Auto Complete features automatically suggests a value based on previous entries. Similar to disabling auto fill feature, Excel provides option for disabling the autocomplete suggestion feature as well. So you turn off auto complete suggestion feature if you find it distracting.Listed below are the steps to disable autocomplete suggestion in Excel 2016, Excel 2013 […] Read More

How to disable auto fill feature in Excel

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill […] Read More

Fill rows and columns with Time values in Excel

This tutorial is about the different steps required automatically generate time based data as shown below in Excel. The difference between the rows and columns are 10, 17, 19 , 25 and 15 respectively. Instead of manually entering these values, we can automatically generate using the TIME function and excel auto fill feature. Step 1: […] Read More

How to turn on or off Auto fill feature in Excel 2007

Auto fill in excel is quite handy feature. Using this you can fill series of cells based on the entries of other excel cells. This feature can be turned on or off using the Excel Advanced Options. Click on the Office button –> Excel Options Under Excel Options select Advanced section By checking or un […] Read More

Get your free copies of the following tech guides by joining the Digital Answers mailing list.