Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.