Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 01-28-2018, 09:22 PM
 
35,095 posts, read 51,207,670 times
Reputation: 62667

Advertisements

Is there anyone who can explain how to create a checkbook in Excel using the proper formatting, formula, etc?
I have read the books, trialed, errored and failed miserably and watched more than one very confusing video on youtube.


Thank you.
Reply With Quote Quick reply to this message

 
Old 01-28-2018, 09:38 PM
 
Location: Tricity, PL
61,632 posts, read 86,981,866 times
Reputation: 131583
Did you tried the free ready&easy to use templates?
There are many templates on the net.
Example: https://www.spreadsheet123.com/Excel...-register.html
Reply With Quote Quick reply to this message
 
Old 01-28-2018, 10:30 PM
 
35,095 posts, read 51,207,670 times
Reputation: 62667
Quote:
Originally Posted by elnina View Post
Did you tried the free ready&easy to use templates?
There are many templates on the net.
Example: https://www.spreadsheet123.com/Excel...-register.html
Elnina,
I did try it but failed miserably.
I cannot figure out how to get the formula copied to a new workbook then remove the parts I don't want.


I am not usually this computer challenged but Excel has always been foreign to me.


Thank you.
Reply With Quote Quick reply to this message
 
Old 01-28-2018, 11:59 PM
 
Location: Tricity, PL
61,632 posts, read 86,981,866 times
Reputation: 131583
When you find the right template that could work for you, just download it following the instruction, then right click and delete rows or columns you don't want to use.

Just check the net for free templates, find one (or more) you would like to try, and come back for more help. Someone here will walk you thru the download and set up process.

Start with googling: free Excel checkbook templates, then click on image folder to see the images to compare.
The one I recommended above is pretty easy to use, and still could be customized to fit your needs.

You might want to look at this too:
https://www.vertex42.com/ExcelTempla...checkbook.html
https://www.practicalspreadsheets.co...-Register.html
http://www.getexceltemplates.com/exc...-template.html

Last edited by elnina; 01-29-2018 at 12:11 AM..
Reply With Quote Quick reply to this message
 
Old 02-03-2018, 06:36 PM
 
Location: Cleveland, Ohio
16,541 posts, read 19,668,514 times
Reputation: 13322
Excel is a horrible idea to use for this.
Why not something dedicated to the task?

https://www.justapps.com/
Full version is $15.
Reply With Quote Quick reply to this message
 
Old 02-05-2018, 08:16 AM
 
Location: McAllen, TX
5,947 posts, read 5,466,637 times
Reputation: 6747
Here's a couple of FREE Excel templates already done for you from Microsoft.

https://templates.office.com/en-us/C...ter-TM00000043
https://templates.office.com/en-us/C...ter-TM10190983

Here's a free app called Moneypoint which will let you import check data from a CSV file which you may be able to download from your bank.
https://www.microsoft.com/en-us/stor...t/9wzdncrfjccd

Here's a link to buy Quicken Deluxe 2017 for $20
Quicken Deluxe 2017 - Intuit Digital

Quicken is and always has been the standard for checkbook and finance software. Why reinvent the wheel?
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Similar Threads

All times are GMT -6. The time now is 08:21 PM.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top