There are 13 clubs in the SACA Grade cricket competition. All clubs field four senior teams and 12 of the clubs have four junior teams competing in regular weekend competitions. Clubs also have teams involved in various competitions including: 1  XXXX Gold Grade Cricket; Premium State cricket competition;
Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). The first or last cell on a worksheet or in a Microsoft Office Excel table. Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.
5. Press Enter. Voila! Excel automatically fills all blank cells down your column with the same formula. If you want to switch back from a table to a simple range for some reason (I don't know any :)), select any cell in your table, then press the  Convert to range  button on the Design tab.. Select all the blank cells in a column. 2. Press F2 to edit the last selected cell and type some data: it can be text, a number, or a formula (e.g.  _unknown_ ). 3. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.