Sunday, September 17, 2017

How to Create Custom Numbers in Excel

If you want your data to have leading text in each cell, i.e. ACCT - 12345, without typing the text each time, set up Custom formatting!

  1. In Excel, select all the blank cells where you want to apply the custom format.
  2. Press CTRL+1 (to open the Format cells dialog box).
  3. Select Custom from the Category list.
  4. Under Type, enter the text you want to automatically display followed by the minimum quantity of numbers (represented by zeros).
  5. Click OK.
  6. Now try typing just the numbers in the cells.  The text should automatically display!

Tuesday, January 10, 2017

Create a Checkbook Register in Microsoft Excel

You can download a free check register directly from Excel.  Here’s how:
1    1.  Open Excel.
2.  Click File > New
3.  In the search box, type: “check register” and then press ENTER.
4.  When the results of your search are displayed, select one.

5.  Click Create.
6.  Save the register to a location of your choice.

You now have an electronic check register that will automatically calculate your balance.

IMPORTANT NOTE: Enter your current balance in the first Deposit field so as not to delete the formula in the Balance column.
If you want to print the last few lines of the register to put in your checkbook to use while you are away from your computer, do this:
1.     Select only the data you want to print.
2.     Press Ctrl+p to view the print options.
3.     Select “Print Selection” (instead of “Print Active Sheets”)
4.     Click “Print”.