Excel 2016 from Scratch
An Excel tutorial by Peter Kalmstrom
this demo in the Excel 2016 from Scratch series, Peter Kalmstrom shows two
different ways of reaching the Text Import Wizard to add data from a text
file into an Excel sheet.
One way is to select all text by using the ‘Select All’ option or using keyboard
Ctrl A and then copy it and use a paste option in Excel that gives you the
The other way is to reach the wizard by using the “From Text” button under
the Data tab in the Excel ribbon.
This is what Peter showns in the demo below:
Peter uses Excel 2016 for his demo, but the Excel basics are the same for
earlier versions of Excel.
- How to choose the file type to describe data in the best way.
- How to see text delimitors in Word.
- How to keep the headers data as headers when importing.
- How to change the format of the data in a column.