excel table how to make the line horizontal drag drag automatically change
Users questions: excel table horizontal line can also drag drag how automatic changes example: A1 A2 into a horizontal, rather than after dragging into B1
Experts answer: in B2 enter the formula "= INDIRECT (" A "& COLUMN ())", copy right need of premises such as J1, results in the above table Shown. Accessories: Book1.xls