Category Archives: Uncategorized

Microsoft Word: Quick Click Tricks

Microsoft Word has some built-in features that mean fewer clicks when selecting sections of text. Some of them you may already know. For example, double-clicking on a word will select the entire word. If you triple-click, you can select an entire paragraph.

There are a lot more shortcuts when it comes to making selections in Word.

To select

Do this

any amount of text Click and hold left mouse button to begin the selection. Drag the pointer over the text that you want to select.
line of text Move the pointer to the left of the line until it changes to a right-pointing arrow, and then click.
sentence Hold down CTRL, and then click anywhere in the sentence.
paragraph Triple-click anywhere in the paragraph.
multiple paragraphs Move the pointer to the left of the first paragraph until it changes to a right-pointing arrow, and then press and hold down the left mouse button while you drag the pointer up or down to select paragraphs.
large block of text Click at the start of the selection, scroll to the end of the selection, and then hold down SHIFT while you click where you want the selection to end.
entire document Move the pointer to the left of any text until it changes to a right-pointing arrow, and then triple-click.

Microsoft Excel: Fast Method to Fix Case

When exporting data to Excel, the formatting is sometimes not what you need. For example, if names are capitalized in the original source, they will also be capitalized in the exported data.

There is a fast fix for this.

Using formulas, you can convert text to all uppercase, all lowercase, or sentence case (first letter of each word capitalized). In a new column, begin by typing the equals sign (=) to start a new formula. Then, use one of the following formulas:

  • UPPER – uses the information from the target cell, creating a cell with all uppercase letters
  • LOWER – uses the information from the target cell, creating a cell with all lowercase letters
  • PROPER – uses the information from the target cell, creating a cell with an uppercase first letter of each word and all others lowercase.

Finally, enclose the cell name of the targeted cell in parenthesis. The formula to change cell B1 to sentence case (PROPER) is shown below.

Excel screen shot showing formula to change cell to sentence case

The formula circled above will create a cell that utilizes information from Cell B1. The resulting cell will contain the information from B1, capitalizing the first letter of each word.

You can easily repeat the formula down the column with autofill. Click on the green square at the lower right of a cell. Excel will use the formula to complete the cells you highlight. The formula will be adjusted to coordinate with the targeted cell.

Excel screen shot showing autofill

Click on the small, green square in the lower right corner of a cell. Then, drag to highlight the cells you wish to change. Excel will adjust the formula for you.

This method can also be useful if you inadvertently left the Caps Lock on.

Tuesday Morning Tutoring

 

computer help

Are you curious about how to change your default font in Microsoft Word?  Do you need to enter values in Excel that start with zero and want to know a quick way to do so?

NCTS  is now offering a dedicated weekly time slot to provide support for these types of questions and more.  Tuesday Morning Tutoring will be offered between 8:30 and 10:30 a.m. in the Engineering Training Lab at 153 J Hammond.

Each Tuesday, the NCTS training staff will be available to provide walk-in assistance for faculty and staff in the College of Engineering.

The training staff will continue to be available for on-demand assistance at other times.  Use the contact form below, email training@engr.psu.edu or call Vikki at 863-1197 or Dawn at 863-4666.