Counting duplicate values is a subject that begs definition. What constitutes a duplicate? Within Excel, you can have duplicate values within the same column or you can have duplicate records — a row ...

Whether you want to restrict data inputs, ensure consistency, or avoid errors, data validation in Microsoft Excel is the tool for you. It can also serve as a vital safety net if you plan to share your ...

Use index sheets to quickly navigate in an Excel workbook Your email has been sent Navigating through dozens of sheet name tabs in Microsoft Excel to find the one you need can be quite time consuming.

Business managers and owners group worksheets in Excel so that changes made to one worksheet apply automatically to all connected worksheets. When you group worksheets together, the tabs at the bottom ...

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

Q Every now and then the tabs at the bottom of an Excel workbook disappear. I don’t know what I did to cause that to happen, and I can’t figure out how to get the tabs to reappear. Please help. A Any ...