There are quite a few ways to achieve this, but the easiest by far is like this.
Open a new Workbook and on Sheet1 enter these heading into cells A1: D1 Expensive Cars, Cities, Names, Countries Now place some relevant entries below these headings, down to say row 5.
Dennis is quality manager at the FDA Laboratory in San Juan, Puerto Rico, He is the author of FDA's SOPs and Laboratory Information Bulletins about using Excel spreadsheets.
If you missed Part 1 you can read it here: Working with Data in Excel Part 1: 10 Excel Data Entry Tips Everyone Should Know In Part 2 you’ll find handy tips and techniques for speeding up data entry, as well as making sure that data is entered accurately.He answers most frequently asked questions Gap analyses and checklists are Useful in preparation for audits and FDA inspections."The Lookup & Pivot Table techniques I learned in Advanced Excel 2016 training have helped me in my work immensely.All compliance features work automatically; no changes are required to your existing spreadsheets.In Part 2 of this series we’ll look at Excel lists, drop downs and data validation.