Tuesday, May 15, 2012

How to Duplicate Words in Excel


1. Double-click the icon on the desktop or click 'Start,' 'All Programs,' 'Microsoft Office' and Microsoft Excel 2010' to launch Microsoft Excel.
2. Type a word into the first cell and press 'Enter' to accept the entry and move to the next cell down.
3. Type a different word that starts with a different letter into the second cell down the first column and press enter.
4. Type the first letter of either word previously entered into the column and Excel will offer to automatically complete the entry to match the previously entered cell. Press 'Enter' to accept the entry or keep typing to make a new entry.
5. Press the 'Delete' key and then press 'Enter' if typing a shorter version of the previously entered word to accept the information as typed instead of the automatic completion suggestion.
6. Click 'File,' 'Options' and click on the 'Advanced' menu choice on the left to review the settings for automatic completion. Turn automatic completion on by checking the 'Enable AutoComplete for Cell Values' box or turn it off by clearing the check box. Click 'OK' to save the setting.

Blogger news