Topics Map > IT Services > Training
Topics Map > IT Services > Software Support
Microsoft Excel 2016 - Flash Fill
This guide will show you how to use Flash Fill to make slight changes to data in a quick manner.
Situations may arise where only slight changes to data may be needed, such as changing from a First then Last Name arrangement to a Last then First Name order. If dealing with thousands of names it can be time consuming, whereas Flash Fill solves this in seconds.
- Insert a new column by the one which will be deleted. Do this be right-clicking on the column heading of the one that will be deleted.
- Type in the first correct version of the data.
- Select the Data Tab.
- Select Flash Fill from Data Tools.
- The information will Flash Fill in the correct format
If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or firstname.lastname@example.org