Thank for your question. Unfortunately, Excel doesn't provide built-in shortcuts specifically for jumping directly to the first or last sheet in a workbook. The closest I can think of is Level 2, CTRL + click on the navigation arrows to scroll to the first or last sheet. Then select the sheet. But you might also use named ranges or create simple VBA macros if you want to use the keyboard instead of mouse to jump to the first and last sheets. *--- Method 1--- Named ranges* You can manually assign named ranges like bookmarks, then use them to navigate. 1. Select the Sheet: Go to the first sheet in your Excel workbook that you want to be able to quickly access. 2. Define a Named Range: Go to the Formulas tab, then click on 'Name Manager' and choose 'New'. Name this range something recognizable like "FirstSheet". 3. In the 'Refers to' field, make sure it points to a cell in the first sheet (typically $A$1). 4. Repeat for the Last Sheet: Do the same for the last sheet in your workbook, naming the range something like "LastSheet". To jump to the first sheet, press F5 to open the Go To dialog box. Then type "firstsheet"' in the reference field. Or click on "FirstSheet" in the list of locations. And hit enter. To jump to the last sheet, press F5 to open the Go To dialog box. Then type "lastsheet"' in the reference field. Or click on "LastSheet" in the list of locations. And hit enter. Or you can directly click on the "Name Box" to the left of the formula bar and click on "FirstSheet" or "LastSheet" to navigate there. *--- Method 2--- VBA* For a more automated solution, you can use VBA to create a shortcut. Here’s a basic example of VBA code to jump to the first or last sheet. Sub GoToFirstSheet() ActiveWorkbook.Sheets(1).Activate End Sub Sub GoToLastSheet() ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count).Activate End Sub To use these macros: 1. Open Excel and press Alt + F11 to open the VBA editor. 2. Insert a new module via Insert > Module. Or use a module in your personal macro workbook. 3. Paste the above code into the module. You can then assign these macros to a keyboard shortcut: 1. Go back to Excel and press Alt + F8 to open the "Macro" dialog box. 2. You'll see your macros listed there (GoToFirstSheet and GoToLastSheet). 3. Select the first macro. 4. Click on Options. 5. Assign a keyboard shortcut and click OK. 6. Repeat 3 - 5 for the second macro. Note: If you create macros in your personal macro workbook, they will be available whenever you have Excel open. So you don't have to create the same macro for every workbook. If you don't use your personal macro workbook, you'll have to add these macros to every workbook in which you want to jump to the first and last sheet. For further instructions on how to use your personal macro workbook check out: www.launchexcel.com/excel-personal-macro-workbook
Hi. My laptop currently doesnt have a PgUp and PgDwn button and also no Developer section. Is there other excel shortcuts I can use to move from other tabs faster? I was always using the Pgupdwn button, and it annoys me that my new work laptop doesnt have the keys. Thanks!
Hi Danielle, you can actually assign keyboard shortcuts to VBA macros in Excel, which might help you work around not having the PgUp and PgDn buttons. *This is how you can assign custom shortcuts with VBA:* 1. Press Alt + F11 to open the VBA editor. 2. Write or record the macro you want to assign to a shortcut (e.g., move to the next or previous tab). 3. Close the editor and press Alt + F8 to open the “Macro” dialog box. 4. Select the macro you want and click Options. 5. In the “Macro Options” window, assign a keyboard shortcut. For example: • Ctrl + Shift + N for moving to the Next Tab • Ctrl + Shift + P for moving to the Previous Tab 6. Click OK and you’re all set! Note: Most Ctrl + Shift combinations are available in Excel, while many Ctrl shortcuts are already assigned as default functions. It’s best to choose Ctrl + Shift with an alpha character. I believe F, L, O, P, and U are already taken, so it’s safer to avoid those. *To create macros for Page Up/Page Down:* 1. Press Alt + F11 to open the VBA editor. 2. In the Project Explorer, find and double-click the module where you want to store the macro (e.g., Module1). If you don’t have one, right-click anywhere in the VBAProject and insert a module. 3. Add this code for Page Up: Sub PageUp() ActiveWindow.SmallScroll Up:=1 End Sub And for Page Down: Sub PageDown() ActiveWindow.SmallScroll Down:=1 End Sub 4. Press Ctrl + S to save the workbook as a macro-enabled file. 5. Assign a keyboard shortcut for each macro using the steps mentioned above (e.g., Ctrl + Shift + U for Page Up and Ctrl + Shift + D for Page Down). *To store these macros in your Personal Macro Workbook (so they’re available in all workbooks):* 1. Press Alt + F11 to open the VBA editor. 2. In the Project Explorer, look for VBAProject (PERSONAL.XLSB). If it’s not there, you’ll need to create it by recording a dummy macro in the Personal Macro Workbook: • Go to Excel, press Alt + T + M + R to open the Record Macro dialog. • Under Store Macro In, select Personal Macro Workbook, then record and stop the macro. • Now you’ll see PERSONAL.XLSB in the VBA editor. 3. Add your macros to Module1 under PERSONAL.XLSB following the same steps as above. 4. This way, the macros and shortcuts will be available anytime you open Excel. For more details on working with the Personal Macro Workbook, you can check out this article: www.launchexcel.com/excel-personal-macro-workbook If you’re feeling more adventurous, you could check out a free program called AutoHotkey (AHK), which lets you create custom keyboard shortcuts for any Windows application. It’s not something I cover (yet), but it allows for extensive customization beyond Excel. Here’s the site if you want to explore it: www.autohotkey.com/ *Summary:* VBA Macros let you create custom shortcuts in Excel (e.g., Ctrl + Shift + N for Next Tab, Ctrl + Shift + P for Previous Tab), and AHK can help you create shortcuts for all Windows applications, going beyond Excel.
I can bring up the list of sheets with Ctrl+J, but when I select one, whether double clicking, or selecting and pressing Enter, the box just closes and Excel remains on the current sheet. When I run the macro it works perfectly though. Is there something you can suggest to fix this? Thanks!
Thanks for the comment! I'm puzzled because it appears to work for you when you run the macro directly, but not when you use the assigned shortcut. It sounds like the issue might be related to how Excel handles the macro when triggered by the Ctrl + J shortcut. Maybe how Excel processes the shortcut on your system. Though I've not seen this before in my own spreadsheets. Maybe this is Excel version-specific behavior. What version of Excel do you have?
@@launchexcel Good Point! 14.0.4760.1000 through Microsoft Office Professional Plus 2010. It's considerably likely due to being an older version, although it's fascinating that the popup tab only fails to act when brought up via the shortcut! I'll try again on a newer version when I get a chance. Thanks again!