I have created twelve worksheets and a general ledger to do my monthly banking in EXCEL. How can I jump back and forth from the General Ledger worksheet to any given month without scrolling through all the worksheets at the bottom of the workbook?

  • From one of the monthly worksheets type GL for General ledger.
  • Highlight and right click on GL then choose ‘Hyperlink’ from the drop down menu.
  • Click on ‘Bookmark’ and then choose the ‘General Ledger’ from the drop-down list that appears.
  • Click OK and the hyperlink to your General Ledger will be active from your worksheet.

Repeat these steps throughout your workbook.

Posted in: General, Hyperlink, Microsoft Excel