Newbe Dev Stack

Answer : Place the values in A1 through G1 In A2 through G2 enter: =RAND() In A3 through G3 enter: =INDEX($A$1:$G$1,MATCH(LARGE($A$2:$G$2,COLUMN()),$A$2:$G$2,0)) Each time the worksheet is re-calculated, a new permutation will be generated. I use a method similar to what Gary's Student posted, but I use RANK in my formula instead. I think this simplifies the formula and makes it a little easier to understand. For sample data in A1:G1 : dog mouse rhino ape cat fish rat Fill the formula =RAND() across A2:G2 . Then fill the formula below across A3:G3 . =INDEX($A$1:$G$1,RANK(A2,$A2:$G2)) This is good for a one-off or a small number of rows. For a more robust solution, I would use VBA. The macro below will allow you to select the values you want to shuffle and specify the number of permutations you'd like to create. The permutations will be printed to a new sheet, where you can copy and paste them wherever you like. Sub nP...

Answer : Yeah, just multiselect the cells and click the borders button o the Main Tab. On the menu, select Line color and have at it. edit Forgot about the obvious answer. Format Painter. I got the answer, found it myself, On the menu, select Line color, then you'll see a pencil, click on a cell then press ctrl and drag the pencil trough the desired cells. Check it by yourself !