- #Find a checkbook tmeplate in excel for a mac install#
- #Find a checkbook tmeplate in excel for a mac software#
- #Find a checkbook tmeplate in excel for a mac Pc#
- #Find a checkbook tmeplate in excel for a mac free#
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. Enter the word “DATE” in cell B1 (column B, row 1).After that, create columns for debits (which are payments or withdrawals), credits (which are deposits) and the balance forward. Create columns for the date, check number, the payee and a description or memo. Use labels that you would find in an ordinary paper check book register. Click “Open” and then click “New.” This will bring you to a new, blank spreadsheet.Ĭreate column labels. To open Excel on a Mac, click on Excel in the dock.Click on the first template option, Blank Workbook, to open a new Excel spreadsheet. You will see a page with your recent files listed on the left and template options for new documents on the right. Then click on the Microsoft Excel tile to open Excel.
#Find a checkbook tmeplate in excel for a mac Pc#
By default, new Excel workbooks have three tabs. Each worksheet in an Excel workbook is in a separate tab. A workbook is an Excel file that contains one or more spreadsheets. Understand the difference between a worksheet and a workbook in Excel.For example, a cell in the fifth row of column D is named D5 (column D, row 5). The cell is named according to its row and column. Each box where a row and column intersect is called a cell. Columns run vertically and are ordered by letter.
#Find a checkbook tmeplate in excel for a mac free#
Or, you can use a free online app for your smartphone, tablet or computer.
#Find a checkbook tmeplate in excel for a mac install#
#Find a checkbook tmeplate in excel for a mac software#
Excel is a spreadsheet software program that allows users to manage data and perform calculations with formulas.