To work with data on a worksheet, you first have to enter that data in the cells on the worksheet. Then, you might want to adjust the data so that it is visible, and display it just the way that you want.
Enter the data
Tip To enter data on a new line in a cell, enter a line break by pressing ALT+ENTER.
For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells.
Select the cells that contain the starting values, and then drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) across the range that you want to fill.
Tip To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.
Under Cell Size, click AutoFit Column Width or AutoFit Row Height.
Tip To quickly autofit all columns or rows in the worksheet, click the Select All button, and then double-click any boundary between two column or row headings.
Format the data