Hover the cursor dragon nest korean client over the border between columns D and.
Select the format you desire for the date and click on OK in the bottom right corner of the window.In this tab, click the down arrow next to the Color option.11 2 Format the dates.The row and column numbers in each cell have been automatically adjusted so the formula calculates correctly.You can choose to show the dollar sign if you desire.On a PC with Windows 7 or newer, click on the Windows icon in the lower left hand corner of your screen.20 In cell B4, type the word Categories.Formatting will clean all of this.Once you become more familiar with the template you can simply protect these columns from unnecessary changes using Excel's Protect Sheet option.
Move one cell to the right to cell K1 (column K, row 1).
Withdrawal: Total of Withdrawals column in the data input section.
Click on the cell name box and type Categories.
Part 5 Protecting Your Check Register 1 Lock the cells with formulas and protect the worksheet.Using Microsoft Excel, I created my own checkbook register template.This is where you will store all of the potential income and expense categories for your check register.This will allow you to place check boxes into your spreadsheet.Read more about me here or interact with me on twitter.Now that you have some data in these cells, adjust the column width to make the columns wider or narrower if necessary.Add more rows, adding additional rows can be little tricky as most formulas which calculate totals have to expand correctly to accommodate new rows that you will add.Right-click inside the selected range of cells.How you open the spreadsheet differs depending on the type of computer and operating system you are using.Darron Kendrick, CPA This could be done using the Filter option on the tool bar.E) Data Input section In Data Input section, the user needs to enter the transaction details as and when occur during the period.