How to Add Comments to Excel 2013 Worksheet Cells
How to Use the Excel 2013 Quick Analysis Tool
How to Customize the Excel 2013 Quick Access Toolbar

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.

blog comments powered by Disqus
How to Move Pivot Charts in Excel 2013
How to Copy Custom Styles in Excel 2013
How to Share Excel 2013 Files
How to Find the Excel 2013 Formatting Toolbar Buttons Equivalents
Create Charts in Excel 2013 via the Quick Analysis Tool
Advertisement

Inside Dummies.com