EXCEL white master to help ~ ~ ~ beg online so!
[Users questions | Browse:65 | Favorites]
Users questions: A column, the first cell A-1-1 second frame A-2-2 and there are a lot of cells, I would like to automatically populate as 123,456 samples directly pull down, but the law had changed, it is not A -3-3A-4-4, what means it? Annex is my approach, so you can separate from the Dynamic filling, but does not look good in two grid.
Experts answer: You can use the formula question = "A-" & ROW ()&"-"& ROW () to solve, you paste the formula into cell A1, and then fill down, you can achieve your request. See specific accessories. Attachment : 111 fill. Xls
Experts answer: You can use the formula question = "A-" & ROW ()&"-"& ROW () to solve, you paste the formula into cell A1, and then fill down, you can achieve your request. See specific accessories. Attachment : 111 fill. Xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.