An acquaintance of mine showed me a way to repeat text without using the autofill.  Here is a simple way to do it:

  1. Highlight several cells
  2. Type in the text in the active cell
  3. Click on Control+Enter key

There you have it!

Advertisements