Judy Hughes Training

Keep safe over the Christmas season and throughout 2021.

MS Word Tip
Meaningless Text
For testing, or to see how text looks in a given page:
1. Position the cursor at the beginning of a paragraph.
2. Type =rand() and press Enter. (you can use lowercase, uppercase, or mixed case.)

Locking the Zoom Factor in Excel
If using a touchpad, it's far too easy to change the zoom percentage inadvertently.
1. Display the File tab – Options- Advanced.
2. In the Editing area, make sure the Zoom On Roll with IntelliMouse check box is not selected.
3. Click on OK.
If you still want to use the trackpad to adjust the zoom factor, you can do so by holding down the Ctrl key as you drag down the trackpad.

Training during lockdown still happening albeit with masks, sanitizing spray and isolated offices. Here's a pic of one of my successful students during training.

Moving Text in MS Word without Affecting the Clipboard
1. Highlight (select) text to be moved.
2. Display the spot in the document where you want to move the information.
3. Holding down the Ctrl key as you right-click the mouse on the spot where the item should be moved. Word moves the highlighted item to where you right clicked.
The Clipboard is not involved. This means that if you had something on the Clipboard before the move, it is still there for later use.
To copy, hold down both the Shift and Ctrl keys in step 3.

Repeating Actions in Word, Excel, PowerPoint
If you want to repeat an action a single time, you can either press the F4 key or Ctrl+Y.

Noting Formatting Inconsistencies in MS Word
To check formatting inconsistencies—is not turned on by default, follow these steps:
1. Click on the File tab, then click Options.
2. At left, click Advanced.
3. Under Editing Options section, select Keep Track of Formatting check box.
4. Ensure Mark Formatting Inconsistencies checked. Click OK.
Word marks questionable formatting with a wavy blue underline. Right-click on the underlined text to see what Word feels may be wrong with the selection.

I'm still available online to help with any MS Word, Excel or PowerPoint issues you may have. You can email me on [email protected] or [email protected]

Inserting Dates into a Word Document
Display the Insert tab then click Date & Time in the Text group. Choose the date and time format from the dialog box.
At the bottom-right of this box, check ‘Update Automatically’ to insert a DATE field which always changes to reflect the current date (used in templates). If this check box is not selected, the date is inserted in your document as text, which doesn't change.

Removing Spaces in Excel Cells
If you have a lot of data containing spaces, for example, a large number of policy numbers with spaces. To remove those spaces, use the SUBSTITUTE function. If policy number is in cell A2, in cell B2 type: =SUBSTITUTE(A2," ","") The result is that cell B2 contains the policy number with all the spaces removed. Drag (copy) formula down to include all policy numbers containing spaces.

Insert Current Time in Excel Spreadsheet
Keep track of the time worked on different jobs. Select a cell and press Shift+Ctrl+: (Colon). Press Enter to accept the time.