How to Disable Date Auto Fill in Excel. Microsoft Excel's Auto Fill features help you quickly enter the same value in more than one cell or fill a series of cells with related or sequential values.

If you select the "Fill Series" radio button, Excel fills the cells with dates that increment by one day, starting from the date you typed. ... How to Disable Date Auto Fill in Excel.

You can automatically fill increment cells in Excel using the Autofill function as follows: ... Using the dot at the button-right corner of the selection, pull the list down to cell B10.

If you want their first name and last name to appear in Column B, you could use the CONCATENATE function to extract the data from Column A. However, it is probably faster to use Excel’s Flash Fill ...

A. Flash Fill is one of my favorite features in Excel because it can do a lot of routine tasks. If Excel can sense a pattern in what you are doing, it will try to complete the task for you. Flash Fill ...

In Excel 2007, choose Go To Special from the Find and Select dropdown list in the Editing group on the Home tab. Select Blanks. When you click OK, Excel will select all the blank cells in A2:A11.

How to fix inconsistent data in Excel. Flash Fill is a great way to find inconsistent data. You can fix these problems by correcting the original values as follows: ...

Microsoft went a step further in Excel 2013 and created Flash Fill. This new feature recognizes patterns in your data and will finish tedious tasks for you. Produced by Sara Silverstein ...