In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, automatically updating the corresponding data. This technique consolidates ...

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