Wednesday, January 16, 2013
Play It Again, Sam…
While it is common and 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 as swimmingly (as the British may say…).
To enter Repetitive 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 (a little drum roll, please…) press Ctrl+Enter.
And, Here’s lookin’ at you, kid, Excel will enter the typed text into All of the Cells in your selection. Now, that’s really nice.
This is may seem a bit elementary, but as any long-time Excel user will testify, “ The fundamental things apply as time goes by.”