Another window will pop up called Combine Files, with a sample of what you'll get; click OK. You'll now get an Import Data dialog box asking if you want this to be in a table, a PivotTable Report, or ...

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know. Our team tests, rates, and reviews more than 1,500 products each year to help ...