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.
|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.
||Hold down CTRL, and then click anywhere in the sentence.
||Triple-click anywhere in the paragraph.
||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.
||Move the pointer to the left of any text until it changes to a right-pointing arrow, and then triple-click.
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.
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.
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.
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 email@example.com or call Vikki at 863-1197 or Dawn at 863-4666.