How to Select Cells in Excel 2013
How to Find the Excel 2013 Formatting Toolbar Buttons Equivalents
How to Set Regional Dates in Excel 2013

Top 10 New Features in Excel 2013

Step 10 of 10
Next Slideshow
Next Slideshow

Flash Fill

This nifty new feature is literally a mind reader when it comes to dealing with multipart cell entries in a single column of the worksheet that contains discrete elements you could better use if they were entered all by themselves in separate columns of the sheet.

To separate discrete elements from longer entries in the column, all you have to do is manually enter the first element in the longer entry you want extracted into a cell in the same row in an empty column to the right terminated by pressing the down arrow.

Then, the moment you type the first letter of the corresponding element in the second long entry in the empty cell in the row below, Excel 2013’s AutoCorrect feature not only suggests the rest of that second entry to make, but also all the rest of the corresponding entries for the entire column.

To complete the AutoCorrect-suggested entry and fill out the entire column, you simply click the Enter button on the Formula bar or press the Enter key.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Copy Custom Styles in Excel 2013
How to Add WordArt in Excel 2013
How to Describe a Custom Excel 2013 Function
How to Move Pivot Charts in Excel 2013
How to Use the Excel 2013 Quick Analysis Tool