Wednesday, December 2, 2015

Change the Default Browser in Windows 10

The default browser in Windows 10 is called Edge.  If you want to change the default browser to something different, the browser you want to use has to currently be installed on your computer.

Follow the steps below to change your default browser.
  1. Click the Start icon in the lower left corner of the taskbar.
  2. In the Search box type: default programs.
  3. Click "Default Programs" to open the list of default programs.
  4. Scroll down to Web browser and click Microsoft Edge.
  5. A list of installed Browsers displays.  Click the Browser name to be your default browser.
  6. Close the window by clicking the "X".
  7. You're finished!

Sunday, August 2, 2015

Format Subtotal Rows ONLY in Excel

IF YOU ALREADY USE SUBTOTALS IN EXCEL, HERE IS A GREAT TIP:
Did you know that you can easily format the subtotal lines to stand out from the rest of the rows?  Here’s how:

1.  First apply subtotals to your data.
2. Click the "2" (top left corner) to view only the subtotals.
3. Click in a cell containing a subtotal.
4. Press Ctrl+A (to select all the subtotal data).
5. Press Alt+: (colon) to only select the viewed data and NOT the hidden rows.
6. Click the HOME tab and select a format of your choice.
7. Finished! Click back on "3" to view all data and only the subtotal rows should be formatted.

Sunday, June 28, 2015

Excel Tip - Wrap Text


Do you know the secret for wrapping text within a cell when the text you want to wrap is less than the cell width?


ANSWER: Click in a cell and type what you want to appear on the top line of the cell.  Press Alt+Enter and then type what you want on the next line.  If more lines are needed, repeat Alt+Enter, if finished, press ENTER.

EXAMPLE: 

Make sure the cell width is wide enough to display the longest line.  Type Bev Manwiller; press Alt+Enter; type phone number; press Alt+Enter; type website; press Enter.

Friday, May 1, 2015

Microsoft Word - Insert the File Path to the Footer

I often print Word documents that I have saved and then forget where I saved them.  If you insert the file path in the footer, you will always know where the file is saved.  Here's how:
  1. Open the document in Word.
  2. Click the Insert tab of the Ribbon.
  3. Click Footer > Edit Footer.
  4. On the Header & Footer Tools - Design tab of the Ribbon, click Document Info.> Field
  5. Select FileName.
  6. Under Field Options, click the checkbox, "Add path to filename".
  7. Click OK.
When you print the document, you will see the complete file path in the footer, of where you have saved the file.

NOTE:  These instructions apply to Word 2007, 2010, and 2013.

Thursday, January 1, 2015

How to Quickly Locate Your Mouse Pointer on the Screen

Press the Ctrl key on your keyboard.
A circle will appear around the mouse pointer to show you where the mouse is currently located.

NOTE: If this feature is turned off, follow the steps below to turn it on.

1.     In the search box in Windows 7 or 8, type “Control Panel”.

2.     From Control Panel, open “Mouse”.

3.     Click the Pointer Options tab, in the Mouse Properties dialog box.

4.     Click the check box, “Show location of pointer when I press the CTRL key.”

5.     Click OK.
 

Now try it out…press the Ctrl key on your keyboard.