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

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

You can edit a drop-down list in Excel using a few different methods. It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits. If ...

Although getting into the habit of naming tables in Excel can take some time if it's not something you usually do, here's why today's the day to start. First, if you're working with a large workbook ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions. Image: ...

Ever found yourself wondering if there’s a more efficient way to handle your data in Excel? If you’ve been using Pivot Tables but feel like you’re only scratching the surface, you’re in for a treat.

Have you ever felt limited by the rigidity of Excel PivotTables when creating interactive reports? Many users assume that Excel slicers, the sleek, clickable filters that make data exploration a ...