I have an excel workbook with about 30 worksheets. I know I can do Ctrl+PageUp and Ctrl+PageDown to move between the worksheets.
Is there a way to do this using the center button on my mouse as well?
I don't know of any shortcut in Excel to do it. If you've got AutoHotkey, you could use the following script to do it (Ctrl+Shift+Mouse Scroll):
Even better, you could use this version of the script to change worksheets when you're scrolling and holding down the right mouse button (so you only have to use one hand!):
This approach prevents you from right-dragging in Excel, but I haven't seen any special result from doing that.