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

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet" button ...

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

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

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