Go back to the tab where you created the check register. Use the expense and income categories in the check register. Repeat the same procedure to widen column E, “DESCRIPTION.”.When you see the resizing cursor, left-click and drag your mouse to the right to make the column as wide as you want it to be. The resizing cursor looks like a cross with arrows. The cursor will change from the arrow to the resizing cursor.
Hover the cursor over the border between columns D and E. Widen column D, “PAYEE.” Select column D by clicking on the header.From the drop down menu, click on “Column Width.” Enter the number 2 and click on “OK.” Now column A is very narrow. In the upper right hand corner of the toolbar in the “HOME” ribbon, click on the “FORMAT” button. Click the header for column A to select the whole column.Also, column A, which has no data and is just a spacer, should be very narrow. For example, the “PAYEE” and “DESCRIPTION” columns could hold long names or lengthy memos. The default size of some of the columns will likely be too small to hold the data you will put in them. Type “BALANCE.” This is the current amount in your account after all transactions have been recorded. Move one cell to the right to cell K1 (column K, row 1).Type “INCOME CATEGORY.” As with the expense category column, options for this column will be created in a later step. Move one cell to the right to cell J1 (column J, row 1).Type “CREDIT.” This is where you record money coming into your account, also known as inflow. Move one cell to the right to cell H1 (column H, row 1).
Options for this column will be created in a later step. Type “EXPENSE CATEGORY.” You will leave this blank for now. Move one cell to the right to cell G1 (column G, row 1).Type “DEBIT.” This is where you record money that leaves your account, also known as outflow. Move one cell to the right to cell F1 (column F, row 1).Type “DESCRIPTION.” Record any details you want to remember about the transaction. Move one cell to the right to cell E1 (column E, row 1).Type “PAYEE.” This is the person to whom a check was made payable or to whom money was paid. Move one cell to the right to cell D1 (column D, row 1).Here you will enter the check number or the type of transaction, such as “ATM” or “deposit.” Move one cell to the right to cell C1 (column C, row 1).
This is where you will enter the date of the transaction.
From the next popup menu, click on Microsoft Office.