Enter exactly the same text into multiple Excel cells at once

ساخت وبلاگ

In project 2010 standard , you are able to enter the same data or text into multiple cells at the same time using the below simple steps.

1.Highlight all of the cells that you want to have the same text.

2.Type the text you want.

3.After typing the written text, rather than pressing Enter, press Ctrl+Enter.

After completing the above mentioned steps, the written text will automatically be entered into all highlighted cells. This tip can be very useful any time you have data which has the same prefix and just have to add something to the end of every cell.

For example, the above mentioned steps were completed to enter "computer hope" in all the highlighted cells, as shown in the picture. Once completed, I could press F2 on a selected cell, visit the end, and add "1" to make the cell "computer hope 1". I could training for each cell to possess project 2013 standard hope 1 through 16.

buy cheap software...
ما را در سایت buy cheap software دنبال می کنید

برچسب : نویسنده : fwei1855942390 بازدید : 100 تاريخ : سه شنبه 4 آبان 1395 ساعت: 23:11