Quick Start: Edit and enter data in a worksheet

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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.

How?

Icon image

Enter the data

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.

    Excel  Ribbon Image

  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.

    Excel  Ribbon Image

    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, click the arrow next to General, and then click the format that you want.

    Font group on the Home tab

  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

Top of Page

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×