In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news ...

To begin, you need to enable the Developer tab in Excel. This tab provides access to the tools required for form creation, but it is not enabled by default. To enable ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it. To add ...

Adding pictures to a Microsoft Excel worksheet can improve visualization, understanding, and overall presentation. However, floating images are notorious for causing layout issues when rows, columns, ...