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.

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.

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.

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.

How to change the size of your desktop icons

If you'd like to make your desktop icons smaller or larger, follow these steps:

1. Right-click on your desktop.
2. Click View 
3. Click ONE of the following:
• Large icons
• Medium icons
• Small icons.

SHRINK A WORD DOC TO 1 PAGE

If your MS Word document is automatically printing on 2 pages but you’d prefer to have it on 1 page, use a command to quickly shrink it to 1 PAGE!

The command is called, “Shrink One Page” and it’s found on the “Print Preview Edit Mode” tool.  

NOTE:  If you have Word 2007, skip this next section, because you already have this tool.  See section, Shrink your Word Document.

If you have Word 2010 or 2013, this tool is not found on the Ribbon or Quick Access Toolbar (QAT).  You will need to add it to the QAT. (The QAT is located in the top left corner of your MS Word screen, either directly above or below the Ribbon.)

Follow the instructions below to add the Print Preview Edit Mode to your QAT:

(NOTE: You will only need to add the tool once.  Then it will always be available every time you open MS Word.)

1.  Open Microsoft Word 2010 or 2013.
2. Right-click anywhere on the Ribbon.
3. Click Customize Quick Access Toolbar... 
4. In the Choose Commands from drop-down box select All Commands.
   
5. Scroll down the commands and select Print Preview Edit Mode.
6. Click the Add button in the center of the screen.
7. The command is added to the Quick Access Toolbar on the right.
8. Click OK.
9. Now the Print Preview Edit Mode can be opened from the QAT.

Shrink Your Word Document

1. Open the Word document you wish to shrink to 1 page.

2. DO ONE OF THE FOLLOWING
    --FOR WORD 2010 OR 2013: Click the Print Preview Edit Mode command on the Quick       Access toolbar

    --FOR WORD 2007: Click Office Button > Hover over Print > Click Print Preview

3. Click the “Shrink One Page” command on the Ribbon.

Add caption

If Word is able to shrink your document, it will automatically shrink to 1 page.  
Note: If your document contains graphics or tables, Word might not be able to shrink the document.

GoBack

When you press SHIFT+F5 (function key) in Microsoft Word, your insertion point will move to the last text that was edited in the document.  Press SHIFT+F5 again and it moves to the section that was edited prior to the last one.  Press SHIFT+F5 again and it moves to the section that was edited prior to the last two.

This feature is called "GoBack" and can be applied to the last 3 edits.