I would give you my widths, but depending on your settings, they are going to be different. Change the column widths so that the register takes up the whole screen.Change the alignment for all of these cells to center. Also, change the font color as appropriate. Highlight A3:J4 and shade the area whatever color that you like.While you have this area highlighted, add a bottom border to it. If it makes sense, change the font color so that it is easily readable and looks nice. Highlight cells A1:J1 and shade the area whatever color that you like.I called mine “Checking Transaction Register.” Change the font size to 28. In cell A1, enter a title for your account register.This sets up a name range that we will use on the next “Checking Account Register” Tab. In the Name Box, which is to the left of the formula bar (it should read B5), type “Categories” into the box. Finally, highlight from cell B5 to the end of the shaded section.You can still add more categories by inserting rows inside of the shaded area.
![find a checkbook tmeplate in excel for a mac find a checkbook tmeplate in excel for a mac](https://i.ytimg.com/vi/V721JgNPw7U/maxresdefault.jpg)
Also, highlight from B5 to a few cells past your last expense entry, shade this area a lighter color, and put a border around it to make it look nice and neat.
![find a checkbook tmeplate in excel for a mac find a checkbook tmeplate in excel for a mac](https://i.pinimg.com/originals/87/02/f7/8702f70e2d6b9fa8e1797efca052a618.jpg)
![find a checkbook tmeplate in excel for a mac find a checkbook tmeplate in excel for a mac](https://i.pinimg.com/originals/60/2e/82/602e82429626d2662a9a4079eeac99e7.png)
I suggest having at least the following categories: Wages, Gifts Received, Interest Income, Dividend Income, and Miscellaneous Income. Beginning in Cell B6 and continuing downward, enter any income categories that you want to track.In cell B5, enter “*** Income ***” as a section heading.In cell B4, type “Categories” and then format the cell as bold and change the alignment to center.This tab will be where all of the potential income, expense, and whatever other categories you can think of are stored. Start by renaming one of the tabs as the “Categories” tab.