#Balance checkbook excel template for mac plus#
Your cursor will change to a plus sign ( ). Click cell “E3” and hover your mouse over the lower-right corner of the cell. Enter the following formula in cell “E3” and press enter: =IF(A3,IF(ISNUMBER(FIND('Deposit',C3)),E2 D3,E2-D3),' ')ġ0. Enter your beginning checking account balance in cell “E2.”ĩ. Resize column D and E to 10.71 (80 pixels.)Ĩ.
Hover your mouse between column header “C” and “D.” Resize the column to 20.71 (150 pixels). Click your mouse and drag your mouse right to resize the column. Hover your mouse between column header “B” and “C.” Your mouse cursor will change to a vertical line with two arrows. Click the arrow next to the “Border” button and select “Bottom Border.” If you have trouble finding a button, hover your mouse over a button to view a description.ħ. Click cell “A1” and drag your mouse over to cell “E1.” Click the “Center” button in the Alignment section and the “Bold” button in the Font section. Click the dollar sign ($) located in the Number section on the “Home” tab.Ħ. Click the column “D” header and drag your mouse to column “E.” This action will select both columns. Select the format “3/14/01” in the Type section, and click “OK.”ĥ. Click the “Number” tab and click “Date” in the Category section. Right-click the header and select “Format Cells” from the drop-down menu.
Click the column “A” header at the top of your spreadsheet. Click cell “D1” and type “Amount.” Type “Balance” in cell 'E1.'Ĥ. Type “Check Number” in cell 'B1' and type “Description” in cell “C1.”ģ.
0 kommentar(er)
