Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Q. The name of my firm is Jones & Jones. But when I try to put it in an Excel header, it comes out Jones Jones—no ampersand. How can I add the ampersand? A. I know it sounds like a silly omission on ...

<br><br>If that's not clear, here's a screenshot of what I mean. I happen to be viewing that in Excel 2007 but they're using E2k3. This grouping/"outline" is an Excel thing.<br><br>This was generated ...

It's often useful to put a header or footer on the top or bottom of Excel spreadsheets. The header or footer might contain information about who prepared the spreadsheet, a disclaimer about the ...