Enter the Same Data or Text into Multiple cells at once
https://www.computersprofessor.com/2017/07/enter-same-data-or-text-into-multiple.html
Enter the
Same Data or Text into Multiple cells at once:
In Microsoft Excel, you can
enter the same data or text into multiple cells at once using the below simple
steps.
1.
Highlight all
the cells that
you want to have the same text.
2.
Type the text you want.
3.
After typing the text,
instead of pressing Enter, press Ctrl+Enter.
After
completing the above steps, the text will automatically be entered into all
highlighted cells. This tip can be very useful any time you have data that has
the same prefix and just need to add something to the end of each cell.
