en uk

Editing data in a cell Microsoft Office 2007

    To edit data in a single cell, follow these steps:

    1. Double-click the cell that contains the data you want to edit.

    Excel displays a cursor in your selected cell.

    2. Edit your data by using the Backspace or Delete key, or by typing new data.

    If you click a cell, Excel displays the contents of that cell in the Formula bar. You can click and edit data directly in the Formula bar, which can be more convenient for editing large amounts of data.

    Changing the size of rows and columns with the mouse

    Using the mouse can be a quick way to modify the sizes of rows and columns. To change the height of a row or the width of a column, follow these steps:

    1. Move the mouse pointer over the bottom line of a row heading, such as the 2 or 18 heading. (Or move the mouse pointer over the right line of the column heading, such as A or D.)

    The mouse pointer turns into a two-way pointing arrow.

    2. Hold down the left mouse button and drag (move) the mouse.

    Excel resizes your row or column.

    3. Release the left mouse button when you're happy with the size of your row or column.

    Typing the size of rows and columns

    If you need to resize a row or column to a precise value, it's easier to type a specific value into the Row Height or Column Width dialog box instead. To type a value into a Row Height or Column Width dialog box, follow these steps:

    1. Click the Home tab.

    2. Click the row or column heading that you want to resize.

    Excel highlights your entire row or column.

    3. Click the Format icon that appears in the Cells group.

    A pull-down menu appears.

    4. Click Height (if you selected a row) or Width (if you selected a column).

    The Row Height or Column Width dialog box appears, as shown in Figure 7-17.

    Editing data in a
cell Microsoft Office 2007

    Figure 7-17:

    Enter a width for the column.

    5. Type a value and then click OK.

    Excel resizes your row or column.

    Excel measures column width in characters. (A cell defined as 1 character width can display a single letter or number.) Excel measures row height by points where 1 point equals ¥n inch.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.