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. When I’m working in ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...

We have created sample data containing sales of 6 different companies in four consecutive months (from January to April). The Total Sales sheet represents the total number of sales in all four months ...

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users click a ...

Six tips for using Excel sheet groups in easy (but unusual) ways Your email has been sent We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site, ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

If you’ve ever worked inside an Excel workbook with dozens of tabs and thousands of rows, you know how easy it is to lose your bearings. One minute you’re checking a formula in column AR, and the next ...

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.