The specialty retail chain Annaâs Linens filed for bankrupty protection last month and is set to close all their stores, according to the Ariz. â¦. The specialty retail chain Annaâs Linens filed for bankrupty protection last month and is set to close all their stores, according to the Arizona Republic. . The Costa Mesa, Calif.-based company, founded in 1987, is closing its more than 200 stores in the United States and Puerto Rico.
Let us say you have a list of values in range A1:A5 and you want to reverse the list. In an empty cell write =INDEX($A$1:$A$5,6-ROWS($A$1:A1)) and copy down. Boom, you get the reversed list. In the reversed list, first item is last item in the original list (ie 5th item in our case).
Instead, you can accomplish the same copy with a double-click instead of a drag. Set up your formula in the top cell, position the mouse in the lower right-hand corner of the cell until you see the plus, and double-click. Note that this option can copy the formula down as far as Excel finds data to the left.If you have row headers or other data in place, Excel continues to copy the formula.ou can always use the good oleâ copy and paste method. 1  Set up your formula in the top cell. 2  Either press Control + C or click the â Copy â button on the â Home â ribbon. 3  Select all the cells to which you wish to copy the formula.