Tuesday, February 4, 2014

List of all sheets in an Excel workbook

I love when tips work in Windows and on the Mac. Here's one that has been around for many versions, but still a favorite of mine. Right-click any of the worksheet navigational arrows (bottom-left) and a list of all sheets are listed. Simply click the one you want and you'll activate that worksheet. Much easier than clicking the Next or Previous arrow a bunch to find the sheet you need.