Distribute Formula Title For Free

The function RAND () is Excel's random number generator. To use it, in Column C, type in the following = RAND() in each cell adjacent to every name. Or you can type this function in the top row (row 2) and simply copy and paste to the entire column, or click and drag.

The function =RAND() will re-randomize each time you make any changes to any other part of the spreadsheet. Excel does this because it recalculates all values with any change to any cell. (You can also induce recalculation, and hence re-randomization, by pressing the F9 key.)

Select a cell and enter a formula. Place the cursor where you want to use the name in that formula. Type the first letter of the name, and select the name from the list that appears. Or, select Formulas > Use in Formula and select the name you want to use.

Hold down Shift , click the objects that you want to align, and then click the Shape Format tab. Click Arrange > Align, and select an alignment option. If you displayed the gridlines, you will see that the objects are aligned on the grid.

Use the randomize range option To randomize the range, click on the square to the left of the A, above the 1, to select the entire sheet. Now that the range is selected, go to Data and then Randomize Range: Now the students are randomized! But, Ryan, you say, I want them back to be in alphabetical order!!

How to randomize a list in Excel with a formula Insert a new column next to the list of names you want to randomize.In the first cell of the inserted column, enter the RAND formula: =RAND() Copy the formula down the column.

Increase the spacing for text in a cell Right-click in the cell you want, and click Format cells. On the Alignment tab, change Vertical to Justify. Click OK. Your text is now distributed evenly inside the cell. If you change the height of the row, the text re-adjusts evenly to the new width.