Many of us use Microsoft Excel to calculate budgets or perform basic additions and subtractions. We also know that it supports Macros which helps us automate our tasks. An Excel sheet is no stranger ...

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 ...

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.

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 ...

When you need to draw attention to a worksheet cell, Microsoft Excel allows you to type a note in a yellow comment box. If your worksheet appears cluttered with these little yellow boxes, update Excel ...