Quick Start: Enter data in a worksheet in Excel Starter

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.


Icon image

Enter the data

  1. Click a cell, and then type data in that cell.

  2. Press ENTER or TAB to move to the next cell.

    Tip     To enter data on a new line in a cell, enter a line break by pressing ALT+ENTER.

  3. To enter a series of data, such as days, months, or progressive numbers, type the starting value in a cell, and then in the next cell type a value to establish a pattern.

    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 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.

Icon image

Adjust settings

  1. To wrap text in a cell, select the cells that you want to format, and then on the Home tab, in the Alignment group, click Wrap Text.

    Wrap Text

  2. To adjust column width and row height to automatically fit the contents of a cell, select the columns or rows that you want to change, and then on the Home tab, in the Cells group, click Format.

    Cells group

    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.

    Select All button

Icon image

Format the data

  1. To apply number formatting, click the cell that contains the numbers that you want to format, and then on the Home tab, in the Number group, point to General, and then click the format that you want.

    Excel  Ribbon Image

  2. To change the font, select the cells that contain the data that you want to format, and then on the Home tab, in the Font group, click the format that you want.

    Excel  Ribbon Image

Next steps

It's important to know how to enter data by typing it in the worksheet, but it's also important to know how to more or copy data from one place to another and how to insert or remove rows and columns, and how to move data around. To learn how, see Move or copy cells and cell contents and Insert or delete cells, rows, and columns.

Tip    Office.com is continuously updated with new content, including how-to articles, videos, and training courses. If the bottom of the Help Viewer says Offline and you are connected to the Internet, click Offline, and then click Show content from Office.com.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!