Instantly jump between sheets and datasets using secret menus, name boxes, custom dashboards, and powerful double-vision hacks.

I've spent years watching people move data in Microsoft Excel by cutting, inserting blank rows, pasting, and then deleting the old empty space. Most people don't realize there's a right-click-drag ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...