From the course: Microsoft Lists Essential Training
Join today to access over 25,500 courses taught by industry experts.
Import an Excel spreadsheet to make a list
From the course: Microsoft Lists Essential Training
Import an Excel spreadsheet to make a list
- [Instructor] Building a list manually is not the only way to make a list. This is a spreadsheet of my product inventory and if you have a spreadsheet in an Excel file as a starting point, it's going to make some things easier. But you do need to do some formatting before you can import this into lists. Now first, if you have the auto-save option in Microsoft Excel, I suggest you turn that off before doing this because we're going to make some formatting changes to this file that we do not want it to automatically save to the original file. Next, I need to select only the data that I want to import into Lists. So I can ignore this header material up at the top and then I can drag to select the data that I do want. Now I've got all that selected. With that selected, I'll go to the Home ribbon and choose Format as Table. You do have to choose a color style. It really doesn't matter for what we're doing, so just choose…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.