Friday, January 1, 2010

Enter repetitive data quickly

You can use this technique to enter data into a series of noncontiguous/Contiguous cells. Hold down the Ctrl key and click all the cells into which you want to enter data. Then, type the text you want to enter and press Ctrl+Enter. Excel will enter the typed text into all of the cells in the noncontiguous/Contiguous selection.

Regards,
Praveen KVC
2 January 2010

0 comments:

Post a Comment