Menu
Or simply follow these steps to switch between sheets in the workbook: In order to move one sheet to the right, hold down Ctrl, then press the PgDn key. To keep moving to the right, press the PgDn key again. In order to move back or one sheet to the left, hold down Ctrl, then press the PgUp key.
1. Use the keyboard shortcuts CTRL + PAGE UP and CTRL + PAGE DOWN. These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet.
I'm trying to create a button to take me to my Index sheet. I know how to do it using a macro or a hyperlink, but my users aren't 'smart' users and will be calling me all day if I use macros.
Does anyone know how I could solve this, besides using a hyperlink? I was thinking of a button with a hyperlink, but haven't found a way to do it!
Thank you! :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With