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

Learn practical HYPERLINK tips, from dynamic sheet links and navigation buttons to XLOOKUP row jumps and tidy anchor text for client reports.

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

Please note: This item is from our archives and was published in 2002. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I have a spreadsheet ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...