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”.

Wednesday, June 29, 2016

How to play CD's and DVDs in Windows 10

In case you are not aware, Microsoft removed the media player in Windows 10 for many people. This means you may not automatically be able to play a CD or DVD. 
According to Microsoft, if you upgraded your computer from Windows 7 Home Premium, Professional, Ultimate or 8/8.1 Pro they have provided you an app that will install automatically with Windows updates. (Although I haven’t seen it.) It is named, “Windows DVD Player”.  If you did a clean install of Windows 10 or purchased a new computer with Windows 10, you will not have a Microsoft player.  You can purchase the player from the Microsoft Online Store at a current price of $14.99.
I found a free player, VLC Media player, which works great! Click on the link below to download.
http://www.videolan.org/vlc/index.html

Friday, April 29, 2016

Windows 10 Shortcut - Remove a Program

Here’s a quick shortcut to remove a program in Windows 10: 

  1. Right-click on the Start button.
  2. Click Programs and Features.
  3. Right-click on the program you want to uninstall.
  4. Click Uninstall.

Wednesday, March 9, 2016

Remove Hyperlinks from Data Copied from Internet

Sometimes when you copy data or pictures from the internet and paste it into your own document, you might notice that there is a link connecting the data to a location on the web.  
If you want to remove that connection, when you see the pointing hand indicator (with a suggestion to click to follow link), do not click, but right click instead, and from the context menu, select Remove Hyperlink

Sunday, January 31, 2016

Using the Index in Windows 10

If you've upgraded or purchased a computer with Windows 10, you probably haven’t found all the changes to the Start menu. Check out the new Index.

First click the Start button, and then click “All Apps” (no longer “All Programs”).  













You will see a list of all the apps loaded on your computer in ABC order. (Note: The first time, you might only see a blank section. Just click in the blank section to bring up the index or app list.)

J
When you see the list of apps, just click on the “&” at the top of the screen, OR simply click the letter at the top of the list to view the index.

When the Index appears, click on the letter to view the list that begins with the selected letter.  For example: To open the Microsoft Solitaire Collection, click the letter “M” and then click the app name.

Tuesday, January 5, 2016

Copy and Paste Subtotal Rows to Another Location

Back in August 2015 I did a Helpful Hint on how to shade the subtotal rows, all at the same time, but I recently was asked if you could take only the subtotal rows, copy/paste them elsewhere.  Yes you can, using the same technique.
1.      Once you’ve applied subtotals, click on the “2” to view only the subtotals.
2.      Click in a cell containing a subtotal.
3.      Press Ctrl+a to select all.
4.      Press Alt+: (colon) to only select the subtotals and not the supporting data rows.
5.      Press Ctrl+c to copy the subtotal rows.
6.      Go to where you want to place the subtotals, click in the first cell.

7.      Press Ctrl+v to paste the subtotal rows!