How to create a drop-down list in Excel to manage data and prevent mistakes

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

This obscure Microsoft Excel tool imports PDF data without mangling it

In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table in it. Now select Import. Choose the table from the list that appears and ...

How to edit a drop-down list in Excel, depending on how you created it

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.