![]() ![]() If you are looking for a single shortcut that will toggle between the two worksheets, then you can use a macro such as this: These would be easy enough to create using the macro recorder, and you could assign a shortcut key to each of the macros. ![]() ![]() One macro would jump to Sheet1 and the other to Sheet4. If desired, you could define two macros that would do the jumping. What if you want to use a shortcut to move between two specific, non-neighboring worksheets, such as Sheet1 and Sheet4? In this case, it is best to use a macro to do the jumping around. You can easily move between worksheets in a workbook by using Ctrl+Pg Up and Ctrl+Pg Down. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |