MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Less CSV Nagging and Better AutoComplete


October 14, 2019 - by Bill Jelen

Excel Less CSV Nagging and Better AutoComplete. Photo Credit: David Clode at Unsplash.com

Some people have to create CSV files hundreds of times per day. Excel used to hassle you when you saved a CSV file: “Some features in your workbook might be lost if you save as CSV.” People who have to export as CSV understand this and wanted Excel to stop hassling them. Starting in 2017, people with Office 365 are no longer hassled for choosing to save as CSV.


Another small change in Office 365: If you type an equals sign and start to type a function name, the tooltip offers partial matching. Type LOOK, and you will see all three functions that contain the text LOOK.

Type =look in a cell. AutoComplete offers any function that matches, including LOOKUP, HLOOKUP, VLOOKUP.

Title Photo: David Clode at Unsplash.com


Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.