To create a ledger in Excel, you can use the following steps: Open the Excel file that you want to ledger. On the ribbon, click on the New Tab button. Under the Category tab, select Accounting and Financial Reports. On the ribbon, click on the Add Tab button. In the Add Tab dialog, enter a name for your new ledger sheet and click OK. 6.