wordexcel can set and select the text?
[Users questions | Browse:31 | Favorites]
Users questions:wordexcel inside, could be a certain set, then cells in the drop-down list, select from the list of words, without further manual input. Also, word of people fill in the blank if you want to set the grid, how to do? Thank you!
Experts answer: in Excel can be "effective" powerTo complete. For example, in certain cells, such as B5: B20, to choose to complete in Beijing, Shanghai, Shenyang and Dalian four city names can be as follows: 1, in a column of four cells, such as A3: A6 enter Beijing, Shanghai, Shenyang, Dalian . 2, select B5, point "the validity of data * * set" in "Allow "box select" sequence ", with" sources "box on the right arrow to guide the choice of red A3: A6, and check" to provide drop-down arrow "key, OK. 3, will be copied down to the B5 B20. 4, click B5: B20 in any of the cell, it will appear in the drop-down arrow to the right, point the drop-down arrow to select the four citiesOne city, can be filled into the cell. 5, WORD itself does not seem to have the capability, but can be used WORD interface at the top of the "Insert MicrosdftExcel worksheet" icon into Excel tables to implement the feature.
Experts answer: in Excel can be "effective" powerTo complete. For example, in certain cells, such as B5: B20, to choose to complete in Beijing, Shanghai, Shenyang and Dalian four city names can be as follows: 1, in a column of four cells, such as A3: A6 enter Beijing, Shanghai, Shenyang, Dalian . 2, select B5, point "the validity of data * * set" in "Allow "box select" sequence ", with" sources "box on the right arrow to guide the choice of red A3: A6, and check" to provide drop-down arrow "key, OK. 3, will be copied down to the B5 B20. 4, click B5: B20 in any of the cell, it will appear in the drop-down arrow to the right, point the drop-down arrow to select the four citiesOne city, can be filled into the cell. 5, WORD itself does not seem to have the capability, but can be used WORD interface at the top of the "Insert MicrosdftExcel worksheet" icon into Excel tables to implement the feature.
- Will Win7 driver how to find?
- My Sony laptop, and why the power light will start, but the screen does not light ah?
- My lenovo power adapter out whether to buy the original
- EXECl how to filter out duplicate data?
- Sound card, there are other problems? You help ~
- ThinkpadX200 choose which one? Expert advice!
- How to cancel hard disk partition?
- In the word in the toolbar can display all the tools options?
- IE browser problems?
- The word in how to set up multi-window browsing?
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.