Saturday, October 24, 2009

Fresh Repetitive Data

Bob is back! Greetings to all of my fellow Excel Enthusiasts; It is so good to be back on the blog after an unavoidable absence.

Here is a great little technique that I recently ran across. Although it is very intuitive to copy and paste repetitive data to a set of noncontiguous cells (copy data, select the cells and paste), entering newly typed data doesn’t work quite that way.

To enter new data into a series of noncontiguous cells, simply hold down the Ctrl key and select all of the cells into which you want to enter your new data. Then type the text you want to enter and (drum roll, please…) press Ctrl+Enter.

Bamm! Excel will enter the typed text into all of the cells in your selection. (How cool!)