Safely Delete a Column or Row in Excel November 12, 2009
Posted by computertrainer in Excel Tips.Tags: delete column, delete row, Excel
add a comment
Before you delete either a column or row in Excel you should be certain that it is empty. Just because you don’t see data on your screen does not mean that there is something in the column or row elsewhere in the worksheet.
To test to see if the column is empty:
- Click in row 1 of the column you want to delete
- Press Ctrl + Down Arrow
If you arrive at the bottom of the sheet (row 65,536 in Excel 2000-2003 or row 1,048,576 in Excel 2007), then the column is empty
Ctrl + Up Arrow will take you to row 1 in an empty column
To test to see if a row is empty:
- Click in column A of the row you want to delete
- Press Ctrl + the Right Arrow
If you arrive at column IV in Excel 2000-2003 or Row XFD in Excel 2007, then the row is empty
Ctrl + Left Arrow will take you to column A in an empty row
After testing and finding the column or row is empty, then it is safe to remove the column or row. The easiest method to delete the column/row is to Right-mouse click on the Column Letter or Row Number and then select Delete.
Add a Comment to a Cell October 22, 2009
Posted by computertrainer in Excel Tips.Tags: comment, Excel
add a comment
Comments are notes that you enter for a cell. You can add a comment to a cell that has constants or formulas.
- Right click the cell you want to comment on.
- Select Insert Comment.
- In the box, type the comment text.
If you do not want your name in the comment, select and delete the name. - When you finish typing the text, click outside the comment box.
By default you will see a red triangle in the upper right corner of any cell that has a comment. When you hover the mouse over a cell with the red triangle (comment), then the comment box will appear.
Standard Order of Operations in a Formula in Excel October 12, 2009
Posted by computertrainer in Excel Tips.Tags: calculations, Excel, math, order
add a comment
If you combine several operators in a single formula, Microsoft Excel performs the operations in the order shown in the table below.
If a formula contains operators with the same precedence (for example, if a formula contains both a multiplication and division operator) Microsoft Excel evaluates the operators from left to right.
To change the order of evaluation, enclose the part of the formula to be calculated first in parentheses.
Please Excuse My Dear Aunt Sally
( ) Parentheses — Calculate the values of all expressions inside parentheses or brackets first, using the standard order of operations, and working from the innermost parentheses out.
^ Exponents — Next, raise all numbers to the indicated powers.
* / Multiplication & Division — Next, do all the multiplications and divisions from left to right.
+ - Addition and Subtraction — Last, do the remaining additions and subtractions from left to right.
For example, =15-3*4 equals 3, not 48. Using the standard order of operation, 3 is multiplied by 4 giving you 12 and then that number is subtracted from 15. If you wanted an answer of 48 you would use parentheses … =(15-3)*4.
Calculate in Word October 5, 2009
Posted by computertrainer in Word Tips.Tags: calculate, perform math, Word
add a comment
Microsoft Word has a calculator that you can add to a toolbar. You don’t have to be in a table to perform math!
The Calculator is quick to use for any simple on-screen calculations in a Word document.
To add the Calculate tool to a toolbar, follow these directions:
- Right-mouse click on any toolbar, click Customize, then the Command tab.
- In the Categories list, select Tools.
- In the Commands list, find the Tools Calculate command and click on it.
- Drag the Tools Calculate command onto any toolbar. Remember you must see the I-beam to drop it to the toolbar.
- The button appears grayed out until you select an equation.
Office 2007:
- Click the arrowhead to the right of the Quick Launch Toolbar.
- Click More Commands.
- Select All Commands.
- Scroll to Calculate and click the Add button to add it to your Quick Access Toolbar.
Check it out. Type an equation, select it, and click the Tools Calculate (Calculate in 2007) icon. The answer appears in the status bar at the bottom of the window and is copied onto the clipboard. Click where you want the answer and press Ctrl+V to paste the answer.
Remember, + = Add, - = Subtract, * = Multiply, and / = Divide.
Also, remember the standard order of operations within formulas: Please Excuse My Dear Aunt Sally! (Details in next week’s blog.) 15 – 3 * 4 = 3, not 48!
Find and Replace Noun or Adjective Forms or Verb Tenses September 29, 2009
Posted by computertrainer in Word Tips.Tags: Find and Replace, Word
add a comment
To search for:
Singular and plural noun forms
For example, replace “apple” with “orange” at the same time that you replace “apples” with “oranges”.
All adjective forms
For example, replace “worse” with “better” at the same time that you replace “worst” with “best”.
All tenses of a root verb
For example, replace “sit” with “stand” at the same time that you replace “sat” with “stood”.
- On the Edit menu, click Find or Replace.

2003 Find and Replace Dialog Box

2007 Find and Replace Dialog Box
- If you don’t see the Find all word forms check box, click More.
NOTE: The More button is shown as the Less button in the screen shots above. - Select the Find all word forms check box.
- In the Find what box, enter the text you want to find.
- If you want to replace the text, enter the replacement text in the Replace with box.
- Click Find Next, Replace, or Replace All.
- If the replacement text is ambiguous, click the word that best matches the meaning you want.
For example, “saw” can be both a noun and a verb; click “saws” to replace nouns, or click “sawing” to replace verbs. - To cancel a search in progress, press ESC.
Notes
- If you’re replacing text, it’s a good idea to click Replace instead of Replace All; that way, you can confirm each replacement to make sure it’s correct.
- Use the same part of speech and tense for both the search and replacement text. For example, search for “see” and replace it with “observe” (both are verbs in the present tense).
Flip your Computer Screen with a Keystroke September 21, 2009
Posted by computertrainer in Windows.Tags: Flip screen
add a comment
A friend just phoned and somehow flipped her computer desktop screen upside down. How could she get it back right side up?
If you know the answer, it is easy. If you don’t, then you will get very dizzy because you will have to tip your head over to read!
To correct this flip of the screen use the following key combination: Ctrl + Alt + any of the Arrow keys.
Now, that was easy!
Add a Comment in a Cell’s Formula October 26, 2009
Posted by computertrainer in Excel Tips.Tags: comment, Excel
add a comment
If you want to add a comment to a cell with a formula but do not want the traditional Comment (see Add a Comment to a Cell posted on 10/22/09), then follow these steps to add the comment at the end of your formula.
You will not be able to see that there is a comment to the formula unless you click the cell that the formula is in. You’ll see the comment on the Formula Bar.