Running a small business is challenging in any economic climate. One way to increase efficiency, minimize errors and maximize profits is to use the data available as effectively as possible.

When inserting an ActiveX control to generate a list box in an Excel spreadsheet, you might sometimes notice that the list box does not contain a horizontal scrollbar. If this is the case, your list ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

How to combine Excel’s VLOOKUP() function with a combo box for enhanced searching Your email has been sent When entering data in Microsoft Excel, an autocomplete feature attempts to help. You probably ...

Q. I currently keep a static to-do list, and I would like to update it to be more dynamic. Do you have any advice? A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...