Dear Cecil: I was reading your article about whether your eyeballs pop out if you sneeze with your eyes open. I can tell you without a doubt what will happen if you have the misfortune to have your eyes open when you hurl, and probably when you sneeze. (I assume the pressure exerted is about equal.) You break the blood vessels in your eyes thus turning your eyes blood red and having them sore for a week or two â¦ yuck.
The easiest way to check for repeating words is to use Excel's Find and Replace feature. By using this feature, you can also replace the words with something else automatically. 1. Launch Excel 2010 on your computer and open the spreadsheet you want to edit. 2. Click the Home tab at the top of the Excel 2010 window. 3. Click the small arrowhead next to Find and Select in the Editing section at the top. 4. Select Find from the resulting menu to open the Find and Replace window. 5. Type the word you want to look up in the Find What box.
Sometimes you just don't want data to repeat itself. On an order form or an inventory sheet, for instance, you may not want a part number entered in one cell to repeat in another cell. You can use Excel's Data Validation feature to to prevent a value from appearing more than once in a range.In the example below, the range A2:A20 requires unique part numbers.o create this type of message box for your worksheet: Select the cells for which you need to punch in unique entries (here, the correct range to select is A2:A20). Choose Data, Validation and click the Settings tab. Choose Custom from the Allow drop-down list.