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, ...
Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...
Our top ten Excel hints and tips to make your life easier, in no particular order. There's a calculator in Excel 2010 but by default this feature is hidden, to get the calculator on your Excel screen ...
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 ...