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.

  1. 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.
  2. Type in the first correct version of the data.
  3. Select the Data Tab.
  4. Select Flash Fill from Data Tools.
  5. 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

Keywords:"Data Management", "Automatic Fill"   Doc ID:65972
Owner:Richard L.Group:UW Oshkosh
Created:2016-08-10 15:35 CDTUpdated:2016-08-10 15:35 CDT
Sites:UW Oshkosh
Feedback:  0   0