Fragmenting your data across many Excel tabs is a common habit that silently kills file performance, introduces hidden errors ...

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

When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the name isn't always so obvious. Although the Visual ...

Splitting the contents of a cell into more than one column manually in Microsoft Excel would take too much time and likely result in errors. Fortunately, the program offers many ways—from built-in ...

Do you know that you can format text in multiple ways in a single cell in Microsoft Excel? In this guide, we show how you can add multiple formatting to your text in a single cell in Excel. Formatting ...

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